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

Create Presentation Layer Objects in OBIEE

1 . In the Presentation layer, right-click the Sample Sales subject area and select New Presentation Table to open the Presentation Table dialog box.

1

2 . On the General tab, enter Customer Regions in the Name field.

1

3 . Click OK to close the Presentation Table dialog box. Confirm that the Customer Regions presentation table is added to the Sample Sales subject area in the Presentation layer.

2

4 . In the BMM layer, expand Sample Sales > D3 Customer.

2

5 . Drag the following logical columns from D3 Customer to Customer Regions in the
Presentation layer:
Address 1
Address 2
Area
City
Country Name
Estab Name
Postal Code
Region

State Province
State Province Abbrv
Your column names may be slightly different depending on how you renamed them.

2

6 . Reorder the Customer Regions presentation columns in the following order, from top to bottom:
Region
Area
Country Name
State Province

State Province Abbrv
City
Postal Code
Address 1
Address 2
Estab Name

2

7 . Double-click the Sample Sales subject area in the Presentation layer to open the Subject Area dialog box.

2

8 . Click the Presentation Tables tab.

Aspired to become an OBIEE 11g? 
Explore the post to discover the know-hows on OBIEE 11g Training Online.

2

9 . Reorder the presentation tables so that Customer Regions appears after Customers.

2

10 . Click OK to close the Subject Area dialog box. Confirm that the presentation tables appear in the expected order.

2

You now have two presentation tables, Customers and Customer Regions, mapped to the same logical table, D3 Customer. The D3 Customer logical table is mapped to two physical sources:
D3 Customer and D4 Address.
11 . Save the repository and check global consistency when prompted. You should receive a message that there are no errors, warnings, or best practice violations to report.

2

If you do receive any consistency check errors or warnings, fix them before proceeding.
12 . Click OK to close the consistency check message.
13 . Close the repository. Leave the Administration Tool open.

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Create Presentation Layer Objects 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 Create Presentation Layer Objects in OBIEE"

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.