OBIEE 11G Notes1

1.      What stores the objects, such as analyses, dashboards, and KPIs, that you and other users create using Oracle BI EE.( select one of these :Oracle BI Presentation Catalog/Oracle BI Metadata Repository/Oracle BI Server/Oracle BI Presentation Server)-

 You use the Oracle BI Presentation Catalog to store the objects, such as analyses, dashboards, and KPIs, that you and other users create using Oracle BI EE. Users have their own personal folder (My Folders), where they can store the objects that they create. The objects in a personal folder can be accessed only by the user who created and saved the content into that folder. Users can add sub-folders to their personal folders to organize their content in the way that is the most logical to them.

2.      True or False:  Any user can stored objects in a shared presentation catalog folder.- A combination of business logic security, catalog object security, and data level security determines who can view data and objects, edit objects, and delete objects from the catalog. Your administrator creates and maintains the catalog's shared folder structure.

3.      A subject area corresponds to the presentation  layer in an Oracle BI metadata repository.( presentation/metadata/physical/business model and mapping)

4.      When referencing a session variable Sales Region in an expression, use this syntax format:( "Market"."Region"=VALUEOF("SalesRegion")/"Market"."Region"=VALUEOF(NQ_SESSION."SalesRegion")/"Market"."Region"=(NQ_SESSION."SalesRegion")/"Market"."Region"=@(NQ_SESSION."SalesRegion"))

5.      Which chart type is suitable for showing a metric over a period of time?( line/pie/bubble/scatter). Shows quantities over time or by category.Line graphs are useful for showing trends over time.Can be used to plot multiple measure columns.

6.      After you have selected a subject area for an analysis, you can combine columns from one or more subject areas using   set operations such as Union or Intersect.(select one of these :merge/combo/logical/set). After you have selected a subject area for an analysis, you can combine columns from one or more subject areas using Set operations such as Union or Intersect. By combining columns, you create a new column for displaying the data in a different way.

7.      In order to override the default "No Results Returned" message on the Analysis Properties in the  No Results Settings box, select: (Display No Results Message/ Override Message/ Message Customization Text/ Display Custom Message).

Rather than display the default message, you can create a customized message to alert users. This message enables you to provide your own explanation for why the analysis returned no data.To create a custom message to alert users to no data in the results of an analysis:

Ø  Edit the analysis to which you want to add a custom message.

Ø  Click the "Analysis editor: Results tab".

Ø  Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.

Ø  In the No Results Settings box, select Display Custom Message.

Ø  In the Header field, enter the text of the header for the custom message.

Ø  In the Message field, enter the explanatory text.

Ø  Click OK.

8.       Analysis Editor with its purpose.

      ·         Criteria tab — Lets you specify the criteria for an analysis, including columns, and filters. You can specify the order in which the results should be returned, formatting (such as headings, number of decimal places, styles such as fonts and colors, and conditional formatting), and column formulas (such as adding a Rank or Percentile function).

·         Results tab — Lets you create different views of the analysis results such as graphs, tickers, and pivot tables. You can also add or modify selection steps.

·         Prompts tab — Lets you create prompts that allow users to select values to filter an analysis or analyses on a dashboard. Prompts allow users to select values that dynamically filter all views within the analysis or analyses. You can also create prompts for use with selection steps, both for member selection steps and qualifying condition steps.

·         Advanced tab — Lets you edit XML code and examine the logical SQL statement that was generated for an analysis. You can use the existing SQL statement as the basis for creating a new analysis.

9.      A pie chart shows data sets as percentages of a whole.

10.  A  subject area  contains folders, measure columns, attribute columns, hierarchical columns, and hierarchy levels that represent information about the areas of an organization's business or about groups of users with an organization.(select one of these : agent/ scorecard/ presentation catalog/ subject area)..

Subject areas usually have names that correspond to the types of information that they contain, such as Marketing Contracts, Service Requests, and Orders.

11.The administrator performs the following tasks:

Prepares a file of SQL code to use as the "template" for write back.

Grants appropriate privileges for setting up and using write back. For example, the administrator gives you the privileges to set up views in which users can modify values.

12.  Users of a dashboard page or an analysis might have the ability to modify the data that they see in a table. This ability is often referred to in OBIEE as  write back ?(select one of these :  write back/ post data/ insert processing/ data update/ data update)

Users of a dashboard page or an analysis might have the ability to modify the data that they see in a table. This ability is often referred to as "write back." Users can update a value in the view that is written back to the record in the data source or is used in other views in the analysis.

13.  Users with the appropriate privileges can create and issue a direct database request directly to a physical back-end database. (true/false)

14.  Which type of analysis view displays multidimensional data shown as a set of cells in a grid, where each cell represents a subset of data using a particular graph type. Data can be represented with graphs, microcharts, and numbers.(select one of these : pivot table/ map/ funnel/ trellis)

15.  A bulb shows data using a circle that changes color to indicate whether the data is within predefined limits.

Bulb gauges are useful when you must know what the status is, and not any indication of a specific value, or relative information about other threshold ranges.

16.  In the "Graph Properties dialog: General tab" (for graph or funnel graph), the "Gauge Properties dialog: General tab" (for a gauge), the "Table Properties dialog: Style tab" (for a table), or the "Pivot Table Properties dialog" (for a pivot table, select the Listen to Master-Detail Events box.

17.  If you want to:Add or remove related subject areas from which to select columns, click the Add/Remove Subject Areas toolbar button in the Subject Areas pane to display the "Add/Remove Subject Areas dialog".
  If you add a related subject area but do not add any columns from that subject area to the analysis, then the subject area is not related to the analysis after you close and re-open the analysis. all add columns must not from same subject area.

18.  Which type of column holds data values that are organized using both named levels and parent-child relationship?( select one of these : attribute column/ level based column/ metric column/ hierarchical column)- Hierarchical Column — Holds data values that are organized using both named levels and parent-child relationships. This column is displayed using a tree-like structure. Individual members are shown in an outline manner. Hierarchies allow you to drill deeper into the data, to view more detailed information. Examples include Time or Geography.

19.  When you create a new analysis, filter, or dashboard prompt, you first select the subject area with which you want to work.(select one of these :  browser/ security configuration/ subject area/ dashboard)

When you create a new analysis, filter, or dashboard prompt, you first select the subject area with which you want to work. This is known as the primary subject area and is displayed in the "Subject Areas pane". If, as you work, you find that you need more data, you can add additional subjects areas that are related to the primary subject area that you have chosen. (You can add related subject areas only if they are available for the primary subject area and only if you have permission to access them.)

20.  Select three OBIEE objects that allow you to limit  the data that is displayed in dashboards and analyses.( Filters/ KPI's/ Agents/ Prompts/ Selection Steps)

21.  True or false:  Hierarchical columns do not support the write-back capability but attribute columns, measure columns, and double columns do support the write-back capability.

22.  A channel links a master view to a detail view. It is the vehicle that carries master-detail events from the master view to the detail view. A channel links a master view to a detail view. It is the vehicle that carries master-detail events from the master view to the detail view. The same channel must be used for both the master view and the detail view in a master-detail relationship, for example, Channel1.

23.  True or false:  A skip-level hierarchy is one in which all the lowest-level members do not have the same depth. For example, a Time hierarchy might have data for the current month at the day level, the previous month's data at the month level, and the previous 5 years' data at the quarter level. This type of hierarchy is also known as an unbalanced hierarchy.- Ragged — A hierarchy in which all the lowest-level members do not have the same depth. For example, a Time hierarchy might have data for the current month at the day level, the previous month's data at the month level, and the previous 5 years' data at the quarter level. This type of hierarchy is also known as an unbalanced hierarchy.

·         Skip-level — A hierarchy in which certain members do not have values for certain higher levels. For example, in the United States, the city of Washington in the District of Columbia does not belong to a state. The expectation is that users can still navigate from the country level (United States) to Washington and below without the need for a state.

24.  What OBIEE object provides functionality to navigate to related content or to invoke operations, functions, or processes in external systems?( select one of these :Dashboard prompt/ Condition/ KPI/ Action)