Creating the Expenses cube

In this recipe we will create an Expenses cube, which will be populated in part by data from spreadsheets, rules, and user input. Users will need to spread data in order to project some overhead expenses into different regions.

Getting ready

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

How to do it...

  1. Open Server Explorer in TM1 Architect.
  2. Create Expenses.csv as shown and save it in C:\Program Files\cognos\TM1\Custom\TM1Data\TI_Data.
    How to do it...
  3. Create a new Turbo Integrator process for Source, select Text, and for Data Source Name provide the above path ...

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.