Identical Report on Webi

[naveen_kumar29091984]

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

[former_member191664 · Accepted solution]

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