Determining Objects Dependent on a Universe

[Former Member]

Using Business Objects 4.0 SP05 Patch 4 on AIX.  Is there a way to get a list of objects (WebIs, CRs, dashboards) that make use of a particular universe?  We would like a way to evaluate the scope of potential universe design changes.

Thank you for any suggestions.

Dave

[former_member191664 · Accepted solution]

Hi,

Use this SQL query in Query Builder on https://your.copr.com/AdminTools/querybuilder/ie.jsp to list all reports that uses the connection (multiple universes)

SELECT SI_NAME, SI_KIND, SI_OWNER, SI_AUTHOR, SI_UPDATE_TS, SI_PARENT_FOLDER

FROM CI_APPOBJECTS, CI_INFOOBJECTS

WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'", "CHILDREN('SI_NAME=''DATACONNECTION-UNIVERSE''', 'SI_NAME=''efashion'' ')")  AND SI_INSTANCE = 0

Please check out BusinessObjects Query builder queries - Part II on http://scn.sap.com/community/bi-platform/blog/2013/02/14/businessobjects-query-builder-queries--part....

Hope this helps,

Jin-Chong

[Former Member]

Use this template posted in Forumtopics.com.

Check this link. it will retrieve all the objects from the repository in to excel and you can apply filter by universes in Excel. Try this.

http://www.forumtopics.com/busobj/viewtopic.php?t=143071