BusinessObjects Board

List report level variables in full client reports

Author: Dwayne Hoffpauir, EDS Corporation

The attached utility will record named report level variables and their formula that are used in a series of reports. Usage is as follows:

[quote:ce6effceb0=“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.
    [/quote]

The utility is written in v5, but also seems to work in v6 and XI.
List Report Variables Used, v01.rep (85.0 KB)


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

Hi,
Did someone already tried (or succeeded) to retrieve report level variables from WID documents ?
The WID scanner doesn’t either include this functionnality…

I would try this in XI 3.x.

thanks in advance for you answers.

Benoît


benasirennes :fr: (BOB member since 2005-03-21)

hello Dwayne Hoffpauir

is there any report for getting list of objects for web i documents . Thanks for providing for .rep documents


rekha (BOB member since 2008-06-08)

Are you asking about the objects from universe? If yes, then you can go for WID Scanner.


Jansi :india: (BOB member since 2008-05-12)

hello Dwayne Hoffpauir

Thanks a lot for reply. I need a reports which gets all web i documents and their associated universes.


rekha (BOB member since 2008-06-08)

hello Dwayne Hoffpauir

How to use this wid scanner. i downloaded grep software. iam not sure what to do next


rekha (BOB member since 2008-06-08)

Rekha,

As you might already find out, Dwayne is not the author of WID scanner nor does this topic discuss the same. So please ask your questions in more appropriate forum, here:

Thanks.


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

Great macro. As noted in the thread on the objects the Variable Formula can be truncated to 256 characters. To work around this I added a line to the DefineCube function (MaxWidth bit) :-


Function DefineCube(dpCube As DpVBACube) As DpVBACube
    
    Dim dpCol As DpVBAColumn

    Set DefineCube = dpCube
    DefineCube.DpVBAColumns.SetNbColumns (3)

    Set dpCol = DefineCube.DpVBAColumns(1)
    dpCol.Name = "Report Filename"

    Set dpCol = DefineCube.DpVBAColumns(2)
    dpCol.Name = "Variable Name"

    Set dpCol = DefineCube.DpVBAColumns(3)
    dpCol.Name = "Variable Formula"
    dpCol.MaxWidth = 1024

End Function

DanDensley :uk: (BOB member since 2009-05-12)

Hi Dwayne,

Thank you so much for such a great utility. I am using XIR2 Deski but what I have noticed is that the macro is skipping the Detail variables created at the report level sometimes.

Any possible reason for that or a code change?


alexks (BOB member since 2008-03-25)