Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Friday, 31 March 2017

Build Presentation Layer in OBIEE 12C


The Presentation layer exposes the business model objects in Oracle BI user interfaces so that users can build analyses and dashboards to analyze their data.

1. Right-click the white space in the Presentation layer and select New Subject Area to open the Subject Area dialog box.

2.On the General tab, enter Sample Sales as the name of the subject area.

3.Click OK to close the Subject Area dialog box. The Sample Sales subject area is added to the Presentation layer.

4.Right-click the Sample Sales subject area and select New Presentation Table to open the Presentation Table dialog box.
Build Presentation Layer in OBIEE 12C
Build Presentation Layer in OBIEE 12C


Build Presentation Layer in OBIEE 12C
Build Presentation Layer in OBIEE 12C


Please note that you are using the manual method for creating Presentation layer objects. For simple models it is also possible to drag objects from the BMM layer to the Presentation layer to create the Presentation layer objects.

When you create presentation objects by dragging from the BMM layer, the business model becomes a subject area, the logical tables become presentation tables, and the logical columns become presentation columns. Note that all objects within a subject area must derive from a single business model.

1.On the General tab, enter Time as the name of the presentation table.

2.Click OK to close the Presentation Table dialog box. The Time presentation table is added to the Sample Sales subject area

3.Repeat the process and add three more presentation tables: Products, Customers, and Base Facts.
Build Presentation Layer in OBIEE 12C
Build Presentation Layer in OBIEE 12C



1. In the BMM layer, expand the D1 Time logical table.


2. 2. Use Ctrl+ Click to select the following logical columns:
Calendar Date
Per Name Half
Per Name Month
Per Name Qtr
Per Name Week
Per Name Year


3. Repeat the process and add the following logical columns to the remaining presentation tables Products: Drag Brand, Lob, Prod Dsc, Type from D2 Product. Customers: Drag Cust Key, Name from D4 Customer.
Base Facts: Drag Revenue, Units from F1 Revenue.


Build Presentation Layer in OBIEE 12C
Build Presentation Layer in OBIEE 12C

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)