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

The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

B: Example:

1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level)

b

2. Do the similiar setting for dimension table

Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table

Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique.

Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.

An action link is a link to an action that you have embedded in an analysis, dashboard page, scorecard objective, scorecard initiative, or KPI that, when clicked, runs an associated action.

The rank measure is numbered from 1. The highest sales amount will be ranked 1.

Download and installation of the client

The client install executable is available for download from the More Products menu in Oracle BI Interactive Dashboards and Oracle BI Answers.

See picture below.

Object-level security controls the visibility to business logical objects based on a user's role. You can set up object-level security for metadata repository objects, such as subject areas and presentation folders, and for Web objects, such as dashboards and dashboard pages, which are defined in the Presentation Catalog.

1) Business logic object

This controls access to objects, such as:

* subject areas

* presentation tables

* presentation columns

For example, users in a particular department can view only the subject areas that belong to their department.

2) Web object security

This provides security for objects stored in the Web Catalog, such as dashboards, dashboard pages, folders, and reports. You can view only the objects for which you are authorized. For example, a mid-level manager may not be granted access to a dashboard containing summary information for an entire department.

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).