How to Build a WebI Report Using SAP Bex Query in Business Objects 4.1

Maria Wei

Did you know you can easily build a Webi (Web Intelligence) Report based upon a SAP BEx Query?   This example will show you how to build a two table webI report, where the left table shows a summarized view and the right table show’s the details for each customer selected.


  • BOBJ BI 4.1 Server
  • Web-Intelligence app is installed and deployed on your server
  • A SAP BW (Business Warehouse) system with bex queries created and with the query property “External Access for OLE DB” enabled for at least one bex query.
  • A BICS connection must have been created in your system prior to following this article. See our other blog on “How to create a BICS connection”.

Step 1: Log on to the BI LaunchPad, create a new WebI report and select BEX query as data source:

Add Element

Step 2: Select the BICS connection and query to be used



Step 3: Set variables and filters and drag and drop required objects to “Result Object” panel. Click “Run Query” button on the top right corner.



Note: Add filters in query panel to get better performance instead of adding filters in report although in our case we do not have filters needed.

Step 4: Drag and drop the required objects to the body of the report, right click the edge of the left table (sales rep table) and add a drill down link to the sold-to-party table:


Click through to the final page and choose the tables that will be connected to the left table, then click “Finish”:


Now we have built the drill down connection between the 2 parts. We can simply click any sales representative on the left and see his/her customers and transactions accordingly in detail.

Step 5: Overall result comes to the top of the report so that the report viewer can easily find out the aggregated result of each object.


Note: if one column contains null values, we could use this formula and get rid of those null values:


And also if there are any requirements on data format, we could also include the requirements to our formula:


There is an easy way to do zero suppression in “format table” tab:



Step 6: Make sure that the “refresh on open” option is checked so that the report will be refreshed every time it opens.



Step 7: Adjust the format of numbers and header to make it look good. 

The report output and two table drill-down will look something like the following screenshot.


There you have it. Seven simple steps you can follow to build a webi report based on an existing SAP BEx Query. If you have questions about SAP Webi report development or about your SAP BO system landscape, we offer a SAP BO Assessment Service to help you understand your current system status and develop a roadmap for future system improvements.