I want to have a Picklist for all used user defined dimensions. So I want a complete list of all elements, which would be:
Code: Select all
Dimension:DimName
Additionally I need to show attribute names defined in every dimension.
So I would define a subset, based on an MDX, which filters the levels and then fix it as a static subset. This named subset I can use later in my Picklist cube.
BUT: I have so many dimensions, for each I have to do exactly the same selections. Is there an easier way to do this, like using a kind of MDX in a rule which feeds the Picklist cube?
Thanks in advance
Dirk