OBIEE 11G Create a Logical Dimension for Time

1 . Use a different technique to create a logical dimension for Time. Right-click the D1 Time logical table and select Create Logical Dimension > Dimension with Level-Based Hierarchy.
Screenshot for Step
2 . A new logical dimension, D1 TimeDim in this example, is automatically added to the business model.
Screenshot for Step
3 . Rename D1 TimeDim to H1 Time .
Screenshot for Step
4 . Expand H1 Time . Notice that two level were created automatically: D1 Time Total and D1 Time Detail. D1 Time Detail is populated with all of the columns from the D1 Time logical table.
Screenshot for Step
5 . Rename D1 Time Total to Time Total, and rename D1 Time Detail to Time Detail.
Screenshot for Step
6 . Right-click Time Detail and select New Object > Parent Level to open the Logical Level dialog box.
Screenshot for Step
7 . On the General tab, name the logical level Week, and check Supports rollup to higher level of aggregation.
Screenshot for Step
8 . Click OK to close the Logical Level dialog box. The Week level is added to the H1 Time logical dimension.
Screenshot for Step
9 . Repeat the steps to add the remaining logical levels:
Month as a parent of Week
Quarter as a parent of Month
Half as a parent of Quarter
Year as a parent of Half
Your final results should look similar to the screenshot:
Screenshot for Step

No comments:

Post a Comment

Popular Posts