BusinessObjects Board

BO XI R2: WebI/DeskI report showing all users

general discussion
#1

I would like to build a DeskI or WebI report (BO XI R2) that shows all user accounts of a certain BO system - maybe together with some specific group rights… Is this possible?

Thanks!

SFL (BOB member since 2007-06-15)

#2

Not directly. You’ll need to extract the user and group data as a separate step, using a tool like this one. The build a universe over the extracted data.

In 6.5, this can be done quite easily.

Joe

joepeters :us: (BOB member since 2002-08-29)

#3

OK… can I maybe use the Query Builder for this? I am trying to build a query but up to now I haven’t found a solution to get all users…

SFL (BOB member since 2007-06-15)

#4

You can use query builder, but it will only create an html page with all the user data. You’ll still need a way to load that into a database.

joepeters :us: (BOB member since 2002-08-29)

#5

So Query Builder can just display a list of all users without their rights? What’s the SQL for this?

Thanks!

SFL (BOB member since 2007-06-15)

#6

This will do it:

select top 10000 si_name from ci_systemobjects where si_kind = 'user'

joepeters :us: (BOB member since 2002-08-29)