Queries in Business Objects

[Former Member]

I'm trying to query information form the CMS repository .  I would like the following information username , userid , email address, Profile Values (i.e. FUND and ORG)

[former_member182521]

You need to use the Query builder with the Query below.

SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND='USER'

For detailed information you can refer here

BusinessObjects Query builder - Basics

[Former Member]

Thank you Manikandan...I looked through the link and I'm trying to find the profile values per user ...is there any query to determine this information ?

[Former Member]

Hi Patricia,

Check the below :

http://scn.sap.com/community/bi-platform/blog/2013/06/10/businessobjects-query-builder-queries--part...

There are a lot of blogs on query builder mentioned in the above link.

This may be helpful for you .