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 OB
IEE 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 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 indepth understanding of OBIEE click on