List of reports connected to .UNX Universe
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.
Jawahar Konduru 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>'")