Page 1 of 1

DimensionElementPrincipalName for Excel?

Posted: Fri May 23, 2008 9:47 am
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?

Re: DimensionElementPrincipalName for Excel?

Posted: Fri May 23, 2008 10:08 am
by bihints.com
SUBNM("server:dimension","",element) returns the principal name by default