Loading data from multiple columns into a single column

In this recipe, we will be populating data from multiple columns into a single column using a TI process.

Getting ready

Ensure that TM1 admin service is started. Start demodata TM1 server and open Server Explorer.

How to do it...

  1. Right-click on Dimensions and click on Create New Dimension to open Dimension Editor.
  2. From the Edit menu click on Insert Element.
  3. Add following dimension elements by clicking on Add after each one.
    • Gross Sales Revenue
    • Commission
    • Commission%
    • Commission_hold
    • Commission_count
    How to do it...
  4. Click on OK and save dimension as Commission_Measures.
  5. Close the window.
  6. Return to Server Explorer window and ...

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.