Adding additional levels in Months dimension
In this section we will be creating additional levels in Months dimension. We will be adding these levels manually using Dimension Editor.
How to do it...
- In Server Explorer for demodata right-click on Months dimension and click on Edit Dimension Structure.
- From the Edit menu click on Insert Element and add the following with default options.
- Total Year
- In the preceding screenshot please note that though the weights are 0 they will be 1 when children are created in the dimension.
- The resulting dimensional ...