Report of Reports?

[Former Member]

We are currently using Business Objects XI (Release 2) and I would like to create a "report of reports" show the report name, report description, universe, owner of report, and folder location of where the folder is located. I have searched and searched for this and have not been able to find anything. Anyone have any suggestions of how we can produce a WEBI report with this data?

Thanks in advance.

[former_member183750 · Accepted solution]

You will most likely get a faster answer if you post to the Crystal Reports Design

forum:

Ludek

[Former Member]

Justin,

This capability is somewhat available to you using the QueryBuilder tool. If you launch your BO Tools URL (http://<server>/businessobjects/enterprise115/WebTools/adminlaunch/default.aspx) it will bring up a screen with 3 panels on the left side, choose QueryBuilder where you will have an interface that you can work with submitting "SQL-type" queries. The main table is call ci_infoobjects so if you type a query "select * from ci_infoobjects where si_kind='webi'" you will get a boatload of information, but by observing the key columns that you would want to know stuff on you can tailor your select clause accordingingly.

Thanks,

John

[Former Member]

Hello,

What about if I want to display the reports by a given date, I mean, I want to get a report, of the reports that failed in the current date, or in the last week, by a given user or folder.

[Former Member]

This is quite easily with Auditing which I hope you have (and have enabled). One of the sample Audit reports (Job Summary) has the information you require (more or less)..