Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

List of reports connected to .UNX Universe

Hi,

Please provide me the query for extracting list of reports connected to .unx universe in Query Builder.

I tried the query

SELECT * FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'","SI_NAME =’EFASHION’")

But that didn't work with .unx universe.

Thanks in advance.

Venkat

Former Member
replied

Use this query for UNX universe.

SELECT SI_ID, SI_NAME, SI_UNIVERSE, SI_DSL_UNIVERSE, SI_SL_DOCUMENTS, SI_SPECIFIC_KIND, SI_OWNER, SI_LAST_RUN_TIME FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Document-DSL.Universe'", "SI_NAME = '<UNX Universe Name>'")

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question