How to Build a WebI Report Using SAP Bex Query in Business Objects 4.1
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:
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.