The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

• A.The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.
• B.Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
• C.The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
• D.The presentation layer defines the relationship that is needed to create the DML.

Comment: *

Name: *

Email: *

Verification: *

Which language is used by OBIEE to query Essbase?

• A.SQL
• B.LINQ
• C.MDX
• D.DMX

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: *

Which of the following characteristics pertain to a "ragged" hierarchy?

• A.It can only be stored in an XML structure.
• B.A branch of the hierarchy may have a different number of levels than other branches.
• C.All values can have a maximum of six levels.
• D.It creates multiple levels of hierarchy in the database table.

Comment: *

Name: *

Email: *

Verification: *

The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.

• A.$10,000
• B.0
• C.1
• D.Year

Comment: *

Name: *

Email: *

Verification: *