BusinessObjects Board

BO Query Builder - List of Reports

general discussion
#1

Hi All,

Can you please help me with a query which helps in getting all the information about the reports present in my repository.
Informatino should include the report name , folder name , Universe name , database it points to , data providers.

I have gone through a few queries bt havent been able to find a result.
IF you could provide me the table name , column names and parameters it would be great if not the query.

Supposing i have all the reports in “Public Folders” in a folder named X.
Server Name is : Y

Thanks and Regards.

ns21589 (BOB member since 2011-09-14)

#2

Search is your friend :slight_smile:

try Query Builder for a start

Orange :netherlands: (BOB member since 2006-09-18)

#3

You can also get most of that information from the Activity Universe.

HTH

mcnelson :uk: (BOB member since 2008-10-09)

#4

You wont be able to find out that kind of info from the activity universe as that is all about usage - not about system info im afraid.

Orange :netherlands: (BOB member since 2006-09-18)

#5

Only way to get all that info is to use the SDK. There might be something in BOB’s Downloads that will help, check it out.

jwhite9 :us: (BOB member since 2006-07-28)

#6

You can certainly discern the Universe Name & Path (Folder) per Report from the Activity Universe. If you need to know which SQL databases are being referenced then yes, this won’t come from the Activity Universe.

mcnelson :uk: (BOB member since 2008-10-09)