Page 1 of 1

DBRA - reverse formula

Posted: Wed Oct 07, 2009 1:18 am
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?

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 1:49 am
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 ...

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 2:33 am
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:

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 3:55 am
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

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 12:36 pm
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.

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 7:59 pm
by Chengooi
I have David.
But he is a gig and techie, I think he will beat you all 8-)

Re: DBRA - reverse formula

Posted: Wed Oct 07, 2009 10:07 pm
by David Usherwood
Looking forward to it :D