List Measure Dimensio using Dimensions or Subset as Picklist

[appleglaze28]

I was able to find a IBM article on how to create a csv file with a list of the dimensions and what cubes are using the dimensions. I was wondering if anybody has tried to do this but determining the which dimension are being used as a picklist.

Just for maintenance purposes, I was just wondering if anybody tried it.

[Wim Gielis]

Hello

I never did create such a process, but it isn't that hard.
I limited myself to a loop over ElementAttributes control dimensions, testing whether there is a text element (attribute) called Picklist.
If needed, add a loop to check Picklist control cubes, but that might be harder to do.

See attached TI process, it will create a text file in the database directory for the TM1 server concerned.

Wim

[Wim Gielis]

Updated coding, more functionality provided. Still only }ElementAttributes_* dimensions are treated.

[Wim Gielis]

Last addition for now, a loop over cubes was added.
The code always generates 2 text files as output.

Wim

[Wim Gielis]

appleglaze28

It seems that you are online here, but did not provide any feedback in your own topic.
I spent quite some free time to answer your question - it would be most polite to at least comment on the solution given.
If anything is unclear or should be changed, that could still be done.

Wim