Display user name on active form

Post Reply
MONA78
Posts: 2
Joined: Mon Sep 12, 2011 8:51 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Display user name on active form

Post by MONA78 »

Hi,

I have an active form to allow users to enter their budget data once logged in. I would like to display their name on the front of the acticve form - the result of the "Who am I" question in perspectives if you like. The main reason for this is that during UAT the same testers will either be logged in as admin or budget holders (same testers are testing both profiles and both have different privilages handled in security). I want them to easily see who they are logged on as (admin or budget holder) so that they don't fail a test because they thought they were logged in as the other role type!

Does anyone know a neat way of doing this?

Thanks in advance :|

Mike
standtrue
Posts: 25
Joined: Sat Nov 07, 2009 5:37 am
OLAP Product: TM1, CX
Version: 9.5.2
Excel Version: 2007

Re: Display user name on active form

Post by standtrue »

There is a worksheet function called TM1User that you can place in your Active Form that will display the user name:

From the reference:

TM1User
This is a TM1® worksheet function, valid only in worksheets.

The TM1User worksheet function returns the user name of the current TM1 user.

If the current TM1 user is not connected to a server, or if the specified server is not running, TM1User returns an empty string.

If TM1User is executed against a server that is configured to use CAM authentication, the function returns the internal user name/CAMID, not the display name.

Syntax
TM1User("ServerName")
MONA78
Posts: 2
Joined: Mon Sep 12, 2011 8:51 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Display user name on active form

Post by MONA78 »

Standtrue: thanks you very much...it works superbly!

Cheers

Mike
Post Reply