How to find how many reports were using 1 particular object

[system]

Hi Experts

we have a requirement on finding DEPT Object was used in multiple reports.

DEPT object is coming form Universe.

How to find out how many reports are using one particular object.

we are in BOXI R3.1 SP5.

I saw many forums about this issue. unfortunately it didn’t work.

List objects used in a series of reports

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] The attached utility will record objects that are used in a series of reports. Usage is as follows: [quote:61cb8b7957="Author's notes"]- Create a temporary directory. - Place all documents (.rep files) to be analyzed in that directory. - Place this document in that same directory. - Open this document, and refresh. - Each document in the directory will be opened, and data provider ob…

---

Madu (BOB member since 2008-02-08)

[system]

Any experts can help on this issue. I’m spending more time on research.

Basically I’m trying many ways from “Business Intelligence platform - Query Builder”.

I could find Object Name (column name) to filter for webi reports.

---

Madu (BOB member since 2008-02-08)

[system]

Either use a tool like Metadata Manager or write a Java SDK program to get this information from each report. Query builder doesn’t contain this information.

From a high level with the Java SDK:

1. Query CMS for all webi reports.
2. Loop through and open each webi doc.
3. Loop through each data provider
4. Check for combined queries because you need to recursively loop through them
5. Loop through the result objects using getResultObject() method, loop through the condition objects using multiple methods because of the complexity of rankings and subqueries checking for the object and parent folder of the specified object in the universe
6. Output report information you want when a match happens to file or database.

---

bdgeise (BOB member since 2011-12-15)