Query from Bo repository to know if an object is used or not

[system]

Hi,

there is not such information in the BO repository regarding what universe object is used in what BO report.

You will need to use some VBA macro that will pull out this information for you from the set of documents.
The best start for you should be this code from Dave Rathbun:

120×120 10.4 KB

Author: Dave Rathbun Author Notes: Objects Used ' "ObjectsUsed" ' Dave Rathbun, Integra Solutions ' www.IntegraSolutions.net ' provided "as is", no warranty implied ' This macro does not by design to anything to the reports that it reads. It does write ' to a CSV file that will be - by default - located in the "UserDocs" folder as specified by ' a user preference setting. The data provider for the document must point to this file. As of ' this revision, the user must do this step manually. …

Marek

---

Marek Chladny (BOB member since 2003-11-27)