Hi all
I have a excel app where i am retrieving User who currently logged in using TM1User() function.
But in our server user names are unique alpha numerics
In }ClientGroups cube, for clients dimension in alias we have complete names.
How can i get appropriate alias(Complete names) for the cell where i used TM1user function(which returned alpha numeric).
Please help me with ur ideas. Let me know if am not clear on this question.
Thanks
Daya
Calling alias from control cube
-
Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Calling alias from control cube
=DBRA("server:dimension", element, alias)
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
daya007
- Posts: 49
- Joined: Fri May 28, 2010 4:47 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003
- Location: IL, USA
Re: Calling alias from control cube
thank you so much...its working...