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.
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.
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.
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 |
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 |
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 |
Comments
Post a Comment