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
Export a Dimension Structure as Displayed
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Export a Dimension Structure as Displayed
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.
-
kpk
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Export a Dimension Structure as Displayed
I think this tool will be useful for you: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
http://www.tm1forum.com/viewtopic.php?f=21&t=2515
Best Regards,
Peter
Peter
-
dj74
- Posts: 8
- Joined: Fri Jan 27, 2012 5:11 pm
- OLAP Product: IBM Cognos Express Xcelerator
- Version: 9.5
- Excel Version: 2007
Re: Export a Dimension Structure as Displayed
Thanks Peter, exactly what I was after. Will look at the other tools as well - could be useful also.