Pass the Oracle Oracle Other Certification 1z0-591 Questions and answers with CertsForce

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

Denormalized data in the transactional system could be divided into different tables to increase performance.

Level-based Hierarchy

Level-based hierarchy is the first type of hierarchy in OBIEE.

Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

Dimension hierarchy levels allow :

* to perform aggregate navigation,

* to configure level-based measure calculations,

* users from Dashboard and Answers to drill down from one parent to a child level.

Special type of level-based dimension are supported:

* Unbalanced (or ragged) and Skip-level hierarchy

* time dimension to provides special functionality for modeling time series data.

In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.

A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.

B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.

C: OBIEE Clustering – Approach of Oracle BI Server Load balancing/Failover

In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects for which you have the appropriate permissions. Both Presentation Services and the web server must be running for you to open catalogs in online mode.

Use online mode when you want to make minor incremental changes or additions to the catalog, such as changes to permissions, updates to a single object, or migration of new objects to a production environment.

Note:

* You can open a catalog in one of two modes — online or offline. Both modes can operate against an actual production catalog, with no need for any downtime.

* Repository changes can be done in either online

or offline mode. Online mode is when BI Server

is actively reading the repository file (when a

user is logged in). Offline is when BI Server is

idle. Best practice is to develop in Offline mode.

Minor changes can be made when in online

mode.

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.

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.