Finding tables and views from reports

system · June 7, 2011, 8:48am

Hi,

I have been asked to find a solution to automate the process of finding the SQL views and tables that a report points to on BO XI. Any idea as to how I can go about getting this done?

Thanks in advance!

nivin (BOB member since 2011-06-07)

system · June 7, 2011, 8:55am

Welcome to B:bob:B!

Check whether the WID Scanner utility from the BOB’s download section can help you in this regard:

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

system · June 8, 2011, 5:55am

Thanks Marek!

But the WID approach does not seem to be working. It gives you info only upto the Universe level. Is there a way to drill down further?

nivin (BOB member since 2011-06-07)

system · June 8, 2011, 6:40am

I am sorry but I am not sure cause I am not the author of the utility.

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

SebastienGoiffon · June 8, 2011, 6:59am

What type of reports do you have within your cms and do you have any deski end user?

system · June 13, 2011, 10:50am

Webi and Deski reports and Deski end users are present.

nivin (BOB member since 2011-06-07)