DBRA - reverse formula
- 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
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)
e e cummings (1894-1962)
-
- 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
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 ...
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 ...
-
- 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
There's also DimensionElementPrincipalName... oh wait, that's a T.I. function, it won't work.lotsaram wrote: DIMNM(DIMIX()) combination will do it for you.
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?

"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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
Thanks Allan.
My last day as TM1 Administrator is Nov 13th and I will end my era with TM1
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
My last day as TM1 Administrator is Nov 13th and I will end my era with TM1

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)
e e cummings (1894-1962)
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: DBRA - reverse formula
Hope you found it useful. If you did, pass the site on to your successor and we'll look out for them.
- 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
I have David.
But he is a gig and techie, I think he will beat you all
But he is a gig and techie, I think he will beat you all

The most wasted of all days is one without laughter.
e e cummings (1894-1962)
e e cummings (1894-1962)
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: DBRA - reverse formula
Looking forward to it 
