Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 01, 2016 at 12:54 PM

    Hi Shivam,

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

    Regrads,

    MRK

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 01:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded