OBIEE 11G Set Aggregation Content for Logical Table Sources

1 . Expand D1 Time > Sources.
Screenshot for Step
2 . Double-click the LTS1 Time logical table source to open the Logical Table Source dialog box.
Screenshot for Step
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.
Screenshot for Step
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 Time
H2 Product
H3 Customer
Time Detail
Product Detail
Customer Detail
Screenshot for Step
Screenshot for Step
Screenshot for Step
Screenshot for Step
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.

No comments:

Post a Comment

Popular Posts