Free Oracle 1z0-591 Practice Exam with Questions & Answers | Set: 4

The relationship is defined at the model and mapping layer.

Note:

At the highest level, an OBIEE Metadata Repository includes three layers of information:

1.

First, a Physical layer is defined. The metadata layer identifies the source data.

2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data.

3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end-user access.

The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.

C: To add a new user to a repository

1 Open a repository in the Administration Tool.

2 Display the security manager by selecting Manage > Security.

3 Select Action > New > User to open the User dialog box.

4 Type a name and password for the user.

5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.

6 Click OK.

This creates a new user with default rights granted to it.

Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

Oracle Business Intelligence Administration Tool is Used to manage OBIEE server

Available only for Windows operating systems.

A Windows application that allows the BI Server administrator to create & edit repositories.

Can edit repositories in either online or offline mode.

Having a session manager and a cache manager in online mode.

If security attributes conflict, a user or group is granted the least restrictive security attribute.

It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:

(A) * An alias is used to avoid circular joins and to configure self joins.

* You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.

* Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.

(B) * You can rename aliases to make physical and business model easier to understand.

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

See screenshot below.

Then follow this picture to create a new Initialization Block.

Name your Initialization block init_block_test.

This warning indicates that the given column is only mapped to logical table sources that are disabled. The warning brings this issue to the repository developer's attention in case the default behavior is not desired.