Skip to Content
Author's profile photo Lakshminarasimhan N

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.

Initial_Screen.PNG

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 —

output.PNG

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.




Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Daniel Ray
      Daniel Ray

      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

      Author's profile photo Priyanka Rai
      Priyanka Rai

      Hi, how to get list of all spreadsheet source path which are using in all webi Reports.

      Thanks