Current User Name

building reports desktopintelligence
1

I am using the CurrentUser function on a report which displays the login of the user. Is there anyway to show their full name (first and last) without changing their login name i.e. my login is robertm1 but I want Michele Robertson to display.
Maybe linking a spreadsheet? The login names we have used correlate to the LOV of a particular object in the universe which is linked to their first and last names. I am just not sure how to go about this. Thanks in advance.

Listserv Archives (BOB member since 2002-06-25)

2

I have a similar problem running reports against the repository since our logon ids have nothing to do with our names. I solved the problem by creating a spreadsheet with all the user ids and names. I then use the spreadsheet as a personal data provider. You could also create a small Access database and BusObj universe, create a second query and link the two queries through the user id.

Barbara Rosen

Database Development & Admin Services
Salomon Smith Barney
Phone: (212) 723-2756
e-mail: barbara.rosen@ssmb.com

Listserv Archives (BOB member since 2002-06-25)

3

Does any one got answer to the above question with out using another data provider…!

santosh4bo :us: (BOB member since 2006-11-20)

4

Create a table in database with USERID, Name.

Then by using @Variable(‘BOUSER’) function in universe designer and then compare this object with USERID and get the corresponding Name in the report.

Hope this will help you.

Rakesh_K :india: (BOB member since 2007-12-11)