Skip to Content
0
May 20, 2020 at 02:07 PM

Query Builder query to find out an object which is using in query Filter pane in all webi reports

807 Views

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