Query Builder (list of scheduled webi reports using specific universe)

[kbenson]

Hi Experts,

Could you please help with the query to identify the list of recurring reports associated to a specific universe?

I have tried below query, but no results.

SELECT SI_ID, SI_NAME, SI_UNIVERSE, SI_DSL_UNIVERSE, SI_SL_DOCUMENTS, SI_SPECIFIC_KIND, SI_OWNER, SI_LAST_RUN_TIME, si_instance FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Document-DSL.Universe'", "SI_NAME = 'XYZ'") and SI_SCHEDULEINFO.SI_SCHED_NOW = 1

Thanks,

Kristen

[Joe_Peters1 · Accepted solution]

Your query looks ok. Remember that the name of unx universes includes ".unx", so you should be filtering on 'xyz.unx'.

[kbenson · Accepted solution]

Thank you very much, that helps! I didn't have .unx

Could you let me know what would be the query for .unv ?

[Joe_Peters1 · Accepted solution]

For .unv, you have to use the "webi-universe" relationship type, and not include an extension in the name. Ex:

SELECT SI_ID, SI_NAME, SI_UNIVERSE, SI_DSL_UNIVERSE, SI_SL_DOCUMENTS, SI_SPECIFIC_KIND, SI_OWNER, SI_LAST_RUN_TIME, si_instance 
FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS 
Where PARENTS ("SI_NAME = 'webi-universe'", "SI_NAME = 'efashion'") 
and SI_SCHEDULEINFO.SI_SCHED_NOW = 1

[kbenson · Accepted solution]

Thank you very much! it worked.