I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder.
It should be ran under the administrator account for the best results, but also works for delegated administrators/users.
The first tab has a section on the supported types and usage guide. It also mentions some limitations so PLEASE READ this first.
Changing the reference to that of the version 11.x libraries should enable this to work for XI R2, the ones that need changing are:
Crystal Enterprise Framework Library 12.0
Crystal Enterprise Infostore Library 12.0
BusinessObjects Designer 12.0 Object Library
If you need to change the Referenced Libraries this can be accomplished by opening the document, select Tools > Macros> Visual Basic and then Tools > References.
This utility should be ran on a workstation which has the full BO client installation as it requires access to Designer and also libraries provided by the install.
Note for Moderator, original version can be found here
IF YOU ARE AFTER A VERSION FOR SAP BI 4, PLEASE USE THE “SAP BI Repository Documentor” which can be found here .
Update: V8 with some bug fixes and enhancements can be found here (for both R2 & R3).
Sushir Patel (BOB member since 2006-04-19)