How to find element name from attribute in Rule

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

How to find element name from attribute in Rule

Post by EP_explorer »

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)?
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: How to find element name from attribute in Rule

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: How to find element name from attribute in Rule

Post by EP_explorer »

Thank you
The second idea is what I was looking for
Post Reply