BusinessObjects Board

List of Webi Reports using a specific Data base Table/Column

building reports webintelligence
#1

Hi Team,

Is there a way to find out the list of all Webi reports using a specific Database table / column ??
For say,I have a table T,Column C and a dimension object D.Is there a way to find out all the reports in which T.C is used ??

This requirement is for Impact Analysis when we remove this Table Object from the Data base.
Please help in this regard.

Thanks in advance,
Dheeru

dheeraj.patta (BOB member since 2011-03-13)

#2

Hi,
There is tool in BOB downloads to get list objects used in the reports.

forgotUN (BOB member since 2006-12-13)

#3

Is there any way to do it without any 3rd party tools?

pl80 (BOB member since 2012-09-18)

#4

I am interested in finding out which database tables and fields are being used in Webi documents. If we delete a field or table in our Oracle database I need to know if any documents are using objects created from any of these fields. The output I would like would be something like:

Database table name
Database field
Webi document name
Data provider name
Object name

There are some useful tools out there but I’ve not seen anything that specifically does this job. Any help appreciated.

ChrisTopping :uk: (BOB member since 2012-04-19)

#5

looking for the same thing. Any luck on this?

mithu81 (BOB member since 2010-03-04)

#6

The SAP tool to help with this is Information Steward. We use it with, shall we say, mixed success. :roll_eyes:

Lugh (BOB member since 2009-07-16)

#7

Only way you can achieve is if someone in your organization has better idea on CMS , Audit database tables

Thanks
Pradeep

pradeepreddygade (BOB member since 2012-07-11)