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.