SAP BO - Webi Report - Issues

Below are the issues which I have faced in developing SAP Bo Webi reports:

1. Cannot change source, if the report is on top of SAP HANA view:

  For SAP BO Webi reports built on top of SAP HANA Views(directly), we cannot change source. I had to rebuild the report on top of the HANA view after any fixes/updates on the HANA views.

Below are the steps to create a Webi report on HANA Views:

Step 1: Choose SAP HANA view as a data source.

1

Step 2: Choose your Connection -> Package and the View.

2_censored

Step 3: Create a report on HANA view.

3a_censored

Step 4: Try to change the data source. Change source button is disabled.

4_censored

So, we cannot change the source here, as we do in a BO universe.

2. Dynamic Tabs in a Webi Report:

 There was a requirement to build a webi report with multiple tabs based on a dimension – Month (dynamic tabs). There is no direct way in webi to achieve this. So, I created a report with all the Months, duplicated it 12 times. And then restricted each of the 12 reports(tabs) with each month.

Work Around:

21-1

You can create a section on Month and set each section to start on a new page. But you cannot set it to start on a new report. So, below is the ideal approach for this requirement.

Step 1: Create a report without any filter on months.

22

Step 2: Duplicate the report 12 times.

23

Step 3: Add report filters on one month per report for all the months.

24

Step 4: Rename the reports with Month Names.

25

comments powered by Disqus