In BI 4.1 WebI, obtaining list of reports which use a certain object?

[Former Member]

We have our reporting solution in BI 4.1 and most of the reports are WebI reports. Whenever we need to update any object, we have to open each report and check every report manually to ascertain whether a report is using the given object.

Is there any simpler way to do this? Can something be built using the SDKs to achieve this? If so, where should one start?

Please pardon my ignorance as I am not comfortable with programming currently but I can learn and try anything. Any help will be truly appreciated.

[former_member198519]

Try exploring the CMS database. Have a look at this blog:

Unlock the CMS database with new data access driver for BI 4.2 SP3

Also via query builder you can explorer the CI_Appobjects table to see where the database fields are used. Try with these SI_KIND objects

MetaData.DataDBField,

ClientAction,

ClientActionSet,

ClientActionUsage,

RepositoryPromptGroup,

MetaData.DataFoundation,

MetaData.BusinessView,

MetaData.DataConnection,

Universe

[former_member206070]

Hi Shivam,

Could you please let us know the source of your webi reports.

Regrads,

MRK