Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?

• A.Single Sign-On (SSO)
• B.Database Authentication
• C.Business Logic Object Security
• D.External Table Authentication
• E.LDAP Authentication

Comment: *

Name: *

Email: *

Verification: *

A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

• A.By creating a derived measure by using the Logical Columns available
• B.By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
• C.By creating a derived measure by using Logic Columns available and changing the aggregation type
• D.By creating a derived metric by using the Expression Builder
• E.By creating a derived metric by using the Calculation Wizard

Correct Answer: B

Note 1: OBIEE offers two calculation types for measure in the repository:
logical
physical
You can define calculations in either of the following ways:
* Before the aggregation, in the logical table source.
* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A)
* sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.

Comment: *

Name: *

Email: *

Verification: *

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

When creating an initialization Block, which BI Administration function is used?

• A.Variable Manager
• B.Job Manager
• C.Identity Manager
• D.Projects Manager

Correct Answer: A

Open up the Administration tool, go to Manage then variables.
See screenshot below.

variable manager
Then follow this picture to create a new Initialization Block.

create init block
Name your Initialization block init_block_test.

big picture

Comment: *

Name: *

Email: *

Verification: *

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times.
How is this accomplished?

• A.Every day before Data Warehouse refresh
• B.Every day after Data Warehouse refresh
• C.Every Monday early morning
• D.Every Monday late night

Comment: *

Name: *

Email: *

Verification: *