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
Worksheet function for Principal Element Name?
-
fleaster
- Regular Participant
- Posts: 167
- Joined: Wed Mar 30, 2011 11:57 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: XL2010
Worksheet function for Principal Element Name?
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
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
-
fleaster
- Regular Participant
- Posts: 167
- Joined: Wed Mar 30, 2011 11:57 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: XL2010
Re: Worksheet function for Principal Element Name?
that was quick.. thanks for that!
-
gtonkin
- MVP
- Posts: 1269
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Worksheet function for Principal Element Name?
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")-
fleaster
- Regular Participant
- Posts: 167
- Joined: Wed Mar 30, 2011 11:57 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: XL2010
Re: Worksheet function for Principal Element Name?
thanks, good tip