BusinessObjects Board

How to display BO User Name

building reports webintelligence
#1

Hi Experts,

Right now I am getting the BO user id through CurrentUser() function. But I want to display the user first name and user last name.
Kindly help me to get the first and last name of BO login details.

sureshhmca :india: (BOB member since 2010-11-01)

#2

I havent seen a way to do this. But if you get the name, here is the formula to seperate first name and last name

First Name =Substr([Name];1;Pos([Name];" ")-1)
Last Name = Substr([Name];Pos([Name];" ")-1;Length([Name])-Length([First Name])-1)

Hope you get the earlier problem solved.

M H Mohammed :us: (BOB member since 2010-06-16)

#3

Hi Mohammed,

I know how to split the first name and last name. Here I am getting the userid as bwtest1, bwqc1, bwdev1 etc. Now how to take the First and Last name of the userid. Please help me to find the BO login’s First and Last name.

sureshhmca :india: (BOB member since 2010-11-01)

#4

A very simple look at BOB downloads yielded this:-

https://bobj-board.org/t/89434

Obviously, it assumes that all these details have been completed in the first place.

Mak 1 :uk: (BOB member since 2005-01-06)

#5

You’re going to have to dig deep to get those - it’s buried in the CMS tables…

Easiest way might be the Infolytik product - link to a CMS query using user ID and display user from their query… Could also update your warehouse with user id and user names, if you don’t mind keeping it updated.

B

bdouglas :switzerland: (BOB member since 2002-08-29)