Skip to Content

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

query builder

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

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

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