Page 1 of 1

How to retrieve the original element usin the alias

Posted: Fri Jun 15, 2012 8:12 pm
by guru1988fortm1
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

Re: How to retrieve the original element usin the alias

Posted: Fri Jun 15, 2012 8:25 pm
by kpk

Re: How to retrieve the original element usin the alias

Posted: Fri Jun 15, 2012 8:38 pm
by Duncan P
DimensionElementPrincipalName works in TI.

For rules use e.g.

Code: Select all

DIMNM( 'Country', DIMIX( 'Country', '31020 ARG' ) )

Re: How to retrieve the original element usin the alias

Posted: Fri Jun 15, 2012 10:31 pm
by guru1988fortm1
Wow, Thanks Duncan and Kpk, it worked

I have got it through the TI Process

Thank you :)