Impact Analysis

[Former Member]

Impact analysis on Web Intelligence reports when database fields are modified

SAP Web Intelligence reports could be impacted when the underlying database fields (table name/column size/data type, etc) are modified. We have about 1000 SAP BO reports pointing to different Universe (built on Oracle Database). When a table/column is renamed or deleted in the database, how do we find out which all reports are impacted by this change.

Right now we are doing it manually by checking each Report & the corresponding Universe and Derived Table queries, but it is a huge effort. Is there an easier/simpler way to do this.

[lenastodal]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members.
Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond:https://www.youtube.com/watch?v=46bt1juWUUM
Many thanks!

[DellSC]

You would use the Semantic Layer SDK (Java only) or, if you have UNV universes, the Designer SDK (COM-based, easiest to work with in .NET) to determine which universes use the changed tables and then match them up to the reports through the Webi RESTful SDK.

-Dell

[ayman_salem]

The only thing you can do is to write your own script with the BI 4.x SDK (RESTful, ...) to first find out which universes have the changed table and which objects refer to it, and then which Reports on these universes have been created, then in the report which query has the changed objects.