Searching the SQL generated by WebI and DeskI reports

[system]

I’m running BOXI 3.1 SP3 on a Windows server. I have about 2800 Webi and Deski reports live. The majority of these reports return data from a Oracle data source that is not managed in-house.

I’m needing an admin type software that can query the repository for all my reports, generate the SQL for each report, spit out the name of the report and the SQL of the report and any filters/variables on the report into a searchable file that I can parse through to look for specific query filters (and report filters if it has any.)

I have method for pulling a list of reports that are using an universe’s object X, but I really need a method of searching all the WHERE clauses all my reports and inside the report in the variables and

Does anybody know of anything that does this that is available for purchase? I’ve tried leveraging the Activity Universe and it’s just too slow to use.

---

tknight (BOB member since 2009-02-09)

[system]

Hi,

This utility can help you with DeskI reports:

DeskI Documents Inspector

Author: Marek Chladny Author notes: Platform: BO XIr2 How to use it: Save all DeskI reports that will be checked into a separate working folder. Open DeskI Documents Inspector in DeskI of BO XIr2. Enable macros (if you get the message that the report contains macros). Use “Select working folder” button and navigate to the folder that contains reports. Type in a keyword in the “search keyword” box. Use * (asterisk) for all. Set what will be searched (variables and formulas, data provider …

---

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