Is there a way to get the list of objects used in a report ? Or to get the list of reports that are using an object ?
I’m planning to change an object, but I’m uncertain if it’s used in some other report. I’ve seen that there’s a way to do it in Desktop I., but couln’t find a way to do it in WEBI.
The closest you can get is to find out which reports use that universe. I don’t know of any way in Webi to determine which reports use a specific object in a universe.
The closest I can think of in Webi is to do a “Content Search” of the object name. If the object name has not been changed within documents, it might show up.
You may want to check out the WID Scanner tool that is available for download here:
It examines the physical .wid file and parses out objects used in each report.
Otherwise, you can code something using the Report Engine SDK to pull this information, or trial a 3rd party product for this - System Profiler has canned reports that display objects used in reports…