List of WEBI reports using BEx Queries as the data source
Applies To
http://help.sap.com/businessobject/product_guides/sbo42/en/sbo42_whats_new_en.pdf
Summary
This Document describes how to identify the WEBI reports created based on BEx query as datasource.
Author Biography
Lakshminarasimhan Narasimhamurthy is BW certified and ABAP certified consultant and worked on multiple implementation, development and support project’s within India and outside of India. He has worked for fortune 500 clients like Nestle, Warner Bros, GCC, General Electric etc. He is strong in BW, BW related ABAP, HANA modeling, BODS and BO/BI tools like WEBI, Dashboard, IDT, Lumira.
Details
WEBI reports are used in many places with BEx query as the datasource. When there is a House keeping activity on BW end(They want to delete unused BW reports), they will ask for the list of BEx queries used by WEBI reports. Unfortunately we dont have any such tables in the BW side.This document will fetch the list of BEx queries used by the WEBI documents.
Query Builder is a tool to get the the list of such reports. Query Builder is a web-based application and can be accessed through following URL: http://<bo_server_hostname>:<port>/AdminTools
Similar to CMC & Launch pad we can access it via Web.
You need to run the query from here using the given below query.
CI_INFOOBJECTS is the (virtual) table where all of the information’s are stored.
Field SI_KIND shows the type of the document(WEBI or Crystal etc) & the field SI_WEBI_DOC_PROPERTIES contains many parameters and one of the parameters DSNAME(Datasource name). Our BEx queries start with ‘Z’, hence i have used the parameter DSNAME=%Z%
SELECT
SI_NAME , SI_WEBI_DOC_PROPERTIES
FROM CI_INFOOBJECTS
WHERE
SI_KIND = ‘Webi’ AND
SI_WEBI_DOC_PROPERTIES like ‘%DSNAME=%Z%’
Output —
You will not be able to download the data to an excel sheet.
Note – It is better to maintain a excel sheet with the WEBI report name and the BEx query name. The same can be loaded to a master data infoobject/DSO and we can even generate a report of the number of WEBI reports based on BEx from the master data infoobject/DSO.
how to access query builder ? I have tried it and its not working even I have admin access in CMC. Is there anything to enable query builder in CMC ?
Thanks
Hi, how to get list of all spreadsheet source path which are using in all webi Reports.
Thanks