Set Aggregation Content for Logical Table Sources in OBIEE1 . 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 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