BusinessObjects Board

How do I access Full Name and email from repo via BO in 651?

building reports desktopintelligence
#1

Is there some posting out here in regards to being able to pull user ids, user full names from the user attributes tab in supervisor, their corresponding email, out to a BO rep format?

Or even to Excel? I thought I read somewhere that someone figured out how to do this or BO had it documented somewhere.

Can anyone help?

BusObjGuy :us: (BOB member since 2002-10-17)

6.5.1 Repository universe for User/Group/Document & BCA
#2

Try this SQL in 6.5.1:

You must have access to repository schema…

The query below will return only those IDs which are set with Email ID’s.

SELECT M_ACTOR_C_NAME, M_UATT_C_ATTRVALUE
FROM OBJ_M_ACTOR,OBJ_M_USRATTR
WHERE M_ACTOR_N_ID = M_UATT_N_ACTORID 
AND     M_UATT_N_ATTRTYPE = 2

If you want all the names irrespective of whether Email ID is set or not, then in the above SQL in the last line check it for 1. ( i.e. M_UATT_N_ATTRTYPE = 1)

Hope this helps.

BO_Chief :us: (BOB member since 2004-06-06)

#3

You could try my universe attached here. One I created to work with users/groups and documents/BCA queue. It includes detail objects to give users email, I even included a report you can use to retrieve a list of emails by group ready for pasting into an email.

I have mentioned this in a few posts, but never get any feedback, so I hope it is working.

beckster :uk: (BOB member since 2003-02-18)

#4

The universe works great and helps out trmendously. I do have one issue or questions rather. What is the link between the obj_m_categ and obj_m_documents? I need generate a report that lays out what reports belong to what corporate document categories and i am having issue find the keys to link on.

Any help would be great.

mcliffordgoo :us: (BOB member since 2003-02-13)

#5

Hi,

you need to use also the repository table OBJ_M_DOCCATEG:

  1. OBJ_M_DOCCATEG.M_CATEG_N_ID is the category ID OBJ_M_CATEG.M_CATEG_N_ID and

  2. OBJ_M_DOCCATEG.M_DOC_N_ID is the document ID OBJ_M_DOCUMENTS.M_DOC_N_ID.

Hope this helps.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#6

Thank you for your help. It does exactly what I needed. :lol: About time something works the way it should. Cheers!!!

mcliffordgoo :us: (BOB member since 2003-02-13)

#7

Beckster,

Hi! Thank you so much for providing this! I seem to be missing a couple of objects in the universe. Can you help?

Here is what I need:

Disabled Login
User Type in Group
Locked?
3 Strike Failed
Enable Delete Document
Enable RTUR Updates
Enable Offline Login
Enable Password Modification
Object Security Level
Change Password at First Login
No. Incorrect Tries
User Authentication
Password Expires

Rather than try to figure these out on my own :hb: I figure, why try to reinvent the wheel?

Thank you so much for your help.

Jenn.

Jennifer Hoffman (BOB member since 2005-12-16)

#8

Beckster,

Hi. I’m also interested in how to format the Day_Timing field on the DS_PENDING_JOBS table. Any thoughts?

Jenn.

Jennifer Hoffman (BOB member since 2005-12-16)

#9

Is there a similar table that but for groups?

mcliffordgoo :us: (BOB member since 2003-02-13)