Scheduling Web Intelligence report with dynamic calendar date using SAP Customer Exit

[Former Member]

Scenario:

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.

Solution:

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.