Identify the two Object level security functions that are done on the repository by using the BI Admin tool.

• A.Assign users to a web catalog group
• B.Create a new repository group
• C.Create a new user in the repository
• D.Create a web catalog group
• E.Define permissions for Dashboard

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

Which option is used to enter the rank function when creating a new rank measure?

• A.Initialization Block
• B.Expression Builder
• C.Connection Pool
• D.Web Catalog

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:

3. Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
4. Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the
"Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
5. Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list.
Etc.

Comment: *

Name: *

Email: *

Verification: *

Which task can be performed after the Administrator link has been reached through logging into OBIEE?

• A.Associate map layers to columns
• B.Manage access to Subject Areas
• C.SSO enablement
• D.Start or Stop BI Managed Servers

Correct Answer: B,C,D

Explanation/Reference:
B: 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
C: Enable the SSO through the FMW Control.

D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line.

Comment: *

Name: *

Email: *

Verification: *

What are the two types of Session Variables?

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

Comment: *

Name: *

Email: *

Verification: *