Page 1 of 1
Cube and dimension name list
Posted: Thu May 12, 2011 1:05 pm
by Mems
Is there an easy way to get all your cube names and their dimensions into excel, using TM1 v9.5.1
Re: Cube and dimension name list
Posted: Thu May 12, 2011 2:19 pm
by jim wood
The quickest way is copy and paste in the list from the properties window,
Jim.
Re: Cube and dimension name list
Posted: Thu May 12, 2011 3:21 pm
by lotsaram
Simple for any version of TM1. Just use DIMIX to get your list of cubes from }Cubes dimension and TABDIM to get dimension by cube. See attached spreadsheet.
Re: Cube and dimension name list
Posted: Thu May 12, 2011 8:58 pm
by Martin Ryan
You might find this TI process useful to find out if any dimensions aren't being used:
http://www.tm1forum.com/viewtopic.php?f=21&t=4901