Skip to Content
0

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

Nov 01, 2016 at 08:32 AM

90

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ravikanth M Nov 01, 2016 at 12:54 PM
0

Hi Shivam,

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

Regrads,

MRK

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Nov 01, 2016 at 01:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded