Page 1 of 1
Export a Dimension Structure as Displayed
Posted: Tue Jul 24, 2012 4:27 pm
by dj74
I am looking for a way to export the Dimension Structure to either MS Excel or Word as displayed in its hierachy layout within the subset editor including the Alias. Can this be done using Active Form functionality without showing any data or does anyone have any code that could perform this.
Top Level
|____Sub Level 1
|____Sub Level 1
| |____Sub Level 2
|____Sub Level 1
Thanks
Re: Export a Dimension Structure as Displayed
Posted: Tue Jul 24, 2012 5:15 pm
by tomok
Just create a non zero-suppressed view with the dimension you want in the rows and everything else as a title dimension and then use the Slice functionality.
Re: Export a Dimension Structure as Displayed
Posted: Tue Jul 24, 2012 7:16 pm
by kpk
dj74 wrote:I am looking for a way to export the Dimension Structure to either MS Excel or Word as displayed in its hierachy layout within the subset editor including the Alias. Can this be done using Active Form functionality without showing any data or does anyone have any code that could perform this.
Top Level
|____Sub Level 1
|____Sub Level 1
| |____Sub Level 2
|____Sub Level 1
Thanks
I think this tool will be useful for you:
http://www.tm1forum.com/viewtopic.php?f=21&t=2515
Re: Export a Dimension Structure as Displayed
Posted: Thu Jul 26, 2012 8:59 am
by dj74
Thanks Peter, exactly what I was after. Will look at the other tools as well - could be useful also.