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

Explanation
The Repository can be configured within the Enterprise Manager. See Note 1 below.
Note 1: Once you've locked the Oracle BI Domain, you would then use the same screen back in Enterprise Manager to browse and select the RPD file, and then enter the password, twice.

NewImage
Once you've entered these details you would then press the Apply button, to save the changes. At this point, the RPD gets a sequence number after it, and it's displayed as the current default online repository for the Oracle BI Domain.
Note 2: An OBIEE 11g system (or "Oracle BI Domain") is generally managed through a combination of Oracle Enterprise Manager Fusion Middleware Control, part of the Enterprise Manager "family", or through WebLogic Server Scripting Tool (WLST) scripts. Each Fusion Middleware Control instance as shipped with OBIEE 11g controls a single Oracle BI Domain (DEV, or PROD for example), and is installed along with WebLogic Server Admin Console in the WebLogic Admin Server, one of the two JVMs (the other being the managed server) that gets installed by default with OBIEE 11g. The screenshot below shows Fusion Middleware Control showing the status of the BI Server, Presentation Server and other system components within the installation.

Sshot 2

The "Edit Column Formula" dialog box has a second, very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that it's a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.
Note: Figure:

Explanation/Reference:
A: The default Application Roles available after OBIEE 11g installation are BIAdministrator, BISystem, BIConsumer and BIAuthor.
Note: In OBIEE 11g, Application roles provide insulation between permission definitions and corporate LDAP Groups. Permissions are defined at Application Role level and changes to LDAP groups just require a reassignment of the Group to the Application Roles.
See figure below:

C: Application Roles, Policies, association of Policies to application roles and association of users and groups to application roles are managed using Fusion Middleware Enterprise Manager (FMW EM).
E: Object level permission association to Applications Roles resides in the RPD for repository objects.
Permissions and Privilege for web catalog objects resides in the OBIEE Web Catalog. Wherever Groups were used in the web catalog and RPD has been replaced with Application roles in OBIEE 11g.
Note: Application Roles are introduced in OBIEE 11g. An application role is specific to the application.
They can be mapped to other application roles defined in the same application scope and also to enterprise users or groups, and they are used in authorization decisions.

Oracle BI Cluster Server Components *Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active-passive mode.
*Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.
*Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.
*Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances.