BusinessObjects Board

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 closed.
  • A message will be displayed when the refresh is complete.

Please note that it is not possible to record objects used in sub-queries, or when an object is used as the operand (right hand side of a condition). This is a limitation of the object model.
List Objects Used - XI.rep (124.0 KB)
List Objects Used v5, v6.rep (88.0 KB)

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Getting Database information for an Object Using VBA
List Objects Used in a set of Documents
determining reports to be affected by universe modification
Extracting table names from universes
'How to' document question
Finding the objects within a report .. using query builder
Document a universe using Excel and the Designer SDK
SQL Query to fetch Document information from the Repository
Is It Possible to know how many reports contain a Specific
Querying metadata from Universe
How to get list of reports which contains macros?
Tool for documenting reports
Code for Extracting .rep file from a particular Folder
objects associated with reports
How to create a documentation for all reports?
Need to check all Reports generated on a database table.
Can we read all Objects from .rep file
Crossreference for BO 5.18 ??
Report Comparison
Use VBA SDK to find out Objects in Reports
hierarchies objects used in the reports
Export object ,class, description, query
VBA Macro to get DeskI report metadata information
Is there a XI utility to list Report/Universe/Uni connection
SQL/Report to get Reports based Universe
How to get the reports using a table from the repository?
Finding Report for the Objects created in Universe
Finding Report for the Objects created in Universe
Field identification
Dimension Impact in a Reports
List of objects used in report..
list of reports using query builder
How to find how many reports were using 1 particular object
find object used in Diff Reports
List of report objects along with report names in a folder
Total number of rows in the webi & deski report
Searching of the reports which are using TESTOBJ object
DESKI Objects - export?
List of BO Report Names based on the table name
Find universes on which reports are based
Which report is attached to this object ?
Work Out Objects Used In Reports
What reports use a particular object?
Identifying Objects associated to an Universe
Universe Reports Objects Column
How to identify reports where an object or LOV was used
retrieve table names from derived table's SQL (or in general
Find Objects used in all the Reports
How to search specific DB function used in report
List of all column names in the report.
How to know number of webi,deski reports,batch reports runni
Objects used in which reports
Objects used in report
objects in a universe used in report
What objects used in what report?
[VBA] Is it possible - object ID in a data provider
where i can see Universes
Any to know which reports are using the universe objects
Retrieving Dataprovider information
Inserting comments to formulas and documenting reports
Is certain Object in use ..or is it not?
How to easyly have a lists of all available reports
Universe join
Tool to display reports and which universe they are using.
Reports Dataproviders
deleting not used objects in the universe
Extracting Select Statements
Report elements of 5.1.x/2.7.x(.rep/.wqy) into xml/.csv
Impact Analysis
Report Document Generator
how to see in which report a object is used
Document a universe using Excel and the Designer SDK
Code to create a file that lists all rpts that use an object
Extract data from Full client reports/pdf to reuse in query
Which reports use my universe?
Downloaded reports do not work
Is there a way or tool to print or grab info of report
Creating reports from CMS Repository XIR2
Identify Reports that use Specific Universe (6.5)
Report Sql scan
List of reports with specified object
What reports are using a particular universe
List of Objects used in report
How to get list of all tables used in a given universe
Data Provider Links....
How to find all the reports which are using a certain table
Universe Auditing and Meta Data
compare 2 (same) reports & show all new/update/added obj
Alphabetized Index to BOB's Downloads
Help: Locating Filter and Condition Values in a Repository
How to open multipule reports
Searching through all Reports
List of tables
Help with Download post-List Objects Used in a set of Docume
Impact of object deletion in reports
Visual Basic + Business Objects
how to get sql for a list of reports using VBA
Query Builder to find Filters?
Creating Auditor report to show Folders and all reports?
Documentation of Documents
List Reports that use a specific TABLE?
List of Objects and variables in a series of reports
Associating reports with Universe.
XI Designer: Show in which report an object is been utilise
Is there a XI utility to list Report/Universe/Uni connection
Report and Universe Meta Data (BOXI)
Report Search
Getting Information from Repository Tables
Which Reports Use Which Objects
Find out which objects are actually used
Find out which objects are actually used
Querying Repository in 6.5
How to list all the objects with physical tables and columns
Universe Where-used
Remove Objects
linkage dimension detection
finding objects used in Reporter
Work out what objects are used in Reports
Searching Report Files by Universe
Metadata and Universes
Overview universe-objects NOT used in any report
Where do Report objects sit in the repository?
Objects used in BO XI Reports
Objects used in BO XI Reports
Mapping Correspondence
Reporting on objects in reports. Can someone help me please?
Problem running report - Obsolete objects?!!!
How to find Reports in Repository using certain table


Can this report be modified to handle the exceptions like if all the reports in the folder doesn’t have the required permissions to open?

But undoubtedly, it works well and give the best results.

Great Work!!!


BO_Stuffed (BOB member since 2008-03-29)

Possible? Probably yes, but if the files are stored locally, what kind of permission issues are you seeing? Read-only, something else?

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thanks for your reply.

I had created some reports with different user account and they could not be accessed via the account I am using currently, though they can still be accessed using the administrator credentials.

Now the problem with using the administration credential is that the report does not pick up the right universe or it comes up with the screen to choose the universe from and this application ends up in error.

I am very sure you can put a log somewhere on the same folder stating the files which were not processed and still continue with the next.

Kind Regards

BO_Stuffed (BOB member since 2008-03-29)

Indeed, but I will politely decline. The utilities I post here helped me get through some tedious work of my own. I share them in case someone else finds them useful, to serve as samples of the kinds of things that are possible with the SDK, and hopefully are worth at least as much as you paid for them :slight_smile: .

The kinds of behavior you are seeing are the same things you would see if done manually. Those behaviors were not issues for me, but you are more than welcome to enhance the utility to handle those situations for yourself. No extra charge!!!

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

This works great!!!.

Did you also by any chance did the same for Webi reports as well? sorry for asking… but couldn’t help myself :slight_smile:

anair_bo :us: (BOB member since 2006-12-05)

I have not, but someone else has … WID Scanner

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Hi Dwayne,

I know this is an old thread now and you probably barely use the report, but I have a question.

I’ve adapted the code in this report by adding the code to retrieve user-defined variables and also enabling the report to look in sub folders. This all works fine (with a lot of help from a collegue), but it stumbles whenever a document it opens contains Document_Open macros designed to auto refresh. I have somewhere in the region of 2000 documents for the code to go through, so this will take an age to process all the documents designed to refresh on open (it also crashes on a number of them where they are set up to save a copy or email out etc). Basicaly, my question is “can I avoid the Document_Open command on opening?”.

I have tried a number of work arounds, including restricting the users ability to refresh reports (in Supervisor), but this disables the data provider, restricting access to the universe.

Any ideas would be greatly appreciated.


PS working on BO 6.5.1 on Oracle 9

agowinuk :uk: (BOB member since 2006-08-25)

I’m not sure that is possible. If you have the “Refresh Document When Opening” set, that is already handled (won’t execute) with one of the .Open method parameters. If your own code is doing the refresh, I can’t think of a way to avoid that.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Ok. Thanks for the reply.

agowinuk :uk: (BOB member since 2006-08-25)

Can someone assist me in getting this to open? I’m assuming it is a Crystal Report file and I should be able to open in CR XI.

When I try, I get an error message that says:
This document has the expected file extension (.RPT), but seems to be corrupted. If this report used to work, try opening it with a different version of Crystal Reports and if that still does not work, please contact your administrator.

I’ve tried both the XI and v5,v6 files and get the same message from either.

Any pointers to show me how to use this?

Many thanks!

neheyen (BOB member since 2006-08-22)

What would give you that idea? The .rep extension indicates a full client (now called Desktop Intelligence) document. Manually changing it to .rpt is not going to make it a Crystal Reports document, sorry.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

I have a question about this… I’m working with the download for 6.xx and wondering; We have a universe created that gives us backend information about users, groups, universes, etc. On the report from the download, I’m trying to create/add a dataprovider to go after information with this “backend” universe we have. In the universe we’ve got an object called “Universe Name” that is created from table/field, universe.M_UNI_C_LONGNAME. On the report, I’m linking this object to the Object, “Universe Name” which on the download is DataRow(5) = DProv.Universe.LongName in the code. (I changed this from 'DataRow(5) = DProv.Universe.ShortName & “-” & DProv.UniverseName).
The data that comes back is identical but it’s not working. The VBA code is working properly, listing only the universe(s) used in the report(s). But the object from my new dataprovider is giving me all universe names that we have, and I’m just expecting the universe name(s) that are on the selected reports. I’m wondering….is the VBA code executing before or after the dataprovider is refreshed? Reason why I’m here is that I use this awesome download to list the information about a report but I’m also trying to get more info about the universe…I also want the table and field names of each of the objects on the report…

Hope I explained myself ok!

nonyup (BOB member since 2008-01-07)

Will it be possible for you to provide the code which can retrieve objexts used in user defined variables?

mkumar (BOB member since 2002-08-26)

Try this … List report level variables in full client reports

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Hi Dwayne,

Reviewing your code, I could improve it, including SQL objects. How can I send it to you, to posted in the forum?

Maybe it could be helpful


leonardo.contreras (BOB member since 2008-07-07)


I’ve read your post and I am very intersted with your code for the two next pbs :

  • enabling the report to look in sub folders
  • avoid the Document_Open command on opening

Thank’s for your help

Ty_Bou :fr: (BOB member since 2005-02-16)

Take a look at the latest version of this utility … Save for all users. It includes a technique for recursively processing a folder structure.

As previously stated in this thread, I don’t think there is a way to prevent the Document_Open event from firing.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Code below is the main change, in the Dwayne’s code, to process Manual Querys.

                'code included to process Manual SQL Querys.
                  'Processing Manual Providers
                  If DProv.GetType = "DPSQLC" Then
                     DataRow(3) = DProv.Name
                     DataRow(4) = "SQL"
                     DataRow(5) = "SQL Manual"
                     DataRow(6) = DProv.Name
                     DataRow(7) = ""
                     For Each Col In DProv.Columns
                        DataRow(8) = "Field"
                        DataRow(9) = "Variables"
                        DataRow(10) = Col.Name
                        DataRow(11) = ""
                        Call dpCube.DpVBAColumns.AddLine(DataRow)
                     Next Col
                    End If
                End If

Maybe it helps


leonardo.contreras (BOB member since 2008-07-07)

Is there any limit on the number of documents it can process? I cannot run this macro for 600+ reports.

BOisBest :india: (BOB member since 2004-04-05)