Creating Dimensions using TI Process

The dimension can be created and updated through a Turbo Integrator Process.

1) Create an Excel sheet with the dimension values and save it as .csv file. (For ex. Account Dim)

Account.csv

ID, NAME, CATEGORY
100,ABC, IT
200,XYZ, ADMIN

Using TI Process

1) Right click on Process-> Create New Process.
2) Turbo Integrator dialogue box opens.
3) Choose Text under Data Source and browse to the .csv file that was created.
4) Select Comma Delimiter and put 1 in Number of title records if you have a header information in the sheet.
4) Click on Preview to see the data.
5) Click on Variables tab and choose Other for Contents field.

Ignore - Ignore the contents of the column
Element - Column is converted to leaf level
Consolidation - Column is converted to consolidated element and parent to other elements
Data - Column has data values for the cube
Attribute - Column contains element attributes
Other - Values don't belong to any of the above categories.

6) Click on Advanced tab-> Prolog. Write DimensionCreate('Account'); This will create Account Dimension Under Dimensions.

7) Use Metadata tabe to insert elements in Account dim.

8) The function
DIMENSIONELEMENTINSERT('Account','',ID,'n');
DIMENSIONELEMENTINSERT('Account','',NAME,'n');
DIMENSIONELEMENTINSERT('Account','',CATEGORY,'n');


- These will insert the elements in ID,NAME & CATEGORY fields. Account is the dim name, " indicates the previous field name, 'n' represents the simple type element.

9) Save the Process and click File-> Run to run the process.
10) The Dimension Account will be created with the all values.