Dear All,
We have one business requirement that we need to provide spreadsheet or report which gives details on "Filter object which is using in query Filter pane in the query panel in all webi reports".
We have gone through SAP Blogs shared by Manikandan on Query Builder queries but haven't find appropriate query.
Found one query but not an appropriate one:
To list all the WebI reports with prompts:
SELECT SI_ID, SI_KIND, SI_NAME, SI_PROCESSINFO.SI_HAS_PROMPTS,
SI_PROCESSINFO.SI_WEBI_PROMPTS, SI_PROCESSINFO.SI_FILES,
SI_PROCESSINFO.SI_PROMPTS FROM CI_INFOOBJECTS
WHERE SI_KIND = ‘WEBI’ and SI_INSTANCE = 0 and
SI_PROCESSINFO.SI_HAS_PROMPTS=1
Business query on above query:
If the filter is not a prompt, hard coded value, how can we capture those?
Kindly suggest me one query to execute in Query Builder which suits my exact requirement.
Thanks
Rama