12th October, 2020
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.
2 . A new logical dimension, D1 TimeDim in this example, is automatically added to the business model.
3 . Rename D1 TimeDim to H1 Time .
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.
5 . Rename D1 Time Total to Time Total, and rename D1 Time Detail to Time Detail.
6 . Right-click Time Detail and select New Object > Parent Level to open the Logical Level dialog box.
7 . On the General tab, name the logical level Week and check Supports rollup to a higher level of aggregation.
8 . Click OK to close the Logical Level dialog box. The Week level is added to the H1 Time logical dimension.
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:
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us