How to enter the prompt values when scheduling Analysis Workbooks in BI platform
When scheduling Analysis Workbooks in BI platform it is possible to use variable prompt values. This scenario is supported from AO BIP ADD-ON 1.4 SP10 and BIP 4.1 SP5. This is also mentioned on SAP note below:
- 2134836 - Checklist for Scheduling of Analysis for Office Workbooks
Below is the screenshot of the prompt in BI platform:
The following consequences may occur when these fields are not filled correctly:
- The workbook will not be scheduled and it will fail (e.g. there are mandatory variables in prompt);
- The workbook will be scheduled but contain unexpected results.
The most common mistake is entering the technical name of the data source in "Data Source".
In order to fill the fields correctly, make sure to always enter the values according to the following:
|Data Source||Alias of the Data Source|
|Variable||Technical name of the variable|
|Value||Value of the member to be filtered|
The alias of the data source must to be the same as shown in workbook. This information you can find in the Display Panel, as shown on the screenshot below: