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...

  1. In Server Explorer for demodata right-click on Months dimension and click on Edit Dimension Structure.
    How to do it...
  2. From the Edit menu click on Insert Element and add the following with default options.
    • Q1
    • Q2
    • Q3
    • Q4
    • Total Year
    How to do it...
  3. In the preceding screenshot please note that though the weights are 0 they will be 1 when children are created in the dimension.
  4. The resulting dimensional ...

Get IBM Cognos TM1 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.