When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

• A.The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
• B.The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
• C.Job Manager can be used to run the Aggregate Persistence script.
• D.The Extraction Transformation and Loading process creates the aggregate tables.

Comment: *

Name: *

Email: *

Verification: *

The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

• A.Changes to the repository can only be carried out in offline mode.
• B.Multiple developers can work on one repository at the same time.Results can be merged later on.
• C.All aspects of security are being held in the repository file.
• D.Opening the rpd.filein online mode results in performance Issues for the application user.

Comment: *

Name: *

Email: *

Verification: *

One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

• A.Data Quality Assessment
• B.Dashboard Testing
• C.Business Requirements Definition
• D.Technical Requirements Definition

Comment: *

Name: *

Email: *

Verification: *

Which option is not an example of a level-based measure?

• A.Regional Revenue
• B.Sales
• C.Brand Cost
• D.Employee Salary

Comment: *

Name: *

Email: *

Verification: *

Point-and-click generation of case statement logic can be accessed via which option?

• A.Column Formula -> Bins tab
• B.Compound Layout
• C.Column Properties -> Conditional Format tab
• D.Advanced Tab
• E.Subject Area metrics

Correct Answer: A

The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE
build a CASE statement for you in a formula (you can also create
a CASE statement yourself by using one of the functions that
appears under "Expressions" if you want). A CASE statement is a
lot like an IF-THEN-ELSE statement, except that it's a little easier
to read when you have multiple options. Basically, it puts values
in different buckets that you define.
Note:
Figure:

Comment: *

Name: *

Email: *

Verification: *