Skip to Content

Identical Report on Webi

Hello

Please let us know how to identify identical Webi reports

In our repository there are 10000+ reports, It have a requirment in order to identify identical Webi reports which are all using same objects or universe or tables

1.How do I achieve this requirement?

2.Is there a way do it in BO SDK Java or Query Builder?

Regards, NK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2017 at 07:10 PM

    To find all reports that use a universe, you can go to CMC -> Universes, right click on a universe and choose Tools -> Check Relationships to compile a list of reports that use that universe.

    or run the following query in the Query Builder

    SELECT TOP 100000 SI_CUID, SI_NAME, SI_KIND, SI_OWNER FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
    Where (
    PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'")

    ) AND SI_INSTANCE = 0

    However, to all reports which are all using same objects or universe or tables, you may need to compile it in BOMM on BOXI3.1 or in Information Steward on BI4.x.

    Regards,

    Jin-Chong

    Add comment
    10|10000 characters needed characters exceeded