On Line

"A. Variable Manager"

"Correct Answer: A y D
Explanation/Reference:
Horizonal Scaleout of System Components
* Used for adding additional managed servers (Java components) and system components to an existing cluster
* Used for scalability and failover
* Set up via the Universal Installer > Scale Out BI System option"

"Correct Answer: C y D
Explanation/Reference:
Note: The Administration tool is used to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.
Oracle Business Intelligence Administration Tool is available only for Windows operating systems.
The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.
Repositories can be edited with the administration tool in either online or offline mode.
The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items"

"Correct Answer: A, C y D"

"Correct Answer: C

Explanation/Reference:
Object–level security controls the visibility to business logical objects based on a user’s role. You can set up object–level security for metadata repository objects, such as subject areas and presentation folders, and for Web objects, such as dashboards and dashboard pages, which are defined in the Presentation Catalog.

1) Business logic object
This controls access to objects, such as:
* subject areas
* presentation tables
* presentation columns

For example, users in a particular department can view only the subject areas that belong to their department.

2) Web object security

This provides security for objects stored in the Web Catalog, such as dashboards, dashboard pages, folders, and reports. You can view only the objects for which you are authorized. For example, a mid–level manager may not be granted access to a dashboard containing summary information for an entire department."

"Correct Answer: C

VIC
Explanation/Reference:

Note 1: A level–based measure is a column whose values are always calculated to a specific level of aggregation.
The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.
Level–based measures allow :
* to return data at multiple levels of aggregation (the query grain and the level–based column grain) with one single query
* to create share measures (percentage), that are calculated by taking some measure and dividing it by a level–based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.

Note 2: To create a level based measure as the amount sold by region, you can:
* make a copy of the Amount Sold logical column
* and then
/ drag the logical column into its hierarchy level
/ or set the aggregation grain in the level tab of the logical column property."

"Correct Answer: A, B y C

VIC. Explanation/Reference:

Enterprise Install: This installation type assumes some familiarity with Oracle Business Intelligence. All software components are downloaded onto one computer. You can accept the default configuration settings or use your own. You use this installation type when you have an established Oracle WebLogic domain, and you want to extend it to the Oracle Business Intelligence application. This install option is typically used for more advanced deployments with multiple users, such as to scale out a deployment on additional computers.

Incorrect answers:

D, E: Simple Install
The default selection. All software components are downloaded onto one computer and configured with default settings. Oracle Business Intelligence runs after the installation is completed. This install option is typically used for a single user deployment, such as for demonstration or development purposes."

"Correct Answer: A, C y D

Explanation/Reference:

The Oracle BI Presentation Services Administration page provides the Manage Map Data link. This link displays the Manage Map Data page, where you can manage the logical and display versions of the data from various physical data sources. This defines the layers that content designers use when creating map views. The data that is available for managing maps and data is stored in Oracle Database as part of MapViewer.
Using this page, you provide:

* (A) Logical names to prevent any existing BI column mappings and map analyses from breaking because of changes to the physical data or to the data source.
* Display names so that the geographic data is meaningful to end users.

For (C) –layers, see 3–7 below.
For (D) –import images, see 11–12 below."

"Correct Answer: A y C
Explanation/Reference:
Incorrect answers:
D: In this scenario the data would be real–time."

"Correct Answer: D

Explanation/Reference:

Oracle Business Intelligence Enterprise Edition (OBIEE) Security is managed through:

a) BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options

b) BI Presentation administration accessed through Presentation Web Services.
* Manage Web groups and users
* Set Permissions for Web Catalog items
* Manage privileges and rights given to groups and users
* Control access to dashboards

c) Catalog Manager.
* Set permission for Web Catalog items (Dashboards and Dashboards pages)"

"Correct Answer: A

Explanation/Reference:

This warning indicates that the given column is only mapped to logical table sources that are disabled. The warning brings this issue to the repository developer’s attention in case the default behavior is not desired.
Reference: Oracle Fusion Middleware Metadata Repository Builder’s Guide for Oracle Business Intelligence Enterprise Edition, Common Consistency
Check Messages"

"Correct Answer: D
Explanation/Reference:
Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables."

"Correct Answer: A

Explanation/Reference:
MapViewer is shipped as part of Oracle Fusion Middleware. Its main deliverable is a J2EE application that can be deployed to a J2EE container, such as that for Oracle Fusion Middleware. MapViewer includes the following main components:
* A core rendering engine (Java library) named SDOVIS that performs cartographic rendering. A servlet is provided to expose the rendering functions to Web applications.
* A suite of application programming interfaces (APIs) that allow programmable access to MapViewer features. These APIs include XML, Java, PL/SQL, and an AJAX–based JavaScript API.
* A graphical Map builder tool that enables you to create map symbols, define spatial data rendering rules, and create and edit MapViewer objects.
* Oracle Map, which includes map cache and FOI (feature of interest) servers that facilitate the development of interactive geospatial Web applications.
Oracle Maps can be configured now in the map viewer as a built in layer."

"Correct Answer: C

VIC. Explanation/Reference:

Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication provider searches the identity store to verify the credentials provided.
See figure below.

Incorrect answers:
A: Policy Store: Contains the definition of Application Roles, Application Policies, and the mapping between them.A policy store can be file–based or LDAP–based.Oracle Business Intelligence permissions are granted by mapping users and groups from the identity store to Application Roles and permission grants located in the policy store.
B: Credential Store: It is responsible for securely storing and providing access to credentials required by Oracle Business Intelligence Applications components internally.For e.g, SSL Certificates stored here."

"Correct Answer: A
Explanation/Reference:
A data warehouse is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from multiple disparate sources. Data warehouses store current as well as historical data and are commonly used for creating trending reports for senior management reporting such as annual and quarterly comparisons."

"Correct Answer: D
Explanation/Reference:
Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables."

"Correct Answer: A

VIC. Explanation/Reference:

You can nest presentation folders in two ways.
1) You can enter a hyphen and a greater than sign in the description field of the table to achieve the result.
2) Or, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests to achieve the same result as shown below."

"Correct Answer: A y C

VIC. Explanation/Reference:

Note: A level–based measure is a column whose values are always calculated to a specific level of aggregation.
The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.
Level–based measures allow :
* to return data at multiple levels of aggregation (the query grain and the level–based column grain) with one single query
* to create share measures (percentage), that are calculated by taking some measure and dividing it by a level–based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates."

"Correct Answer: B

Explanation/Reference:

An action link is a link to an action that you have embedded in an analysis, dashboard page, scorecard objective, scorecard initiative, or KPI that, when clicked, runs an associated action.
Incorrect answers:
D: Use the Narrative view to add one or more paragraphs of text to appear with the results. Narrative text is useful for providing information such as context, explanatory text, or extended descriptions.
E: OBIEE "Greenbar" Customization
Green bar reporting is alternating the row background colour every odd and even row"

"Correct Answer: A<br />
<br />
Explanation/Reference:<br />
<br />
Security Manager – is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access."

"Correct Answer: B

Explanation/Reference:

The Repository can be configured within the Enterprise Manager. See Note 1 below.
Note 1: Once you’ve locked the Oracle BI Domain, you would then use the same screen back in Enterprise Manager to browse and select the RPD file, and then enter the password, twice.
Once you’ve entered these details you would then press theApply button, to save the changes. At this point, the RPD gets a sequence number after it, and it’s displayed as the current default online repository for the Oracle BI Domain.
Note 2: An OBIEE 11g system (or "Oracle BI Domain") is generally managed through a combination of Oracle Enterprise Manager Fusion Middleware Control, part of the Enterprise Manager "family", or through WebLogic Server Scripting Tool (WLST) scripts. Each Fusion Middleware Control instance as shipped with OBIEE 11g controls a single Oracle BI Domain (DEV, or PROD for example), and is installed along with WebLogic Server Admin Console in the WebLogic Admin"

"Correct Answer: B y C

Explanation/Reference:
B: Oracle Business Intelligence uses a role–based access control model. Security is defined in terms of Application Roles that are mapped to directory server groups and users.
To define a complete security model, you have then to define:
1. A security structure by creating this elements:
* The directory Server User and Group managed by the authentication provider.
* The application roles managed by the policy store provider
2. a security policy (permissions) split across the following components:
*Presentation Catalog
* Repository
* Policy Store to define the Application Policies managed by the policy store provider

D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.

C: No file NQServer.ini File.

E: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler"

"Correct Answer: B

Explanation/Reference:

Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data."

"D. Aggregate tables are created and stored on the BI Server."

"Correct Answer: A

Explanation/Reference:

NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.
The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.
Incorrect answers:
D: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler
The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services."

"Correct Answer: D
Explanation/Reference:
Purge and reseed once a week after the reports have run to improve report response time."

"Correct Answer: B
Explanation/Reference:
When you need to model many–to–many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table.
A bridge table allows you to resolve many–to–many data relationships.
Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables"

"A. Derived from other logical columns"

"A. Static Repository VariableExplanation/Reference:<br />
The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.<br />
Incorrect answers:<br />
B, C, D: Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.<br />
Reference; OBI Server Administration Server Guide, Version 10.1, Static Repository Variables"

"Correct Answer: A

Explanation/Reference:

In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects for which you have the appropriate permissions.B: Use offline mode when you want to make catalog–wide changes, such as globally renaming objects or moving multiple objects for reorganization. In a clustered environment, use the following procedure to make systemwide changes to the catalog.

C, D: No such modes."

"Correct Answer: B y C

Explanation/Reference:

B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table.
Incorrect answers:
A: Processing time reduction is an advantage.
D: Network traffic decreases with caching.
E: Administration overhead is low."

"Correct Answer: B
Explanation/Reference:
Intelligent Bursting and Output Tool (iBot).
iBot is an utility available in OBIEE which is used for reports scheduling as well as Alerts sent to the required recipients on different web accessible / communication devices."

"Correct Answer: A

ViC. Explanation/Reference:
OBIEE – Grain (Level of summarization)
Grain definition in the context of OBIEE.
The following list describes the different grains in navigating a query:
* Aggregation grain. The grain of the aggregate source of from a level based metrics
* Query grain. The grain of the request.
* Time Series grain. The grain at which the time series function aggregation is requested.
* Storage grain. The query in the example can be computed from daily sales or from monthly sales, or from quarterly sales.
Note:
The aggregation grain is defined in the content tab of the logical table source.
When the query grain match the aggregation grain of a logical table source, this one is used to create the physical query."

"Correct Answer: B

Explanation/Reference:
Steps for Creating Aggregate Tables in OBIEE
1. Create all Dimension Tables, Fact Tables & Hierarchies, which are required to be aggregated.
2. Go to ToolsàUtilities (from Administration tool menu bar), a dialog box will pop up with all available utilities.
3. Select Aggregate Persistence Wizard, and then click Execute Button.
4. Now Select appropriate path where you need to generate Aggregate Table SQL.
Note : Click Generate DDL file for first time generation of Aggregate Table
Click Next, to move to next page (Select Business Model & Measure Page)
In Select Business Model & Measure Page, Select Appropriate Business Model & then select associated Fact / Measure."

"Correct Answer: A
Explanation/Reference:
With the advent of 11G, MapViewer is installed as part of Oracle BI Enterprise Edition and deployed in the same domain as Oracle BI EE on the Web application server.
Before content designers can create map views, in the Manage map Data Administration page, the metadata must be configured:
* layers (theme) and map (zoom level)
* the mapping between Oracle BI EE data and spatial data"

"Correct Answer: B"

"Correct Answer: C
Explanation/Reference:
Note:
At the highest level, an OBIEE Metadata Repository includes three layers of information:
1. First, a Physical layer is defined. The metadata layer identifies the source data.
2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data.
3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end–user access."

"Correct Answer: D<br />
Explanation/Reference:<br />
The relationship is defined at the model and mapping layer.<br />
Note:<br />
At the highest level, an OBIEE Metadata Repository includes three layers of information:<br />
1. First, a Physical layer is defined. The metadata layer identifies the source data.<br />
<br />
2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data.<br />
<br />
3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end–user access."

"Correct Answer: A y D

Explanation/Reference:

A: Much of the configuration of OBI that used to be done in the NQSConfig.ini files can now be done using this front end console, which in turns updates the NQSConfig.ini file. Things in the NQSConfig.ini file that are set by EM are noted in the file with ‘# This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager’. Some things that needs to be setup manually in the NQSConfig.ini file are:
1. Usage Tracking
2. Dynamic Libraries
3. Query Optimization Flags
4. MDX Member Name Cache Section (SAP BW)
5. More specific General Settings where EM doesn’t contain the level of detail required
D: Cache Management Techniques include
• Inspecting the cache reports
• Configuring the cache parameters
• Setting caching and cache persistence for tables
• Using the Cache Manager
• Inspecting SQL for cache entries
• Modifying the Cache Manager column display
• Purging the cache entries manually using the Cache Manager"

"Correct Answer: B y C

Explanation/Reference:

B: Click Refresh All from the Oracle BI menu in PowerPoint to refresh all the refreshable objects in the presentation.
C: Right–click Table and select Insert as List from the shortcut menu. The Edit Prompts and Levels dialog box appears. Accept the default options and click Insert."

"Correct Answer: A ,B y C

Explanation/Reference:
Oracle BI Cluster Server Components
* Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active–passive mode.
* Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.
* Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.
* Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances."

"Correct Answer: A

Explanation/Reference:

If security attributes conflict, a user or group is granted the least restrictive security attribute."

"Correct Answer: C

Explanation/Reference:

Dynamic Repository Variables:
You initialize dynamic repository variables in the same way as static variables, but the values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a pre–existing one that contains a SQL query. You will also set up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh the value of the variable.
Note: The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it."

"Correct Answer: A"

"Correct Answer: C y D

Explanation/Reference:

There are static and dynamic repository variables.
Note:
Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage > Variables).
This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non–system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here’s a screenshot of a typical Variable Manager screen."

"Correct Answer: A

Explanation/Reference:

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 they’re used when appropriate."

"Correct Answer: B

Explanation/Reference:

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."

"Correct Answer: B

Explanation/Reference:

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."

"Correct Answer: D

VIC. Explanation/Reference:

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.
Incorrect answers:
A: Fact–based / Dimension–based fragmentation
The logical table sources have different columns."

"Correct Answer: A<br /><br />
<br /><br />
ViC. Explanation/Reference:<br /><br />
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:<br /><br />
* 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.<br /><br />
* 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."

"Correct Answer: B
Explanation/Reference:
In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files."

"Correct Answer: C

Explanation/Reference:

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"

"Correct Answer: A"

"Correct Answer: B
Explanation/Reference:
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."

"Correct Answer: B

ViC. Explanation/Reference:

B: Example:
1. Configure the new source table to have the ‘logical level’ under the content set to ‘Countries’ (the summarized level)
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"

"Correct Answer: A, C y E

Explanation/Reference:

A: The default Application Roles available after OBIEE 11g installation are BIAdministrator, BISystem, BIConsumer and BIAuthor.
Note: In OBIEE 11g, Application roles provide insulation between permission definitions and corporate LDAP Groups. Permissions are defined at Application Role level and changes to LDAP groups just require a reassignment of the Group to the Application Roles.

C: Application Roles, Policies, association of Policies to application roles and association of users and groups to application roles are managed using Fusion Middleware Enterprise Manager (FMW EM).
E: Object level permission association to Applications Roles resides in the RPD for repository objects. Permissions and Privilege for web catalog objects resides in the OBIEE Web Catalog. Wherever Groups were used in the web catalog and RPD has been replaced with Application roles in OBIEE 11g."

"Correct Answer: B y C

Explanation/Reference:

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 they’re used when appropriate.
C: The wizard then shows me a preview of the script it’s going to generate, and asks me if I want to create any more summaries. Here’s how the preview script looks – note that it’s not SQL, it’s 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.
Incorrect answers:
A: Not required."

"Correct Answer: B

Explanation/Reference:

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."

"Correct Answer: C

ViC. Explanation/Reference:

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–todate, you can use one of the OBIEE time–series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.
There’s much better support for Essbase–native features such as value–based hierarchies, alternate hierarchies, multiple alias tables
B: Alternate hierarchies are secondary rollups of members within the same dimension. The level zero members in the alternate hierarchy are called Shared Members, and point back to an identically named real member elsewhere in the dimension."

"Correct Answer: B

Explanation/Reference:

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.
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)"

"Correct Answer: D

Explanation/Reference:

In a Star Schema the dimensional tables does not need to be normalized.
A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.
Incorrect answers:
B: A star schema is a dimensional schema with a single fact table that has foreign key relationships with several dimension tables.
C, E: A star join is a primary key to foreign key join :
* of the dimension tables
* to a fact_table."

"Correct Answer: A
Explanation/Reference:
Level–based Hierarchy
Level–based hierarchy is the first type of hierarchy in OBIEE.
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.
Dimension hierarchy levels allow :
* to perform aggregate navigation,
* to configure level–based measure calculations,
* to configure level–based measure calculations,
* users from Dashboard and Answers to drill down from one parent to a child level.
Special type of level–based dimension are supported:
* Unbalanced (or ragged) and Skip–level hierarchy
* time dimension to provides special functionality for modeling time series data."

"Correct Answer: A
Explanation/Reference:"

"Correct Answer: A, C y D

Explanation/Reference:
A: OBIEE Federated Repository
Instead of moving data in to a single database, OBIEE – BI Administration can access multiple databases and create a single federated repository. OBIEE BI Answer uses this federated repository and build the ad–hoc reports and dashboards.
D: Repository Metadata Consists of 3 Layers
* The Physical Layer (Schema)
* The Business Model and Mapping Layer
* The Presentation Layer"

"Correct Answer: A y D

VIC. Explanation/Reference:

Modeling Time Series Function in OBIEE
Modeling Time Series Data
Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.
Because SQL does not provide a direct way to make time comparisons, you must model time series data in the Oracle BI repository. First, set up time dimensions based on the period table in your data warehouse. Then, you can define measures that take advantage of this time dimension to use the AGO, TODATE, and PERIODROLLING functions."

"Correct Answer: B y C

Explanation/Reference:
The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.
C: To add a new user to a repository
1 Open a repository in the Administration Tool.
2 Display the security manager by selecting Manage > Security.
3 Select Action > New > User to open the User dialog box.
4 Type a name and password for the user.
5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.
6 Click OK.
This creates a new user with default rights granted to it."

"A . True"

"Correct Answer: A y B
Explanation/Reference:
A: Authentication at the Oracle Business Intelligence Enterprise Edition Layer
The Oracle Product Lifecycle Analytics (Oracle PLA) application utilizes the Oracle Business
Intelligence Enterprise Edition Layer (OBIEE) layer’s platform authentication features.
You change the password for the PLMA.RPD repository file using the OBIEE Admin Tool.
B: LDAP Authentication
LDAP authentication is used as an alternative to storing user IDs and passwords in an Oracle BI repository.
You can set up the Oracle BI Server to take the user ID and password, and have it then pass the user ID and password to an LDAP server for authentication.
Reference: Oracle Product Lifecycle Analytics, Security Guide , Configuring and Using Authentication"

"Correct Answer: B

Explanation/Reference:
Incorrect answers:
D: Testing is present within the Discovery phase."

"Correct Answer: A y B

Explanation/Reference:

It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:
(A) * An alias is used to avoid circular joins and to configure self joins.
* You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.
* Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.
(B) * You can rename aliases to make physical and business model easier to understand."

"Correct Answer: A
Explanation/Reference:
The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.
OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository."

"Correct Answer: AB
Explanation/Reference:
There are two types of session variables:
System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non–system session variables).
Non–system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non–system variable that initializes the name of a user’s sales region.
The administrator creates non–system session variables using the Oracle BI Administration Tool.
Note: Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI Serv"

"E. Input data"

"Correct Answer: B
Explanation/Reference:
Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege."

"Correct Answer: A
Explanation/Reference:
The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:
The shared folder— Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.
The system folder — Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.
The users folder — Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses."

"Correct Answer: B

VIC. Explanation/Reference:
Denormalized data in the transactional system could be divided into different tables to increase performance."

"Correct Answer: B
Explanation/Reference:
You can specify a Driving table parameter in a complex join.
Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross–database joins when one table is very small and the other table is very large.
The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.
Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined."

"Correct Answer: C
Explanation/Reference:
Dimensional Modeling – Slowly Changing Dimensions
* Type 1 – Overwrite Original Value
A change does not require tracking
* Type 2 – Add a new record
With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history.
Each row does not correspond to a different instance of an entity but a different "state", a "snapshot" of the instance at a point in time.
Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions.
In the source system a lot of changes are daily made :
new customers are added, addresses are modified, new regional hierarchies are implemented, or simply the product descriptions and packaging change.
These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked.
By remembering history, we are then able to look at historical data and compare it to their current situ"

"Correct Answer: AB
Explanation/Reference:
Decrease query response time which will improve performance for Dashboards and Analysis."

"Correct Answer: D
Explanation/Reference:
You can define calculations in either of the following ways:
– Before the aggregation, in the logical table source. For example:
sum(col_A *( col_B))
– After the aggregation, in a logical column derived from two other logical columns. For example:
sum(col A) * sum(col B)
Incorrect answers:
A: Defining the Logical Key of a Fact Table
Foreign Key Logical Joins
If foreign key logical joins are used, the primary key of a logical fact table should then be comprised of the foreign keys. If the physical table does not have a primary key, the logical key for a fact table needs to be made up of the key columns that join to the attribute tables as follows.
B: You can find this functionality in the general property of a subject area in the repository.
The goal of this definition is to guide the BI Server to make the best choice between two possibles query path.
Multiple path occurs when, if you choose two attributes of dimensions that links together to tw"

"Correct Answer: B
Explanation/Reference:
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
Incorrect answers:
D: "How do I combine data from two different subject areas into one report?" Although there are a couple of very limited options for doing so within Answers – Union queries and Sub–queries, the real solution is that the Subject Areas themselves were probably not designed properly.
Note: Although each subject area must be populated with contents from a single business model, you can create multiple subject areas for one business model. For very large business models, you may want to do this to help users work with the content."

"Correct Answer: D"

"Correct Answer: A y B
Explanation/Reference:
Creating Logical Time Dimensions
Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy.
Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions:
* At least one level of a time dimension must have a chronological key.
* All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns."

"Correct Answer: C
Explanation/Reference:
A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation."

"Correct Answer: A
Explanation/Reference:
Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain."

"Correct Answer: C
Explanation/Reference:
In a standard OBIEE implementation, we generally want to purge and re–build the cache after every ETL (extract, transform, and load) run.
Incorrect answers:
A: A cache item might be out of date.
B: Cache reduces traffic to the back end database. At worst it does not change the amount traffic.
D: The cache disk should be at faster than the disk of the database.
E: OBIEE Caching and Cache Seeding
Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration."

"B. CurrentDay
C. CurrentMonth"

"Explanation/Reference:
BSO is preferred to ASO in the following scenarios:
* Top–down planning and allocation (Sales Forecasting)
* Cost Allocations across products and customers (Profitability Analysis)
* Currency conversion, inter–company eliminations(Financial consolidations)
Incorrect answers:
A: Aggregate Storage: When loading data into an aggregate storage database, you can replace the contents of the database or the contents of all incremental data slices in the database.
C: Aggregate Storage: Architecture that supports rapid aggregation, optimized to support high dimensionality and sparse data
D: ASO cubes are designed to provide rapid aggregation capabilities for much larger Essbase outlines, typically supporting many more (and larger) dimensions."

"Correct Answer: A
Explanation/Reference:
You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles.
While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.css) file.
You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search "custom.css"."

"D. Presentation Data Layer"

"Correct Answer: C
Explanation/Reference:
The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi–dimensional data source, rather than an SQL query against a relational star schema."

"Correct Answer: ABC
Explanation/Reference:
Pull the table and column definition into the physical layer
Use the OBIEE "import metadata" wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer."

"Correct Answer: A
Explanation/Reference:
BI EE uses the ADM driver to extract the data from HFM.
Note: HFM (Hyperion Financial Management)"

"Correct Answer: C
Explanation/Reference:
A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure."

"Correct Answer: BC
Explanation/Reference:
C: OBIEE Caching and Cache Seeding
Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.
For time–consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.
Incorrect answers:
D: Guided navigation is a feature of Oracle BI Interactive Dashboards that enables the content and layout of Oracle BI Interactive Dashboard to change dynamically based on changes in the information being analyzed."

"Correct Answer: ABC
Explanation/Reference:
BIEE 11g Install High level Steps :
Software Required
1. Database (Oracle, IBM DB2 or MS–SQL)
2. Repository Creation Utility (RCU)
3. OBIEE 11g (11.1.1.3 is latest OBIEE as of 30 April 2011)
4. WebLogic 10.3.3 (Optional – Only required for 64 bit machine or IBM AIX)
5. JDK 1.6 64 bit (Optional – Only required for 64 bit machine)"

"Correct Answer: B
Explanation/Reference:
Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under them, and some sales staff may have trainees under them."

"Correct Answer: C
Explanation/Reference:
Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique.
Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application."

"Correct Answer: C
Explanation/Reference:
Note: This source should be combined with other sources at this level (check box)
Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.
Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table.
Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned).
Reference: Siebel Business Analytics Server Administration Guide > Creating and Admin"

"B. MS Word"

"Correct Answer: D
Explanation/Reference:
All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL.
Reference: Oracle OLAP User’s Guide, What’s New in Oracle OLAP"

"Correct Answer: A, B y C"

"Correct Answer: B"

"Correct Answer: C y E"

"E. Comparing RPDs"

"Correct Answer: A"

"Correct Answer: B, C y D"

"A. WebLogic Clustering
B. Universal Installer > Scale Out BI System option
C. OBIEE Clustering"

"B. MS Excel
D. MS Word"

"C. Security Manager, Application Roles tab, Application role dialog box, Permissions"

"D. CurrentMonth"

"Correct Answer: ACD
Explanation/Reference:
WLS Embedded LDAP Server
*By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C)
– More robust directory for storing user details
– Recommended for >1000 users
* WLS Admin Server Console now used for creating and maintaining users (A)
* BI Server "outsources" all authentication, authorization to FMW11g (not B)
* BI Administration tool now used for subject area and row–level security, connection pool passwords only (D)
• WLS LDAP Server can be "swapped out" for alternative directories (MS AD etc)"

"Correct Answer: B
Explanation/Reference:
Example (see step 4 and 5 below): Getting Top–N Sales Reps for Year and Year–1
1. Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" –> "Logical Column…"
2. In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:"

"Correct Answer: B"

"A. ETL Load Date"

"Correct Answer: AB
Explanation/Reference:
A:
* Combining Relational and OLAP Data Sources: Oracle’s Common Enterprise Information Model allows users to combine data from a relational system and an OLAP source in a single calculation. For example, a user can compare sales forecasts from an Oracle CRM System with budget data from an Oracle Essbase planning application. To clients of the Common Enterprise Information Model, the forecast and budget data appear to be from the same logical source.
B:
Note: The Analytic Data Model (ADM) is an API used to access OLAP data and metadata. ADM is similar to JDBC, providing a single common API that hides most differences between OLAP data sources."

"B. Use an iterative approach
C. Start with a small model and then enhance the repository"

"A. Software Only Install"

"Correct Answer: B
Explanation/Reference:
The Oracle BI repository development process adheres to the classic Software Configuration Management (SCM)process, which utilizes a three–way merge to manage concurrent development.
The merge process involves three repositories:
1. The (Original|Received|Master|Parent) repository. The repository that you received before changed. You must keep it preciously unchanged.
2. The Modified repository. The repository that contains the customizations you made to the original repository.
3. The Current repository. Generally, the repository that is in production and where some customisations could have been performed by other people. In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository."

"Correct Answer: BE
Explanation/Reference:
B: Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.
E: The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise Edition Plus Samples
One Oracle Database Preinstalled and not hardened to host the schemas."

"orrect Answer: C
Explanation/Reference:
The rank measure is numbered from 1. The highest sales amount will be ranked 1."

"A. The lowest level of aggregation"