TM1 Forum

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?

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.

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