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.
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.