Skip to Content
0
Former Member
Jun 15, 2015 at 09:11 PM

Need a List of WEBIs built on top of a specific Universe (Only from PUBLIC folders)

288 Views

BI Gurus,

Could you please let me know -

How to obtain a list of all WEBI reports built on top of a specific Universe? I know the below query can give me all the reports built on top of a specific universe. But below is the problem with this.

SELECT SI_ID, SI_NAME, SI_WEBI, SI_OWNER FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'Universe Name'")

  • It lists all the WEBIs built on this universe from their personal folders, Inboxes, Instances through out years - So the result is 1000's of rows of report names. All I need is only WEBIs from the PUBLIC FOLDERS - not the USER INBOXES, PERSONAL FOLDERS, FAVORITES, INSTANCES HISTORY etc. How to achieve this?

ENVIRONMENT: SAP BUSINESS OBJECTS 4.1 SP4

It would be great if someone can help with this.

Thanks,

RCC