• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Building the Presentation Layer of a Repository in OBIEE

You have created the initial Sample Sales business model in the repository. You now create the Presentation layer of the repository. 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.
To build the Presentation layer you perform the following steps:
• Create a Subject Area
• Create Presentation Tables
• Create Presentation Columns
• Rename Presentation Columns
• Reorder Presentation Columns

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

78

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

79

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

80

Create Presentation Tables

1. Right-click the Sample Sales subject area and select New Presentation Table to open the Presentation Table dialog box.

81

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

82

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

83

4 . Repeat the process and add three more presentation tables: Products, Customers, and Base Facts.

84

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.

Create Presentation Columns

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

85

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.

86

3 . Drag the selected logical columns to the Time presentation table in the Presentation layer.

86

4 . 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 D3 Customer.
Base Facts: Drag Revenue, Units from F1 Revenue.

87

Rename Presentation Columns:

1. In the Presentation layer, expand the Products presentation table.

87

2. Double-click the Lob presentation column to open the Presentation Column dialog box. On the General tab notice that “Use Logical Column Name” is selected. When you drag a logical column to a presentation table, the resulting presentation column inherits the logical column name by default. In this example the Lob presentation column inherits the name of the logical column “Sample Sales”.”D2 Product”.”Lob”.

88

3 . Deselect Use Logical Column Name. The Name field is now editable.

90

4 . Enter Line of Business in the Name field.

91

5 . Click OK to close the Presentation Column dialog box. Notice that the presentation column name is now changed to Line of Business in the Presentation layer.

92

6 . In the BMM layer, expand D2 Product. Notice that the Lob logical column name is not changed. The point here is you can change object names in the Presentation layer without impacting object names in the BMM or Physical layers.

93

7 . In the BMM layer, rename the Prod Dsc logical column to Product. Notice that the name change is inherited by the corresponding presentation column.

94

8 . Make the following name changes to logical objects in the BMM layer so that the names of the corresponding presentation columns are also changed:
For the D3 Customer logical table:
Change Cust Key to Customer Number.
Change Name to Customer Name.

95

9 . Confirm that the corresponding presentation column names are changed.

96

At TekSlate, we offer resources that help you in learning various IT courses. 
We avail both written material and demo video tutorials. 
To gain in-depth knowledge and be on par with  practical experience, then exploer OBIEE Training.

Reorder Presentation Columns

1. In the Presentation layer, double-click the Time presentation table to open the Presentation Table
dialog box.

97

2. Click the Columns tab.

98

3 . Select columns and use the up and down arrows, or drag the columns. to rearrange the presentation columns into the following order from top to bottom:
Per Name Year
Per Name Half
Per Name Qtr
Per Name Month
Per Name Week
Calendar Date

99

4 . Click OK to close the Presentation Table dialog box and confirm that the presentation column order is changed in the Presentation layer.

99

5 . Repeat the steps to reorder the columns in the Products presentation table:
Brand
Line of Business
Type
Product

99

6 . Save the repository without checking global consistency.
Congratulations! You have successfully built the Presentation layer of a repository.

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Building the Presentation Layer of a Repository in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Building the Presentation Layer of a Repository in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.