Cube and dimension name list
-
Mems
- Posts: 58
- Joined: Thu Apr 14, 2011 12:27 pm
- OLAP Product: TM1
- Version: v10.2.2
- Excel Version: 2010
- Location: South Africa
Cube and dimension name list
Is there an easy way to get all your cube names and their dimensions into excel, using TM1 v9.5.1
MEMS
-
jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Cube and dimension name list
The quickest way is copy and paste in the list from the properties window,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Cube and dimension name list
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.
- Attachments
-
- DimsByCube.xlsx
- (17.37 KiB) Downloaded 1731 times
-
Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Cube and dimension name list
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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer