Which cubes use a certain dimension

Post Reply
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Which cubes use a certain dimension

Post by lynnsong986 »

Hello Wim,

first of all thanks for posting those useful codes on your website! I'm trying to follow your steps creating a process to trace which cubes use a particular dimension, but I'm stuck where it says "navigate towards subset All on the dimension }cubes", I have a bunch of them that I'm not sure which one to pick:

Alectra-ES:}Subsets_}.Dimensions (I have this listed twice)
Alectra-ES:}Subsets_}.Cubes (I have this listed twice)

I wonder why they are listed twice?

can you please advise me?

thanks!!
Wim Gielis
MVP
Posts: 3234
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Which cubes use a certain dimension

Post by Wim Gielis »

That would be weird, I currently see:

01.png
01.png (16.98 KiB) Viewed 3576 times
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3234
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Which cubes use a certain dimension

Post by Wim Gielis »

Also, I found an easy trick to quickly see in which cubes a dimension is used: Go to the dimension's Subset Editor, then Tools > Filter... and the dropdown will show you the cubes containing the dimension.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lynnsong986
Posts: 83
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Which cubes use a certain dimension

Post by lynnsong986 »

then I'll use the trick you just showed me for this, thanks again!!
Post Reply