DBRA - reverse formula

Post Reply
User avatar
Chengooi
Posts: 64
Joined: Tue Jan 13, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Auckland, New Zealand
Contact:

DBRA - reverse formula

Post by Chengooi »

DBRA formula is expected to display the aliases of the element, and what if we know the alias and we want to get the element name from the aliases, does anyone know what formula it is?
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: DBRA - reverse formula

Post by lotsaram »

Ah Chengooi back again!

DIMNM(DIMIX()) combination will do it for you.

I'm sure that even you could have come up with that given a moment's mental reflection ...
Alan Kirk
Site Admin
Posts: 6645
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: DBRA - reverse formula

Post by Alan Kirk »

lotsaram wrote: DIMNM(DIMIX()) combination will do it for you.
There's also DimensionElementPrincipalName... oh wait, that's a T.I. function, it won't work.

But I'm sure that a company which pays as much attention to detail as Iboglix would assiduously ensure that all TI functions have equivalent worksheet and rules functions and vice versa... er, wouldn't they? :twisted:
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Chengooi
Posts: 64
Joined: Tue Jan 13, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Auckland, New Zealand
Contact:

Re: DBRA - reverse formula

Post by Chengooi »

Thanks Allan.

My last day as TM1 Administrator is Nov 13th and I will end my era with TM1 :P Yipee.
I will return to my basic world MYOB and Access 2000 .
My new working place is www.networkpro.co.nz


cheersn and thanks for your help and support
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: DBRA - reverse formula

Post by David Usherwood »

Hope you found it useful. If you did, pass the site on to your successor and we'll look out for them.
User avatar
Chengooi
Posts: 64
Joined: Tue Jan 13, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Auckland, New Zealand
Contact:

Re: DBRA - reverse formula

Post by Chengooi »

I have David.
But he is a gig and techie, I think he will beat you all 8-)
The most wasted of all days is one without laughter.
e e cummings (1894-1962)
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: DBRA - reverse formula

Post by David Usherwood »

Looking forward to it :D
Post Reply