Symptom
The SAC story on live 'BW' query fails to load data with the following message in the widget, "Unable to retrieve data from the data source". A pop-up error message "Submit variables failed" is displayed. When the prompt is opened and the values are input, and click the "Set" button, a new pop-up error message "A Server error has occurred, and the values cannot be processed" is displayed. The same BW query works fine in the'Data Analyzer, 'Analysis for Office', and 'RSRT' with the same variable prompt values.
Environment
SAP Analytics Cloud
Reproducing the Issue
Run the story.
Cause
Program error.
Resolution
Implement SAP Note 3446357 - Recursive query generation having parameter BICS_VAR_VALIDATE_ALWAYS enabled.
Keywords
prompt not work, variable error , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-OLAP-VAR , Using Variables , LOD-ANA-DES , Story Design & Visualizations , Problem