TM1 Forum

Posted: **Tue Dec 09, 2014 6:29 am**

Ok, so I know in TI you can take an Alias and figure out what the original element is using the DimensionElementPrincipalName...

What I wanted to know is if there is a similar function that can be used in Excel Worksheets, or maybe some workarounds using existing tm1 formulas...?

Thanks!

Matt

Posted: **Tue Dec 09, 2014 6:35 am**

Dimnm ( Dimix (

Posted: **Tue Dec 09, 2014 6:40 am**

that was quick.. thanks for that!

Posted: **Tue Dec 09, 2014 7:57 am**

Another way may be to use the internal ALL subset e.g. I have a month dimension with an alias of 1 for Jan, 2 for Feb etc. If I want to return Jan (Principal) then I can do:

Code: Select all

=SUBNM("server:month","ALL","1")

Posted: **Tue Dec 09, 2014 10:36 pm**

thanks, good tip

TM1 Forum

Worksheet function for Principal Element Name?

Worksheet function for Principal Element Name?

Re: Worksheet function for Principal Element Name?

Re: Worksheet function for Principal Element Name?

Re: Worksheet function for Principal Element Name?

Re: Worksheet function for Principal Element Name?