When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

• A.It defines the granularity of the dimension.
• B.It determines the actual value of the dimension.
• C.It creates a new session variable.
• D.It creates a foreign key relationship.

Correct Answer: A

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.

Comment: *

Name: *

Email: *

Verification: *

When designing a Star Schema, which option does not apply?

• A.The facts are quantifiable.
• B.The fact has several foreign keys that are primary keys in the dimensional table
• C.Fact table is joined to the related dimensional tables.
• D.Dimensional tables are normalized.
• E.Dimensional tables have one attribute primary key as Product_ID for products.

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.
See picture below:

Comment: *

Name: *

Email: *

Verification: *

Which option describes how OBIEE natively integrates with HFM?

• A.Through EPM Analytic Data Model (ADM) connectivity
• B.Direct relational database access
• C.Through Essbase connectivity
• D.OBIEE does not support HFM integration

Correct Answer: A

Explanation
BI EE uses the ADM driver to extract the data from HFM.
Note: HFM (Hyperion Financial Management)
Example:
I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to basically make the EPM environment variables available for access to BI EE. Before making the changes, there are a couple of things to be aware of
1. Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client to work/connect properly with HFM Server.
2. Ensure that HFM Client is installed.
The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re-iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the pre-requisite steps are done, we start off with the metadata import process.

NewImage

Comment: *

Name: *

Email: *

Verification: *

To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option?

• A.Presentation Layer
• B.Business Aggregate Layer
• C.PhysicalLayer
• D.WebCatalog

Comment: *

Name: *

Email: *

Verification: *

An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD?

• A.By creating two Logical Fact Tables for each database
• B.By creating joins in the physical model so it looks like a single table
• C.By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
• D.By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.
• E.By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box

Comment: *

Name: *

Email: *

Verification: *