Adding a year dimension

In this recipe, we are going to create a new version of Franchise_Revenue cube that contains Year dimension as well as Months. The year should contain three years starting with 2008, and next, we will load data for 2008.

Getting ready

Ensure that TM1 Admin Server service is started and demodata TM1 server is running. Open TM1 Architect from the Start Menu.

How to do it...

  1. In the Server Explorer, create a new dimension with base level elements as follows:
    • 2008
    • 2009
    • 2010
  2. Save the dimension as Years and close the Dimension Viewer to return to Server Explorer.
    How to do it...
  3. Create a new cube called Franchise_Revenue2 with following dimensions included: ...

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.