Page 1 of 1
List Measure Dimensio using Dimensions or Subset as Picklist
Posted: Thu Jun 13, 2013 3:07 am
by 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.
Re: List Measure Dimensio using Dimensions or Subset as Pick
Posted: Thu Jun 13, 2013 7:40 am
by 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
Re: List Measure Dimensio using Dimensions or Subset as Pick
Posted: Thu Jun 13, 2013 8:11 am
by Wim Gielis
Updated coding, more functionality provided. Still only }ElementAttributes_* dimensions are treated.
Re: List Measure Dimensio using Dimensions or Subset as Pick
Posted: Thu Jun 13, 2013 2:29 pm
by Wim Gielis
Last addition for now, a loop over cubes was added.
The code always generates 2 text files as output.
Wim
Re: List Measure Dimensio using Dimensions or Subset as Pick
Posted: Tue Jun 18, 2013 9:43 pm
by 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