list of reports using query builder

[system]

hi friends
I have 1500 (deski+webi) reports under ‘ISM’ universe and some of the reports are using xyz.pqr object(xyz=table_name and pqr=object_name).
so, i need the list of all those webi reports under ‘ISM’ universe sharing xyz.pqr object …please help me.
If it is possible through query builder,please provide me the query.

---

anirban ghorai (BOB member since 2013-06-27)

[system]

Hi there,

it’s not possible directly with query builder as this information is stored in the file system.
there is a “WID scanner” in the BOB downloads section that can help you with the Webi files. However you’ll need direct access to the filestore.

WID Scanner

version: BOXI rls2 platform: MS Windows JBO jbo_911@hotmail.com download grep @ http://sourceforge.net/project/showfiles.php?group_id=23617 Updated 8/14/2007 – Version 1.1: -fix export path, spaces were not allowed -added FullClient documents to documentlist (no object scan is done, other tools available) -added filesize in KB of the documents -Instances are (if wanted) excluded in a proper way WIDScanner_1_2.zip (43.0 KB) jbo (BOB member since 2005-07-31)

There are also tools for Deski documents but I haven’t used them yet:

List objects used in a series of reports

Author: Dwayne Hoffpauir, EDS 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 objects recorded. There will be a lot of screen flashing as the documents are opened and…

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 …

cheers
MU

---

Miss Universe (BOB member since 2010-02-16)