Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain.

Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

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.

After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.

Figure:

Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.

There’s much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy levels.

So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, there’s a lot to recommend OBIEE 11g to users of the “legacy” Hyperion tools looking for a bit of a refresh of their BI environment.

Security Manager – is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.

Note: When you open the administration tool, you can reach the security manager by the Menu :

Manage > Security

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.

--------

In an Ibor or Agent, in the 'Destinations' tab you can set the 'Specific Devices' However, it is a Device or Delivery Profile the one used for alerts, see this OBIEE guide:

---------------x--------------

User's Guide

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/toc.htm

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544.pdf

page 218

What Are Devices and Delivery Profiles?

Devices and delivery profiles control how you will be reached when an alert is

generated by an agent and which devices receive the content:

¦ Device — A device is the medium used to deliver content to you. The content of

an agent can be delivered to a range of devices as an e-mail or SMS message.

¦ Delivery profile — A delivery profile specifies which devices to use to deliver

content to you, based on the priority of the content. You can define several

delivery profiles to meet your needs, and switch

---------------x--------------

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.

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

All others are names for level-based measure but Sales is a base measure.

Before you can run Oracle Business Intelligence 11g Installer, you must first create

required Oracle Business Intelligence schemas in an unhardened database. You use

a tool called the Repository Creation Utility (RCU) to create these schemas with

the appropriate permissions and data.

Note: The Administration tool is used to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.

Oracle Business Intelligence Administration Tool is available only for Windows operating systems.

The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.

Repositories can be edited with the administration tool in either online or offline mode.

The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items