TM1 Forum

I have such situation

Cube1 with List one element of which contains Picklist.
picklist in element is defined as subset:dim_name:subset_name

The subset is alias from dimension with name dim_name

In other Cubes of model I use in Rules elements names from dim_name

But when user choose element from picklist in Cube1 I can't compare it with elements names from dim_name

How can I found name of element in dim_name using name from subset (which formed from attributes of the elements of dim_name)?

EP_explorer wrote:I have such situation

Cube1 with List one element of which contains Picklist.
picklist in element is defined as subset:dim_name:subset_name

The subset is alias from dimension with name dim_name

In other Cubes of model I use in Rules elements names from dim_name

But when user choose element from picklist in Cube1 I can't compare it with elements names from dim_name

How can I found name of element in dim_name using name from subset (which formed from attributes of the elements of dim_name)?

I'm not completely sure that I understand the question and you haven't indicated where you plan to do this comparison (in Excel? In a TI process?) but this may point you in the right direction.

- In a TI process if you have an alias as a variable, you can use the DimensionElementPrincipalName function to get the element's base name and use that as the comparison.
- In any other case you can use DimIx to return the alias's dimension element index number, then DimNm to get the principal name of the element for that DimIx value.

Thank you
The second idea is what I was looking for