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