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.
Ensure that TM1 admin service is started. Start demodata TM1 server and open Server Explorer.
How to do it...
- Right-click on Dimensions and click on Create New Dimension to open Dimension Editor.
- From the Edit menu click on Insert Element.
- Add following dimension elements by clicking on Add after each one.
- Gross Sales Revenue
- Click on OK and save dimension as Commission_Measures.
- Close the window.
- Return to Server Explorer window and ...