BusinessObjects Board

Please Give the link to list objects used.rep

general discussion
#1

Hi friends,

Please give me the link to download list objects used.rep Report.
I have searched for more than one hour and not able to find it.

Its very Urgent. Please dont give the link to VBA.

Thanx,
Monkey

monkey (BOB member since 2005-10-08)

#2

That’s what we have. As far as I know, this is what you’re talking about, and that’s what is currently available on BOB. You simply start a new document, copy that VBA code into that document, make a few configuration changes, and you have it.

Dave Rathbun :us: (BOB member since 2002-06-06)

#3

Hi Dave,

I am a newbie to VBA.
Can please tell me where to put the code and what changes to be made and the entire process.

Thanx.

monkey (BOB member since 2005-10-08)

#4

Not today. :slight_smile:

The code as written has some hard-coded values in it. Those need to be updated to fit your situation. As far as creating the document…

  1. Create a new document with no data providers in it
  2. Invoke the VBA Editor (I use Alt-F11 but there is a menu option as well)
  3. Create a new “User Module”
  4. Copy in the code
  5. Adjust as required

The code creates a CSV file that contains information about all of the REP files in the folder that you point the code to. You can then use any tool of choice (Excel or even BusinessObjects) to open and analyze that file.

That’s as much time as I have for this today. Give it a shot, or find someone else at your company that is more comfortable with VBA to help.

Dave Rathbun :us: (BOB member since 2002-06-06)

#5

Monkey - I haven’t used this piece of code, but in general try the following:

  1. Open BO
  2. Create a new dummy report
  3. Goto Tools - Macro - Visual Basic Editor
  4. Double click “ThisDocument” in the left hand side
  5. Copy and paste in the code
  6. Read through the comments of the code to see if you need to change any directory paths or anything
  7. Close the Visual Basic Editor
  8. Goto Tools - Macro - Macros
  9. Run the appropriate sub

I haven’t tested this with this sub, but in general that’s the process.

Cheers,

Erik

EWilkinson :us: (BOB member since 2005-12-07)

#6

An hour? Try searching for “list objects used rep” and you’ll find this post near the top of the list.

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

#7

HI dave,

Just some 1 hour back I was able to see and download that list objects used.rep. But Unfortunately Deleted it.
Can you please search and see.

Thanx.

monkey (BOB member since 2005-10-08)

#8

Thanx a lot.

I got the report.

monkey (BOB member since 2005-10-08)