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.
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...
- In the Server Explorer, create a new dimension with base level elements as follows:
- Save the dimension as Years and close the Dimension Viewer to return to Server Explorer.
- Create a new cube called Franchise_Revenue2 with following dimensions included: ...