Home3

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Home2

Home

Sunday, April 09, 2017

OBIEE 11g Note 3

  •         To navigate to an analysis, a specific dashboard page, or dashboard, choose this type of action:. Navigate to BI Object(select one of these: Navigate to BI Object/Navigate to BI Content/Navigate to BI Path/Navigate to BI Analysis)
    ·         True or False: If you save the dashboard in the Dashboards subfolder directly under /Shared Folders/first level subfolder, then the dashboard is listed in the Dashboard menu in the global header. If you save it in a Dashboards subfolder at any other level (such as /Shared Folders/Sales/Eastern), then it is not listed
    ·         True or False:  After the user selects the prompt value for an inline prompt, the prompt fields disappear from the analysis and the only way for the user to select different prompt values is to re-run the analysis.- An inline prompt is an initial prompt, meaning that it only displays when the analysis is rendered. After the user selects the prompt value, the prompt fields disappear from the analysis and the only way for the user to select different prompt values is to re-run the analysis.
    ·         True or False:  The order of the columns as they are displayed in the view also affects conditional formatting.- The order of the columns as they are displayed in the view also affects conditional formatting. The order in the view affects the "grain" at which the values are displayed. You can think of "grain" as a level of aggregation. The conditional format applies when the column to format is displayed at a finer grain or the same grain as the column on which the format is based. If the column being formatted is of a higher grain than the column on which the format is based, then the format applies only if the condition is based on a measure column. If the format is based on an attribute column and the column to format is displayed at a higher grain, then the conditional format does not apply.
    ·         The dashboard prompt type that allows for selecting a range of numeric values is called a:-( slider prompt/choice prompt/choice prompt/range prompt)- You can use the Slider input option for numeric data values only. Depending upon the operator that you select, this option enables the user to select multiple values by specifying a range of values, or all values that are lesser than, greater than, or equal to a specified value
    ·         For a condition based on an analysis, the conditon is based on the _____  of the results of the analysis.( Boolean flag/aggregate value/row count/metric value)- For an analysis, the criteria is a row count and an operator to apply to the row count; for example, the row count equals 100.
    ·         True or false: A selection step can be overridden by a prompt value.
    ·         For a condtion based on a KPI, the criteria used to evaluate the condition is:( row count/KPI status/KPI range/KPI target value )- For a KPI, the criteria is a KPI status, for example, the KPI status is OK.
    ·         A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and BI Publisher reports.( executive document/briefing book/published collection/stored snapshot)
    ·         A ________  captures the path to a dashboard page and a simplified presentation of the dashboard prompts, for example:
    o   ...Action=Navigate&col1=Products.Color&val1="Armory"+"Clear"&col2=Periods."Month"
    o   &op2=gt&val2="05/01/1998%2012:00:00%20AM"(generated link/prompted link/dashboard link/value link)- When you create a prompted link, you can manually or programmatically manipulate the link, such as by adding different values for the prompts.
    ·         Conditions are objects that return a single Boolean value based on the evaluation of an analysis or of a Key Performance Indicator (KPI).
    ·         For a prompt,  Auto-complete is only available for the choice list  prompt type when the prompt designer selected the "Enable User to Type Value" option.() Note that auto-complete is not available for hierarchical prompts.
    ·         he look of a dashboard, such as background colors and the size of text, is controlled by:
    o   Skins — Skins control the way the Oracle BI EE interface is displayed, such as background colors, corporate logos, and the style sheets to use. Skins can be automatically assigned to users when they log on. Administrators can customize the default skin and create new skins.
    ·         styles control how dashboards and results are formatted for display, such as the color of text and links, the font and size of text, the borders in tables, the colors and attributes of graphs, and so on. They are organized into folders that contain Cascading Style Sheets (files with a .css extension), images, and graph templates.
    ·         An inline condition is a condition that you define at the point of use and do not save by name in the catalog. Instead it is saved as part of the dashboard page or agent.
    ·         True or false:  Named objects are those objects (like filters, groups, and calculated items) that are saved within an analysis.
    o   As you work with certain objects, you can create other objects that are saved with those objects. When you save one object with another, that object is saved "inline." You can save filters, groups, and calculated items inline. For example, you can create a group as part of an analysis. When you save the analysis, the group is saved "inline" or along with the analysis.
    o   In addition to saving these objects inline, you can save them as individual objects with the subject area in the Oracle BI Presentation Catalog. When you save an object on its own, its becomes a "named" object. Named objects provide reusability, because you can create one object and use it multiple times with any analysis, dashboard (for filters), or dashboard page (for filters) that contains the columns that are specified in the named object. When the named object is updated and saved, those updates are immediately applied to all objects where the named object is used.
    ·         The look of a dashboard, such as background colors and the size of text, is controlled by:( select one of these:Skins, styles, cosmetic formatting/HTML, Javascript, and SQL/Enterprise Manager/individual user configuration)
    ·         The look of a dashboard, such as background colors and the size of text, is controlled by:
    ·         Skins — Skins control the way the Oracle BI EE interface is displayed, such as background colors, corporate logos, and the style sheets to use. Skins can be automatically assigned to users when they log on. Administrators can customize the default skin and create new skins.
    ·         Styles — Styles control how dashboards and results are formatted for display, such as the color of text and links, the font and size of text, the borders in tables, the colors and attributes of graphs, and so on. Styles are organized into folders that contain Cascading Style Sheets (files with a .css extension), images, and graph templates. Administrators can customize some style sheets and create new style sheets. Users can override some elements in style sheets, such as table borders and text size, when formatting results in the Results tab.
    ·         Cosmetic formatting — Cosmetic formatting affects the visual appearance of results and dashboards. You can apply it to results, columns, and sections.

    ·         For a dashboard prompt to be applied to an analysis, the analysis must include what type of filter on the associated column?(is filtered/is prompted)
    ·         The types of actions that are available are categorized into two groups: those that ______  to related content and those that ____ operations, functions, or processes in external systems.( select one of these: navigate, invoke/browse, execute/link, document/drill, disable)
    ·         True or False: Calculated items are always displayed at the top of the column list in the order in which they were added
    ·         You can specify which links (Analyze, Edit, Refresh, Print, Export, Add to Briefing Book, and Copy) are to be included with analyses at the dashboard level. Note that you can set these links at the dashboard page level and the analysis level, which override the links that you set at the dashboard level.
    ·         Which type of column prompt style only allows for the user to select a single item from a list of values?( select one of these: listbox/radio button/choice list/check box)- The Radio Buttons input option provides the user with a visible list of all prompt values where a Radio Button is displayed before each prompt value. This option type is useful for short lists of values where the user is to select only one prompt value. To select a prompt value, the user scans the list and selects the radio button that corresponds to a particular item.
    ·         True or False: After you select the Convert this filter to SQL box, you can no longer view and edit the filter in the Edit Filter dialog.-  After you convert the filter to SQL statements, you can only view and edit the filter item as SQL statements in the Advanced SQL Filter dialog.
    ·         On dashboards,  columns  are used to align content, while  sections   hold the actual content.( select one of these:  columns, sections/sections, columns/templates, containers/sections, object containers)- Columns are used to align content, while sections within columns hold the actual content.
    ·         To provide event-driven alerting, scheduled content publishing, and conditional event-driven action execution use this OBIEE 11g object:( select one of these: delivered action/ Ibot/ agent/ scheduled analysis)- Agent is the correct answer.  Ibot was the term used in OBIEE 10g.
    ·         True or False: Combining and grouping column filters with AND and OR and NOT  Boolean operators enables you to create complex filters- Combining and grouping column filters with AND and OR Boolean operators enables you to create complex filters without requiring you to know SQL statements.  There is no NOT operator.

    ·         True or false:  A dashboard always consists of a single page containing multiple objects.- A dashboard can contain multiple pages.
    ·         You can create a group or calculated item as a way to display data in a table, pivot table, trellis, or graph. Groups and calculated items allow you to add new "members" to a column, when those members do not exist in the datasource. These members are also known as "custom  member"(select one of these: selected/custom/specified members)

  •  To create a calculated item on an analysis that obtains the current measure, such as dollar sales, of the item from the first, second, and third rows, and sums them together, use the following formula: sum($1,$2,$3)
  •     To make an agent available for subscription, in the Agent Editor on the _____ tab , the Publish Agent for Subscription option must be selected, and users, and Catalog groups and Application roles that are allowed to subscribe must be identified.( select one of these: Subscribers/ Delivery/ Recipients/ Schedule)- To make an agent available for subscription, in the "Agent editor: Recipients tab", the Publish Agent for Subscription option must be selected, and users, and Catalog groups and Application roles that are allowed to subscribe must be identified.
  •   Dashboard template pages   are dashboard pages that are used to populate the personal dashboards (My Dashboard) of new users on their initial login. This allows users to see one or more dashboard pages with content rather than an empty dashboard when they first log in.( select one of these:  Dashboard template pages/ Styles and skins/ Dashboard defaults/ Personal templates)
  • Actions  provide functionality to:Navigate to related content. Invoke operations, functions, or processes in external systems(Drill Paths/Actions/KPI's/Conditions). You can include actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs.
  •      Saved Customizations allow users to save and view later dashboard pages in their current state with their most frequently used or favorite choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse.( User Preferences/Stored Values/Saved Customizations/Saved Selections)- Saved customizations allow users to save and view later dashboard pages in their current state with their most frequently used or favorite choices for items such as filters, prompts, column sorts, drills in analyses, and section expansion and collapse. By saving customizations, users need not make these choices manually each time that they access the dashboard page.
  •    A  _________   captures the path to a dashboard page and all aspects of the page state, for example:
    o   http://localhost/10.1.3.2/saw.dll?Dashboard&_scid=7ndOC-SjmWo&PortalPath=%2Fusers
    o   %2Fadministrator%2F_portal&Page=p2&PageIdentifier=7fsg0r2sdssvgen4
    o   &BookmarkState=r78an1mbj0fj4lmqhdjfndvvai
          It is saved in the catalog as a hidden object and is accessible for a number of days, default is 30.-(select one of these: genertaed/book mark/saved/prompt link)- A bookmark link captures the path to a dashboard page and all aspects of the page state, for example:        http://localhost/10.1.3.2/saw.dll?Dashboard&_scid=7ndOC-SjmWo&PortalPath=
             %2Fusers%2Fadministrator%2F_portal&Page=p2&PageIdentifier=7fsg0r2sdssvgen4
             &BookmarkState=r78an1mbj0fj4lmqhdjfndvvai
        After you create a bookmark link, you can:
         Save the link as a bookmark so that you can return to the exact same page content at a later time.
         Copy and send the link to other users who then can view the exact same content that you are viewing, providing they have the same permissions as you and have access to the page.


         When you create a bookmark link, the state of a dashboard page is saved in the catalog as a hidden bookmark object for the amount of time that your organization specifies. The default is 30 days. See the administrator for the amount of time that your organization specifies. Because the state of a dashboard page is saved when you create a bookmark link, you can continue to modify the content of the page after you create the link

No comments:

Post a Comment