Set Aggregation Content for Logical Table Sources in OBIEE

 

 Logical Table Sources in OBIEE

1 . Expand D1 Time --> Sources.

 

2 . Double-click the LTS1 Time logical table source to open the Logical Table Source dialog box.

These core tutorials will help you to learn the fundamentals of OBIEE 11g.  For an in-depth understanding and practical experience, explore "OBIEE 11g Training".

3 . Click the Content tab.

4 . Confirm that Aggregation content, group by is set to Logical Level and the logical level is set to Time Detail for the H1 Time logical dimension.

5 . Click OK to close the Logical Table Source dialog box.

6 . Repeat to verify or set content settings for the remaining logical table sources using the table and screenshots as a guide:  

Logical Table Source	Logical Dimension	Logical Level
LTS1 Product	H2 Product	Product Detail
LTS1 Customer	H3 Customer	Customer Detail
LTS2 Customer Address	H3 Customer	Customer Detail
LTS1 Revenue	H1 TimeH2 ProductH3 Customer	Time DetailProduct DetailCustomer Detail

         

7 . Save the repository and check global consistency. Fix any errors or warnings before proceeding. Notice that you did not have to make any changes to the Presentation layer. 8 . Close the repository. Leave the Administration Tool open.

For an in-depth understanding of OBIEE click on

• OBIEE 11g Tutorials
• New Features in OBIEE11g
• Checking Out a Project in OBIEE 11g
• Making Changes to the Repository in OBIEE
• Setting Up a Multiuser Development Environment in OBIEE