Script to search for specific dim obj in the repository

[system]

Is there any script that I can use to search the entire BI repository for a particular object? The search will be limited to WebI reports.
Anything that might help in achieving this goal?

Env- Windows
SAP BI4.1

Thank you

---

SAMTHEBOBJGUY (BOB member since 2010-07-24)

[system]

There are quite a few utilities in the downloads section which you could have searched, found this

Document a BO Universe in Excel

Author: André Lützkendorf Platform: Windows Version: GetSetUniverse 3.5.25 Code: VBA code within the uploaded xls file Author notes: 1. What can you do with the tool? Presentation of all universe objects and properties This includes general universe information (defined in parameters) all object properties object dependencies (lineage/ impact analysis) (which table will be used by which object, which objects will be used by which objects with @functions) contexts hierarchies joins inc…

---

haider (BOB member since 2005-07-18)

[system]

Yes, I am aware of this script and use it frequently. The question is on list of WebI reports that uses an object called ObjX in the entire BI repository.
This script only details the universe.

---

SAMTHEBOBJGUY (BOB member since 2010-07-24)

[system]

You can not do it in a single script, you can can see what reports are using a universe. then you have to use the webi sdk to peek into the report and see if the report is using the object you are looking for. Not a fast process.

It can be done but is a pain.

---

JonnySpec (BOB member since 2008-08-01)