Publishing Webi Report if there is a prompt with dynamic input values

Note:- This is a very specific requirement  and may be referred if it matches with the below background.

There is a challenge to publish WebI report with a dynamic prompt value. The below steps are performed as an alternate to achieve the task.

Tool used – SAP Business Objects 4.2 (Web Intelligence)

Background: – The WebI report runs daily with a Mandatory Prompt value (Load_Date). The Load_Date value is populated from data base and every cycle of data load is associated with a LOAD_ID. The value may be one or multiple for a particular data load date and there may be one cycle or multiple cycle of data loads in a particular day.

But the prompt value accepts LOAD_Date as parameter. In a particular LOAD_date, it may have multiple LOAD_IDs.

So in order to run the report, we have to take the MAX(LOAD_ID) for a particular LOAD_Date and display that details in the report.

Details :-

Step 1 – Go to EDIT query mode in the BI Launchpad

Step 2- Create another custom query

Step 3 – Follow the necessary settings to the new prompt value

Step 4 – Change the Filter to Load_Id field.

Step 5 – Create a Publication and disable the option of passing Prompt value

The Publication went successful.

Conclusion: – There are many ways to Publish a report using a dynamic Prompt. The above method being used as an workarounds in real production environment and mostly it’s specific to a typical requirement.