If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
Answer : B
Explanation: Content Tab -
Aggregation Content -
You can define the aggregation (ie the group by) of:
by hierarchy level
by logical column
It helps you to define an aggregate navigation
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/fact_table/obiee_fragmentatio n_content_one_column.jpg?w=432
Note: logical table source -
Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.
The definition of the logical table source is used:
-> to specify transformations/calculations (in the column mapping tab),
-> to enable aggregate navigation and fragmentation (in the content tab)
The Content tab of the Logical Table Source is used to define :
-> any aggregate table content definitions (specify the grain of the physical tables),
-> fragmented table definitions for the source,
-> and WHERE clauses (if you want to limit the number of rows returned).
Which of the following native features of Essbase are not supported in OBIEE 11g?
Answer : C
Explanation: If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.
Figure:
Sshot 30 -
Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at
Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.
Theres much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy levels.
So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, theres a lot to recommend OBIEE 11g to users of the legacy Hyperion tools looking for a bit of a refresh of their BI environment.
A customer would like to create a change and a % Change for Revenue at the same time.
How would they accomplish this?
Answer : B
Explanation:
After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change,
Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the
Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.
When creating Aggregate tables in the OBI repository by using the Aggregate Persistence
Wizard, which two statements are true?
Answer : B,C
Explanation: B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI
Server metadata layer so that theyre used when appropriate.
C: The wizard then shows me a preview of the script its going to generate, and asks me if I want to create any more summaries. Heres how the preview script looks note that its not
SQL, its a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT SELECT and so on SQL statements, optimized for the particular back-end database platform.
Script example:
"ag_Items"
for "Seminar - Complete"."Items"("Quantity")
at levels ("Seminar - Complete"."Customerdim"."State", "Seminar -
Complete"."Productdim"."Category", "Seminar - Complete"."Timedim"."Year") using connection pool "custdw"."CUSTDW_Pool" in "custdw".."CUSTDW";
Which three options apply to FMW Application Roles?
Answer : A,B,C
How do you get the BI plug-in for MS Office?
Answer : B
Explanation: Download and installation of the client
The client install executable is available for download from the More Products menu in
Oracle BI Interactive Dashboards and Oracle BI Answers.
See picture below.
http://gerardnico.com/wiki/_media/dat/obiee/moreproducts.gif
There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
Answer : B
Explanation: B: Example:
1. Configure the new source table to have the 'logical level' under the content set to
'Countries' (the summarized level)
b
2. Do the similiar setting for dimension table
Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table
Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.
Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
Answer : A
The Consistency Checker checks______.
Answer : B
Explanation: Consistency check is one of the process to check whether a repository is yielding proper results in Answer reports. It checks whether;* All logical columns are mapped correctly to physical columns (B).* All logical dimension tables have a logical key.*
There are at least two logical tables in the business model; one is a logical fact table, the other is logical dimension table with join condition.* There are no circular logical join relationships.* A presentation catalog exists for the business model.
A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
Answer : D
Explanation: You have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as
Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.
Identify the two types of storage for Essbase.
Answer : A
Explanation: Oracle Essbase developers creating planning and budgeting applications have been keenly aware of the advantages and disadvantages of the two different storage types available to them:
* Block storage option (BSO) databases support a wide range of calculations, including forecasts, allocations, and aggregations through procedural calculation scripts. The results of these calculations can be written back to the database, but applications that use BSO storage are limited to about 10 dimensions and member counts in the low hundreds of thousands.
* Aggregate storage option (ASO) databases can support about 20 dimensions and member counts in the millions. ASO databases use multidimensional functions rather than procedural scripts to perform calculations, but the results of queries cannot be stored back in the database, making ASO unsuitable for most financial management applications.
Where is Cache in OBIEE located?
Answer : B
Explanation: In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.
A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?
Answer : C
Explanation: Priority group -
You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.
For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is expensive, while access to a data warehouse is cheap. In this situation, you can assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.
Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source.
Priority Group Designation -
0 the highest-priority source (the default)
1 a lowest-priority source
Which OBIEE capability enables developers to build Aggregate tables?
Answer : A
Explanation: Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that theyre used when appropriate.
When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?
Answer : B
Explanation: Steps to Create a Dimension Hierarchy - >Create a dimension object.Add a parent-level object.Add child-level objects.Determine number of elements.Specify level columns.Create level keys.Create a level-based measure.Create additional level-based measures.Create share measures.Create rank measures.Add measures to Presentation layer.Test share and rank measures.