BusinessObjects Board

Query Builder

other Business Query
#1

Hi All,

In BusinessObjects 3.1 Query Builder I need a list of users that belong to a group.
Do you know what kind of query lists the users and the different groups that the user belongs to, or list the group name and all the users that belongs to that group?

BR, Carina

Carina (BOB member since 2007-04-15)

#2

If you know the group name:

select si_name
from ci_systemobjects
where children("si_name = 'usergroup-user'", "si_name = 'GROUP NAME HERE'")

Will return who’s in the “GROUP NAME HERE” group.

Patrick McDonough (BOB member since 2002-08-20)

#3

Thank you Patric :wave: This resolves a lot.
Could you also let me know how to find the users that are using universes (universe name with user name)?

Thanks again.

BR, Carina

Carina (BOB member since 2007-04-15)

#4

Hi,

This will show top 1000 webi reports with owner info.


SELECT TOP 1000 si_owner, si_id, si_name
from ci_appobjects, ci_infoobjects 
where PARENTS("SI_NAME='Webi-Universe'", "SI_NAME = 'YOUR_UNIVERSE_NAME' ")

Patrick

Patrick McDonough (BOB member since 2002-08-20)