Hi All,
I am learning TM1 and i have a requirement like i want to get the original element from the description
Like, Say i have country dimension with Description as attribute
Country
31020
31022
31023
These are country codes and they are present as elements
I have an alias attribute called description that has details like
31020 ARG
31022 BRA
Now my requirement is i have the details as ARG and BRA, So whats the command to retrieve the element as 31020 and 31022 using this ARG and BRA
because using ATTRS, we can get the attributes using the element
So now how to get the element using the attribute
could anyone help me if you have across this kind of requirement
Regards
Guru
How to retrieve the original element usin the alias
-
- Posts: 42
- Joined: Mon Feb 06, 2012 5:52 pm
- OLAP Product: Cognos TM1
- Version: PA 2.0.3
- Excel Version: Micrsoft Excel 2010
- Location: Chennai, India
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: How to retrieve the original element usin the alias
DimensionElementPrincipalName works in TI.
For rules use e.g.
For rules use e.g.
Code: Select all
DIMNM( 'Country', DIMIX( 'Country', '31020 ARG' ) )
-
- Posts: 42
- Joined: Mon Feb 06, 2012 5:52 pm
- OLAP Product: Cognos TM1
- Version: PA 2.0.3
- Excel Version: Micrsoft Excel 2010
- Location: Chennai, India
Re: How to retrieve the original element usin the alias
Wow, Thanks Duncan and Kpk, it worked
I have got it through the TI Process
Thank you
I have got it through the TI Process
Thank you
