SUMMARY

This section explains how to use the Oracle BI Administration Tool to create, edit, and maintain objects in the Presentation layer of the Oracle BI repository.

This section contains following topics:

• About the presentation layer

• Working with Subject Areas

• Working with Presentation tables and columns

Presentation layer

• The presentation layer provides a way to present customized, secure, role-based views of a business model to users.

• The presentation layer is built after the physical layer and the business model and mapping layer and adds a level of abstraction over the BMM layer.

• It is the view of the data seen by the end users so that the business users create reports according to that.

• In the presentation layer we don’t want to show few of the attributes in the BMM layer like key columns.

• It is important in BMM layer to define the key but for an end user it is not required. So you can hide key columns or recognize the data into presentation views (catalogs) and folders depending on the user requirement.

• Simplifying the view of the data for users makes it easier to craft queries based on their business needs thus making it user friendly.

• Proper naming conventions are provided in the presentation layers.

2. Subject Area

Subject areas (formerly called presentation catalogs) allow you to show different views of a business model to different sets of users.

Subject areas have to be populated with content from single business model. They cannot span business models.

Multiple subject areas can refer to the same business model.

Base measure is something which directly maps to the physical layer attribute. Calculated measure is the calculations performed on the BMM layer.

The existing subject area and its corresponding business model can be duplicated.

3. Presentation Tables

• Each subject area has the presentation table containing multiple presentation columns from one or more logical tables.

• Use presentation table to organize columns into categories that make sense to business users

• The names and object properties of the presentation tables are independent of the logical table properties.

4. Presentation Table Operations

Creating Alias Name

Each presentation object can have list of aliases for its name that can be used in logical SQL queries. To create the list of aliases, use the Alias tab for the appropriate presentation object.

When you change the name of a presentation column, an alias is automatically created for the old name, so the compatibility of the old name is preserved.

Note: You cannot rename a presentation layer object to a name that is already in use as alias for an object of the same type

5. Presentation column

Presentation columns define the columns that are used to build analyses in the Oracle BI interface.

When presentation columns are dragged from the BMM layer, presentation column names are, by default, identical to the logical names in the BMM layer.

To provide a convenient organization for your end users, you can drag a column from a single logical table in the BMM layer to multiple presentation tables.

Caution: When you drag columns to a presentation tables, make sure that the columns with the same name or an alias of the same name do not already exist.

1. Presentation column operations

To delete columns>Go to Presentations>Double click on facts>Select Columns>Remove

To rename columns>Presentations>Facts>Dollars>General>Deselect 'Use Logical Column Name' to create a custom name

To reorder columns>Presentation>Facts>Columns>Select and move a column or group of columns

6. Presentation Layer Mappings

Presentation layer objects map to objects in the BMM layer.

Subject areas map to business model, presentation tables typically map to logical tables, and presentation columns map to logical columns.

7. Connection between UI and Presentation Layer

The UI and presentation layer are close in execution and are related with each other. The User Interface shows you the data once the presentation layer has done any translation it needs to.

Selvi

Add comment