Creating a cube through TI process with new dimensions

Please follow the below steps to create a new cube through TI process with new dimensions:

1. Select process and then select ‘Process\Create New Process’ as shown in the below screenshot

2. Now Turbo Integrator window will be opened
3. If your source is an external database (For Ex: SQL SERVER), click on ‘ODBC’ as your datasource type under ‘Data Source’ tab inside the TI process.
4. Click on Browse and select the ‘Data Source Name’ (which should be created before selecting the datasource name, create a DSN for the database which you are going to use).
5. Write the query to fetch the data from the database inside ‘Query’ and click on ‘Preview’ button. If everything works fine, you can see the top 10 records under preview section.
Note: If you feel that all the columns are there under preview section, then no need to do anything. If not, please modify your query to get your columns.
6. Click on Variables tab and now you can see all the columns which you previewed in the previous tab.
7. Change the contents for all the variables (Ex: Element, Consolidation, Ignore, Other etc)
8. Click on ‘Maps’ tab and click on ‘Cube’ tab.
9. Click on ‘Create Cube’ under ‘Cube Action’ and provide a cube name.
10. Click on ‘Accumulate/Store’ values based upon your requirement under ‘Data Action’ for storing the data inside the cube.
• Accumulate: Aggregates the values with existing data
• Store: replaces the data
11. Click on ‘Dimensions’ tab and provide the new dimension name under ‘Dimension’ and also specify the order of the dimension in the cube. If you are creating new dimensions, please double check whether the ‘Action’ contains ‘Create’.
12. Specify the element type for the dimension.
13. Click on ‘Consolidation’ tab and assign the N level elements to the consolidation element to create a hierarchy.
14. Click on ‘Advanced’ Tab and then click on ‘Prolog’, ‘Meta Data’, ‘Data’ and “Epilog’. The TI process will automatically writes the script inside the relevant tabs.
15. Save the process with a name and then execute it to create a new dimension.