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/Reference:
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.

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.Physical Layer
• D.Web Catalog

Comment: *

Name: *

Email: *

Verification: *

If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

• A.By creating four new logical tables sources
• B.By creating four new logical table sources and choosing each dimension's level of aggregationin the Content tab
• C.By creatingfour new logical table sources and using the Fragmentation content to specify theaggregation levels
• D.By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels

Correct Answer: B

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_fragmentation_cont
ent_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:
The Content tab of the Logical Table Source is used to define :

Comment: *

Name: *

Email: *

Verification: *

An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.
However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

• A.By modeling the many to many relationshipin the business model
• B.By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
• C.By creating the many to many join in the physical model
• D.By creating alogical table source (LTS) thatjoins the Employees and Jobs tables

Comment: *

Name: *

Email: *

Verification: *

Which variable does not use initialization blocks to initialize its values?

• A.Static Repository Variable
• B.Dynamic Repository Variable
• C.System Variable
• D.Non System Variable

Comment: *

Name: *

Email: *

Verification: *