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

Author: 
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.

Prerequisites:

  • 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

BHQ_BICS

Executive+Dashboard+Daily

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.

Set+Variable

Result+Object

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:

Add+Element-1

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

Vertical+Table

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.

MTD+GP

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

Null+Value+Soluiton

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

Fix+Data+Format

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

Format+Table

Format+Table+Shows+Rows

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

Document+Summary

Options

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.

Report+Output

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.