Page 1 of 1

Which cubes use a certain dimension

Posted: Sun Oct 06, 2019 11:15 pm
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!!

Re: Which cubes use a certain dimension

Posted: Sun Oct 06, 2019 11:57 pm
by Wim Gielis
That would be weird, I currently see:

01.png
01.png (16.98 KiB) Viewed 3650 times

Re: Which cubes use a certain dimension

Posted: Mon Oct 07, 2019 12:08 am
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.

Re: Which cubes use a certain dimension

Posted: Mon Oct 07, 2019 12:19 am
by lynnsong986
then I'll use the trick you just showed me for this, thanks again!!