BusinessObjects Board

Which Reports Use Which Objects

general discussion
#1

Hello,

I need to do some impact anaylsis and need to identify which reports use which objects. There is around 300 reports on the repository and I dont really want to do each one manually. I was hoping I could list out the report name and objects used from the Managero.unv universe or the other one on BOB download for ‘Repository, BCA’ etc, but it doesnt seem possible from these.

Is it possible what I want to do ?

Rich :uk: (BOB member since 2002-10-04)

#2

There’s a Bob Download available for this.
Can’t remember the link, but if you have a look down the list, it should be obvious.

#3

Only works for full client documents, and they must be imported from the repository in order to make it work.

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

#4

Dave, I tried to run this Macro and got the following compile error pointing to line:

Global Const ErrNum As Integer = 1

Error message:

Constants, fixed-length strings, arrays, and Declare statements not allowed as Public members of object modules.

Can you comment? I’m by far no VB expert.

Ted Michalski :us: (BOB member since 2002-08-20)

#5

Dave, can you give me some suggestions?

Ted Michalski :us: (BOB member since 2002-08-20)

#6

You’ll find another option here. Similar to Dave’s conceptually, but stores the result inside of a full client document instead of a text file.

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

#7

Thanks Dwayne, but when I try to refresh, I get a type mismatch on the following line:
Set dpCube = DefineCube(dpInterface.DpVBACubes(1))

Any suggestions?

Ted Michalski :us: (BOB member since 2002-08-20)

#8

Ted,

I had a similar problem last year, perhaps this link might help:

https://bobj-board.org/t/41600

anorak :uk: (BOB member since 2002-09-13)