Trying to "Personalise" a dashboard

[#1]

Hi all,

I have a text box at the top of my document which says welcome to the dashboard you are using version x.

The expression I am using is ='Welcome ' & OSUser() & 'you are using version ' & $(varversion)

Do you know if there is any way I can lookup OSUSer against another table (similar to vlookup) to pull up the users name rather that their ID?

Thanks,

Felim

[matt_crowther]

Felim,

Let me know what you're osuser() value is and I'll send you a working demo I've created.

All the best,

Matt - Visual Analytics Ltd

[matt_crowther · Accepted solution]

Felim,

Attached is a .qvw that should welcome you on opening. Check the 'OnOpen' actions and the 'User' variable.

It works for me so if there's an error and all you see is 'Welcome: ' then check my spellings etc.

I've also attached the .xls file that it's driving from.

Hope that helps,

Matt - Visual Analytics Ltd

[Anonymous]

Hi, 

I have similar issue, I just want to show the name not entire log-in crediantial like domain name then user name. I want to do  this  is designing screen, is  this possible?

= ' Welcome Mr/Ms.' OSuser()  &

IF(Now() < '12:00',  '  Good Morning ' , ' Hello')

and result is giving  the domain/username, which I dont want.

Best Regards,

Shubham

[chriscammers]

try Subfield(OSuser(),'/',2)

Chris

[#6]

my osuser() has a backslash as well as a "." between first and last so amended to cater for this:

=replace(Subfield(OSuser(),'\',2),'.',' ')

chriscammers wrote:

try Subfield(OSuser(),'/',2)

Chris