OBIEE 11G Notes2

1.      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.      Which analysis view type displays the results as a marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet.( select one of these :scroll/ legend/ ticker/ gauge)- Displays the results as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. You can control what information is presented and how it scrolls across the page.

3.      True of False: Oracle BI EE requires that the Web browser be set to accept cookies in order to login. Oracle BI EE requires that the Web browser be set to accept cookies. It uses a cookie to track a user's signed-in session.

4.      True of False: Users can add sub-folders to their personal folder in My Folders to organize their content in the way that is the most logical to them.

5.      In a pivot table to show the percentage a metric value is compared to the sum for a column, click on More Options on the column in the pivot layout and select Duplicate Layer. before choosing  Show Data As -> Percent of -> Column(select one of these :Replicate Column/ Percentages/ Copy Column/ Duplicate Layer)- Select Duplicate Layer.

The measure is displayed a second time in the pivot table, with the same name.
Click the More Options button, select Show Data As, select Percent of or Index of, then select the appropriate option.
 Note:
The Show Data As option is available only for items that are stored or calculated measures.

6.      You can use the Prefix section on the Advanced tab of an analysis to override any user variable or session variable that has been marked as available for updating.( select one of these :override/ prefix/ variable/ suffix)- You can use the Prefix section to override any user variable or session variable that has been marked as available for updating.

7.      Oracle BI EE provides a feature called double columns. When a repository is configured for the double column feature, column data includes a display column that has a code column mapped to it (that is, it has double columns). A display column contains the display values for the column data, for example, Excellent, Good, and Poor. A code column contains code values that uniquely identify display values and are consistent across users or locales, for example, the code values 1 (uniquely identifying Excellent), 2 (uniquely identifying Good), and 3 (uniquely identifying Poor).

8.      When an analysis is processed, the request is sent in the form of logical SQL statements to the Oracle BI Server.( select one of these : physical/ logical/ dimensional/ relational)

9.      Applying alternating colors to rows in a table format analysis is called:( select one of these : green bar styling/ red bar styling/ grey bar styling/ mutil-color bar styling)-

10.  The two types of hierarchical columns are (select one of these : level based and non-level based/ ragged and parent-child/ level based and parent-child/ grouped and ungrouped)

Level-based hierarchy — Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

Parent-child hierarchy — Consists of values that define the hierarchy in a parent-child relationship and does not contain named levels. For example, an Employee hierarchy might have no levels, but instead have names of employees who are managed by other employees. Employees can have titles, such as Vice President. Vice Presidents might report to other Vice Presidents and different Vice Presidents can be at different depths in the hierarchy.

11.  True or false: When displaying the results of an analysis, if the analysis contains at least one hierarchical column, then a pivot table is displayed by default otherwise a table will be displayed.

12.  True or false: When combining columns from multiple subject areas using Set operations the number and data types of the columns to combine must be the same. The number of rows that are returned for each column can differ.

The number and data types of the columns to combine must be the same. The number of rows that are returned for each column can differ.

You can select columns from the same subject area or from a different subject area, but the columns must have some commonality.

You can specify one Set operation for one collection of criteria. For example, if you create criteria from the A-Sample Sales subject area, you can apply only one Set operation to those columns. You cannot apply different Set operations to different columns in the collection of criteria.

You cannot use hierarchical columns, selection steps, or groups when you combine criteria.

13.  The Act As functionality enables you to act for another user in Oracle BI EE. This functionality is useful, for example, when you must work on another user's dashboard or content, or when IT support staff wants to troubleshoot another user's account. When the administrator authorizes you to act for another user, the administrator can grant you full access or restricted access to another user's account:

Full access — When you are granted full access, you inherit the target user's privileges and can change the user's default dashboard and modify the user's content and preferences.

Restricted access — When you are granted restricted access, you maintain your user privileges, but inherit the target user's permission for viewing data. Restricted access enables you only to view the user's data.

14.  An analysis map view contains a background or template map and a stack of   ______  that are rendered on top of each other in a window.( select one of these : planes/ layers/ tiers / pancakes)- A map that consists of a background or template map and a stack of layers that are rendered on top of each other in a window. A map has an associated coordinate system that all layers in the map must share. The map can be an image file, the object representation of an image file, or a URL that refers to an image file.

15.  When referencing a repository variable in a title view on an analysis, use the following syntax:( select one of these : @{biServer.variables.variablename}/ @{biServer.repository.variablename}/ @{variables.variablename}/ @{variablename})

16.  What are OBIEE objects that return a single Boolean value that is based on the evaluation of an analysis or of a Key Performance Indicator (KPI)?( :( select one of these :  Conditions/ Analyses/ Bins/ Actions)- Conditions are objects that return a single Boolean value that is based on the evaluation of an analysis or of a Key Performance Indicator (KPI). You use conditions to determine whether something is to be done, for example whether an agent is to deliver its content.

17.  An embedded mini-graph that, in conjunction with other mini-graphs and numbers, illustrates a single trend is called?( select one of these :spark/scatter/mini,bubble)-

An embedded mini-graph that, in conjunction with other mini-graphs and numbers, illustrates a single trend. Spark graphs are also known as sparks.

Sparks do not include axes or labels; they get their context from the content that surrounds them. Each type of spark graph has only one measure, which is hidden; the scale is relative to itself only.

18.  True or False: Selection steps, like filters, allow you to obtain results that answer particular questions. Selection steps are applied before the query is aggregated.

Filters	Displays the filters in effect for an analysis. Filters, like selection steps, allow you to constrain an analysis to obtain results that answer a particular question. Filters are applied before the query is aggregated.
Selection Steps	Displays the selection steps in effect for an analysis. Selection steps, like filters, allow you to obtain results that answer particular questions. Selection steps are applied after the query is aggregated.

19.  A repository variable is a variable that has a single value at any point in time.( select one of these: dynamic/ session/ presentation/ repository)-

A repository variable is a variable that has a single value at any point in time.

There are two types of repository variables:

·         Static — Repository variables whose value persist and do not change until the administrator decides to change them.

·         Dynamic — Repository variables whose values are refreshed by data returned from queries.

The administrator creates repository variables using the Oracle BI Administration Tool.

20.  Scorecards allow you to model the objectives and initiatives that comprise your corporate strategy, evaluate their performance by assigning ____________, and determine and display overall performance.( select one of these: hierarchies/ KPI's/ selection steps/ analyses)

21.  A variable is a variable that is initialized at login time for each user.( select one of these: repository/ presentation/ session/ request)

22.  A(n)   Skip-level    has  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.( select one of these: unbalanced hierarchy/ ragged hierarchy/ skip level hierarchy/ multi-level 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.

23.  four types of variables that you can use in an analysis : Session, Repository, Presentation, Request

24.  Users can dynamically select columns and change the data that is displayed in the views of the analysis using which view type?-( select one of these: attribute selector/ view selector/ column selector/ criteria

25.  You use the "Analysis editor: Advanced tab" to examine the XML code and logical SQL statement that is generated for an analysis

26.  Which type of analysis view usually plots one data point with an indication of whether that point falls in an acceptable or unacceptable range?( select one of these:  funnel/ table/ gauge/ pivot table)

shows a single data value. Due to its compact size, a gauge is often more effective than a graph for displaying a single data value

Gauges identify problems in data. A gauge usually plots one data point with an indication of whether that point falls in an acceptable or unacceptable range. Thus, gauges are useful for showing performance against goals.

27.   Master-Detail  linking of views enables you to establish a relationship between two or more views such that one view drives data changes in one or more other views.( select one of these:  Host-Client/ Master-Detail/ Header-Detail/ Parent-Child)

28.  True or False: A request variable lets you override the value of a session variable but only for the duration of a database request initiated from a column prompt.

29.  True or false: You cannot specify the sort order for hierarchy levels on the criteria tab of an analysis

30.  Which OBIEE objects  enable you to automate your business processe either by providing event-driven alerting, scheduled content publishing, or conditional event-driven action execution.(ibot/shcedulers/agents/)- Agents enable you to automate your business processes. You can use agents to provide event-driven alerting, scheduled content publishing, and conditional event-driven action execution. Agents can be scheduled or can be triggered by a specific condition, which enables you to deliver timely information to users.

31. A repository variable is a variable that has a single value at any point in time.( select one of these :repository/ session/presentation /dynamic)A repository variable is a variable that has a single value at any point in time.There are two types of repository variables:Static — Repository variables whose value persist and do not change until the administrator decides to change them.Dynamic — Repository variables whose values are refreshed by data returned from queries.The administrator creates repository variables using the Oracle BI Administration Tool.

32.1.      Selection steps are applied before the query is aggregated.-Filters: Displays the filters in effect for an analysis. Filters, like selection steps, allow you to constrain an analysis to obtain results that answer a particular question. Filters are applied before the query is aggregated.Selection Steps: Displays the selection steps in effect for an analysis. Selection steps, like filters, allow you to obtain results that answer .particular questions: Selection steps are applied after the query is aggregated.

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)