Search found 2 matches

by HurricaneDitka
Tue Oct 27, 2009 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export dimensional hierarchy to relational source
Replies: 4
Views: 7707

Re: Export dimensional hierarchy to relational source

I'm not sure how to identify the parent of an element. Would I have to set up the dimension with attributes describing the parents? (Not desirable as this is an added layer of maintenance as account hierarchy changes). Or is there functionality available to get the parent? As for our hierarchy, it's...
by HurricaneDitka
Thu Oct 22, 2009 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export dimensional hierarchy to relational source
Replies: 4
Views: 7707

Export dimensional hierarchy to relational source

Hi, Is there anyway to export a dimension with hierarchy in tact to a database table? I have a scenario where we load a flat chart of accounts into TM1 and set up our hierarchy structure within the dimension (i.e. specify that the Advertising Account rolls into Marketing Expenses > Total Expenses > ...