Skip to Content

Impact analysis In BO 4.1 Webi.we want to know that how many reports has been used the particular table.

Hi Friends,

I am working on SAP BO 4.1..I have one query here.

we have 400 webi reports.Now we want to know that how many reports has been used the  particular table.

In the Data base side they are going to change the table.so we want to know how many report has been used that particular table. Manually its bit difficult because we have more than 10 query's for each report

Just we want to know If that table has been used in the report.

1)which query has been used.

2)what is the object name

Could you please tall me any automated way to this.

Thank you in advance.

Regards,

Ramki.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 29, 2015 at 09:09 AM

    If you have auditing enabled and configured appropriately, you should be able to query the objects the report uses, but not by table or query (in my experience).

    See:

    Objects Associated with a Universe

    If auditing is configured appropriately and you're recording the query SQL, you could potentially parse this for mention of the table - but in my experience, this approach is extremely resource intensive - plus it won't tell you which query contains the object.

    See:

    Report Queries

    Suggest this is a job for the SDK.

    HTH

    NMG

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2016 at 10:34 AM

    Hello,

    Unfortunately there is no automated way by which you can get the details.

    The least you have to do below:

    Option One:

    1) Since it is only one Universe, just Right click on the Table which is going to change and see "Show Associated Objects". This will show all the objects created on top of that Table.

    2) Then the extensive step. You need to check into each report with those objects.

    Option Two:

    1) Though it is not recommended, if you have any Sandbox Server you can just move those reports to sandbox with dependencies (this will take universe and connection).

    2) Delete the table from universe. This will have issue in reports.

    3) Schedule those reports with "Run Now" from CMC. Obliviously reports with Objects used in Query will fail.

    4) From Instance Manager you can get details of those Reports.

    Regards,

    Sushil Padhye


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 03:24 AM

    Hi,

    In Query Panel,u can see which Query has been used and which objects and all..

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2015 at 04:30 AM

    hi ramki,

    just list out all the universes built on the table by using Query builder tool.

    just follow the url to understand it

    BusinessObjects Query builder - Basics

    beside this if you know the universe name of that particular table ,you can simply go in to the CMC--->Universes---->choose the related universe and use option Tools--->check relationship.

    regards,

    thrinad.

    Add comment
    10|10000 characters needed characters exceeded