how to get all the reports of a particular universe including all the information of the report and also its universe using the query builder
Srinivas Ganapathi replied
This will have to be done in 2 steps:
Step 1: The query below returns all the WEBI documents assigned to the Universe specified. SI_WEBI contains the SI_IDs of the reports:
SELECT SI_NAME, SI_WEBI, SI_DATACONNECTION FROM CI_APPOBJECTS WHERE SI_KIND = u2018universeu2019 and SI_NAME = u2018Universe Nameu2019
Step 2: This query below returns Webi report names from the SI_WEBI list in the result-set above.
SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID IN (list of SI_WEBI from Step 1)
What report properties are you looking for? If you mean report objects, then you're out of luck. You can't get this from Query Builder (you'll have to use the SDK or the Audit db).
Edited by: Srinivas Ganapathi on Nov 5, 2008 8:55 PM