1z0-591 Exam Dumps - Oracle Certification Questions and Answers

Content Tab

Aggregation Content

You can define the aggregation (ie the group by) of:

by hierarchy level

by logical column

It helps you to define an aggregate navigation

Note: logical table source

Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.

The definition of the logical table source is used:

to specify transformations/calculations (in the column mapping tab),

to enable aggregate navigation and fragmentation (in the content tab)

The Content tab of the Logical Table Source is used to define :

any aggregate table content definitions (specify the grain of the physical tables),

fragmented table definitions for the source,

and WHERE clauses (if you want to limit the number of rows returned).

There are static and dynamic repository variables.

Note:

Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage > Variables).

This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non-system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here’s a screenshot of a typical Variable Manager screen.

In a Star Schema the dimensional tables does not need to be normalized.

A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.

Note 1: There are four types of variables that you can use:

Session

Repository

Presentation

Request

Note 2: Session Variables

A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.

There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

There are two types of session variables:

System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.

System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

Non-system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user's sales region.

The administrator creates non-system session variables using the Oracle BI Administration Tool.

Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.

You should use a logical column (not physical). In fact,in the Explanation of the exam, it displays a logical column.

It is asking for Which task (NOT Which Tasks).

Using Administration (not Administrator) link in OBIEE you can go to 'Manage Map Data' and manage map components.

Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under them, and some sales staff may have trainees under them.

NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.

The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.

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.