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

[jayant_nayak2]

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.