Page 1 of 1

Calling alias from control cube

Posted: Fri Aug 20, 2010 3:29 am
by daya007
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

Re: Calling alias from control cube

Posted: Fri Aug 20, 2010 4:18 am
by Martin Ryan
=DBRA("server:dimension", element, alias)

Re: Calling alias from control cube

Posted: Fri Aug 20, 2010 5:13 pm
by daya007
thank you so much...its working...