Build Dimension with TI from 2 column defined hierarchy

[dmclellan]

I would like to create a dimension using Turbo Integrator from a source file which defines the hiearchy as follows:

Description ...........Owner
----------------------------------------
Item 0..................Consolidation 1a
Consolidation 1a......Consolidation 2a
Consolidation 2a......Consolidation 3a
Item 0..................Consolidation 1b
Consolidation 1b......Consolidation 2b

The hierarchy will ultimately look like this. Item 0 has more than 1 consolidation path.

Consolidation 3a
|__Consolidation 2a
|_____Consolidation 1a
|________Item 0

Consolidation 2b
|__ Consolidation 1b
|______Item 0

In case the above looked a little confusing given the way in which I had to show it to keep the structure in this web page.

Item 0 => Consolidation 1a => Consolidation 2a => Consolidation 3a
Item 0 => Consolidation 1b => Consolidaiton 2b

I am relatively new to TM1 and would appreciate some clues as to the best way to solve this.

[Gregor Koch]

Hi
For a start you could use the Wizard of Turbo Integrator to sort of give you an understanding of the basic functions.

Right Click on Processes in Server Explorer and select 'Create New Process'
In the Datasource Tab - Datasource Type select 'Text'
Select 'Browse' (top right) and find the file that is the source
....

what am I doing, I am repeating what's in the manual ? Maybe just read some documentation on how to connect to a text/ascii source, search a bit in this forum on how the Data Source Name and Data Source Name On Server can be different, once you hit the part where you go to the Variables Tab select 'Element' as the type for the first variable and 'Consolidation' for the second variable, save, execute and find the dimension in Server Explorer...

[dmclellan]

Thanks for the response I have also just found this post in the forum which deals with the same issue so I am sure I will be ok.

http://www.tm1forum.com/viewtopic.php?p=18258#p4909