Skip to Content
0

Identical Report on Webi

Jan 13, 2017 at 04:57 AM

121

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
JinChong Tsai Jan 13, 2017 at 07:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded