How to retrieve the original element usin the alias

Post Reply
guru1988fortm1
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

How to retrieve the original element usin the alias

Post 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
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: How to retrieve the original element usin the alias

Post by kpk »

Best Regards,
Peter
Duncan P
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

Post by Duncan P »

DimensionElementPrincipalName works in TI.

For rules use e.g.

Code: Select all

DIMNM( 'Country', DIMIX( 'Country', '31020 ARG' ) )
guru1988fortm1
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

Post by guru1988fortm1 »

Wow, Thanks Duncan and Kpk, it worked

I have got it through the TI Process

Thank you :)
Post Reply