DimensionElementPrincipalName for Excel?
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
DimensionElementPrincipalName for Excel?
I've got a situation where i'd like to be able to use some formulae in Excel that only work on the element name, but i might have values that are aliases of those elements. I know TI has DimensionElementPrincipalName, but does anyone know of a way to get the same kind of functionality within Excel?
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- bihints.com
- Posts: 52
- Joined: Tue May 20, 2008 8:56 am
- OLAP Product: TM1
- Version: 9.0.3
- Excel Version: 2003
- Contact:
Re: DimensionElementPrincipalName for Excel?
SUBNM("server:dimension","",element) returns the principal name by default