BusinessObjects Board

Impact Analysis on All Reports

building reports desktopintelligence
#1

Hi,

We need to remove one of the table from our schema. This table is used in universe building as well as in some of the reports (in Free Hand SQL)

Is it possible to find out how many reports have used the objects from universe based on this table and/or also in which reports the table is used directly in Free Hand SQL. :confused:

Jignesh Shah :india: (BOB member since 2004-03-31)

#2

try this one :wink:

bernard timbal :fr: (BOB member since 2003-05-26)

#3

This will help you

NEO

KhoushikTTT :us: (BOB member since 2005-02-24)

#4

Hi,

Thanks for the reply but that code gives me compile error at line

Global Const ErrNum As Integer = 1
Global Const OutNum As Integer = 2

May be i have goofed up something.

Jignesh Shah :india: (BOB member since 2004-03-31)

#5

Depending on which version of BusinessObjects you’re using you may need to make a change (simply remove a line and then paste it back in) in order to get the code “recompiled”. I’ve seen many cases where the code is correct but in moving from V4 to V5 (or to V6) the code just needed to be “touched” first.

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

#6

Thanks.

It worked.

Still I had to modify the code slightly to suite my need.

Thanks again.

Jignesh Shah :india: (BOB member since 2004-03-31)