An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

• A.By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar
• B.By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar
• C.By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar
• D.By creating a Presentation Folder called Time<parent> and then two subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>

Correct Answer: A

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.

Result

Comment: *

Name: *

Email: *

Verification: *

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

Why is it necessary to join multiple source tables to a single dimension?

• A.Because transactional source systems are often denormalized
• B.Because transactional source systems are often normalized
• C.Because a single source table often contains all the dimensions needed
• D.Because the dimensions tables are built in the transactional systems

Comment: *

Name: *

Email: *

Verification: *

The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

• A.Start and Stop BI Services
• B.Build Aggregate Queries
• C.Create Summary Tables
• D.Manage user logins

Correct Answer: A

Screenshot 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

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