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)?
How to find element name from attribute in Rule
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
-
- 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
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.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)?
- 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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Thank you
The second idea is what I was looking for
The second idea is what I was looking for