DimensionElementPrincipalName for Excel?

Post Reply
User avatar
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?

Post by Steve Vincent »

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
User avatar
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?

Post by bihints.com »

SUBNM("server:dimension","",element) returns the principal name by default
Post Reply