List of Dimensions with no cube

Post Reply
elee123
Posts: 19
Joined: Fri Nov 21, 2014 5:01 pm
OLAP Product: tm1
Version: 10.1
Excel Version: 2010

List of Dimensions with no cube

Post by elee123 »

Hi Everyone,
If I wanna get a list of dimensions with no cube using it, do you think it’s possible to write a process to get the list?
If so, how can we do this?
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: List of Dimensions with no cube

Post by declanr »

Most of us who have had to pick up a model we didn't originally build have a TI to do something along these lines and there are a handful of topics that you can find by searching the forum using the search box in the top right corner; the following is the first one I found:
http://www.tm1forum.com/viewtopic.php?f=21&t=4901

I have a version that I wrote which also checks all Picklist attributes and Picklist cubes to see if a dimension is used in them also since sometimes a dimension not being in a cube doesn't mean that the model doesn't use it. However I doubt you will need this level of granularity.
Declan Rodger
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: List of Dimensions with no cube

Post by BariAbdul »

Hi declanr,First of all,Wishing you all TM1 forum a very happy new year ,I had inherited the model which had quite a few picklists defined on them and was pain to find these unused dimension having picklist defined on them.I have a process which find the number of picklists defined but yours seems to be have much more depth and granularity.

Is it possible for you to please share it.Thanks
"You Never Fail Until You Stop Trying......"
Post Reply