system
February 10, 2004, 10:24pm
6
There’s nothing in the repository that shows you the report objects in use. You can get data provider to document, but that’s about it. In order to do the type of analysis that you are both asking for requires that you open each report and scan through it object by object, mapping back to the universe meta-data that is contained in the repository.
There are some code samples (VBA) in BOB’s Downloads are that you can take a look at. Also any number of topics in the SDK forum discussing various approaches.
I’ve used Dave’s code to identify the list of objects used in a report (and if I could figure out how to link to the download, I would place that link here).
I know almost nothing about VBA so it’s a miracle that I got Dave’s code to work for me. My question is “How would I modify the code to obtain the object’s SQL as well?” I am mainly interested in the Select but some of our objects have Wheres also (and I guess the conditions have Wheres instead of Selects!). TIA
I have a directory with over 600 reports in it. One of our objects is changing significantly and we need to identify which reports contain that object. Does anyone know if this can be done without opening each report?
Is it possible to run some VBA code to return the document variables by report tab. ie tab1 uses Variable1, variable2 and tab2 uses Variable3 and Variable4
Nov (BOB member since 2003-10-15)
Also in the Supervisor forum:
I am preparing for a potential universe re-design, and I was wondering if there’s a way to query the repository and find out which universe objects are being used on my reports (I’ve found tables that tell me the reports, queries in the reports, and universe objects, but I’m looking for a table to join it all together). I need to know which objects I need to keep my reports working while I trash the unused ones.
Thanks,
Meredith
Meredith (BOB member since 2004-01-26)
X-cc: Doug Hansen dhansen@softwareworks-inc.com
Hello All,
I am trying to write a report that can be used for determining the impact of making a change to an object in a universe. I would like to be able to go against the repository and see all documents that have data providers that use that object so I know which reports need to be tested. I am not finding the details I need.
The OBJ_M_DOCATVAR table lists the data providers for a document and tells you which universe it uses.
I did a "SEL…
Is there a way to query the repository tables to find the name of the objects that are being used in Reports. If there is a way what tables need to be joined together to do this?
Listserv Archives (BOB member since 2002-06-25)
Happy reading! 8)
Dave Rathbun (BOB member since 2002-06-06)
(BOB member since 2002-06-06)