Export TM1 Hierarchies to SQL/SSAS

[vhtm1]

Hi

I am working on a integration project to get TM1 data into SQL Server and eventually into a SSAS OLAP cube.

We don’t have any problems to get the item level data but struggling with the cost centre hierarchies and their
alternate hierarchies. Currently we receive a bedrock export file, but having problems to reconstruct the hierarchies
in SQL/SSAS where elements have multiple parents.

My question, is there a best practice way/process (perhaps a tutorial) on how to export and reconstruct the TM1 hierarchies
an their alternates in SQL/SSAS?


(FYI – TM1 first timer, please let me know if you need more information to advise).

Thank you.

[Steve Rowe]

Hi,

This is pretty straight forward stuff, you just need some while loops and a working knowledge of TI and dimension structure functions such as Elpar and Elparn or ElComp and ElCompN.

I wouldn't expect to get the code written for you though without having had a crack yourself. This is a fishing rod rather than a fish type place....

Cheers,