TM1 Forum

Posted: **Wed Dec 13, 2023 2:12 pm**

Hi,
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

I also want to offer a list of all elements without the top level and a list without the leaf elements.
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

Posted: **Wed Dec 13, 2023 2:53 pm**

schlemiel29 wrote: ↑Wed Dec 13, 2023 2:12 pm Hi,
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
I also want to offer a list of all elements without the top level and a list without the leaf elements.
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

You should use Subset Picklist instead of Dimension Picklist

Posted: **Wed Dec 13, 2023 2:55 pm**

This was touched on in some other threads recently.

You can only point the picklist at a dimension, set or static list. Therefore if you have a complex need delivered by MDX then you must create a public set to deliver the list. You can not point a picklist directly at a MDX statement.

If you have a standard set of MDX sets you want in play against all your dimensions then you should be using a TI to loop over the dimensions and the MDX definitions to build the sets.

TM1 Forum

Flexible PickList Definitions

Flexible PickList Definitions

Re: Flexible PickList Definitions

Re: Flexible PickList Definitions