In this post, the video below will show you the method to build your WebI report upon your BEx query. Enjoy it.
Step by step description of the above video:
The purpose of this essay is to explain the method to explain in detail how to build WebI report on Bex query.
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 at 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 is 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.
