We had a request to show the summary of Net Value Billing by Brand (Prod. Hierarchy) in a descending order, if required users can drill down to Product (Material) level.


Data which was coming out from SAP BW system is based on Product (Material). So we had to create a report layout with Prod. Hierarchy and Material based on the requirement.
























We added a Break into Prod. Hierarchy



















Removed extra row and break header


Added aggregation as Sum with context (=Sum([Net Value Billing]) In ([Prod.hierarchy AB&NS]))

and report header.


Note: If we just use the Sum as aggregation it will be summed based on Product, when we use Fold option the values will be wrong.


















Applied Fold option to fold the Material and to show only Prod. Hierarchy


















Now when we applied sort as descending order in the Net Value Billing, values are not getting sorted as descending through Measures. Where as it is getting sort by Prod. Hierarchy.










To achieve this we have to take out the “Apply implicit sort to values” option from Break properties by selecting break column.


Now when you apply sort on measure, it will work as expected.



When we are creating Web Intelligence report on top of SAP Business Explorer Query, we will come across many objects which has compounded with other objects like:


Controlling Area / Cost Center

Chart of Accounts / G/L Account


Compounded objects are taken care in SAP Business Explorer query when we have all the required objects either in Rows or in Free Characteristics.


When we use the same in Web Intelligence report, it shows the data with the compounded objects. 



















We can use the basic functions which is available in the Formula editor to achieve in Web Intelligence report.








1) Find the length of the data say FO00/# = 6

2) Position the “/” in the data say FO00/# = 5

3) Subtract step 1 and step 2 say 6 – 5 = 1

4) Apply right function with the output of step 3 on data




We have a workbook which is broadcasted to run on a daily basis. Parameters are assigned to Location, Planning Version, Product etc., But Calendar Day parameter is with SAP Exit, and it gets populated in workbook for (current day -1).


Now are have to migrate the workbook to Web Intelligence report and schedule it to deliver the output on a daily basis.


When we are migrating the BEx query to BusinessObjects Universe and Web Intelligence report, the Calendar Day parameter is appearing as a prompt. But the value which is returned by the customer exit is not getting populated to Web Intelligence report prompt.


This report is fine when the user has execute themselves on an ad-hoc basis. But the request here is to schedule the report to run on a daily basis.



Step 1:

Create a new variable with Processing Type as SAP Exit









Step 2:

Do not make “Ready for Input” enabled in the Detail tab











Step 3:

Write a SAP Exit to populate the current day for the variable

Assign the newly created variable and replace the existing one with Offset as -1












Step 4:

Now create BusinessObjects Universe and Web Intelligence report.


When the report is executed, you will not see the prompt for Calendar Day in the report.

But the report will get executed with the other parameters provided by the user for (Calendar Day -1).


Step 5:

Schedule the report














Now when we schedule the Web Intelligence report, Calendar Day will not appear  as it is taken care by BEx query variable.

We had a requirement where prompt value should be displayed to the users based on their access. For ex: If user has access to 1, 2, and 3, then he should see only those in the prompt values.


This is not achievable in Web Intelligence report as the prompt value gets data from master or transaction posted data.


To overcome this issue we have introduced Xcelsius to perform the task.


Step 1: Create a BEx query and have the characteristic in the row for which prompt should be created.

Step 2: Restrict the query based on Authorization variable


Note: we need at least one key figure in the columns.























Step 3: Create a Netweaver connection in Xcelsius dashboard and connect the BEx query.

Step 4: Store the data which is coming out of query and make it available in the combo box.

Step 5: Add a URL button, and assign the row A6 of Final URL sheet.


Concatenation formula is written in A6 to join A2, B1, B2, C2, D2, E2, F2, and G2. It will generate the required URL and will pass the value to Web Intelligence report prompt.


When user selects the value from combo box, selected value is getting stored in B2 of Final URL sheet.























Note: B1 is the definition of prompt which is available in Web Intelligence report, it should be as same as Web Intelligence report prompt as shown below.





























Step 6: Created an iView in SAP Enterprise Portal for the Xcelsius dashboard


Values are getting populated in the combo box from SAP BEx Query for which the user has access.
























Select the value from combo box and click on Submit button
























Once you hit the Submit button, it will open the Web Intelligence report in a separate window and it will start refreshing for the selected value.

















Now you have the Web Intelligence report refreshed for selected value which is passed from dashboard to Web Intelligence report prompt





















Web Intelligence report prompt screen with the values passed from dashboard.



Filter Blog

By author:
By date:
By tag: