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

Set Aggregation Content for 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.


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.

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.

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


Logical Table SourceLogical DimensionLogical Level
LTS1 ProductH2 ProductProduct Detail
LTS1 CustomerH3 CustomerCustomer Detail
LTS2 Customer AddressH3 CustomerCustomer Detail
LTS1 RevenueH1 TimeH2 ProductH3 CustomerTime 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 indepth understanding of OBIEE click on

Review Date
Reviewed Item
Set Aggregation Content for Logical Table Sources in OBIEE
Author Rating

“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 Set Aggregation Content for Logical Table Sources in OBIEE"

    Leave a Message

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

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.


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

    I agree to be contacted via e-mail.