SAP Knowledge Base Article - Public

3487176 - Error "Submit variables failed" when opening a SAC story

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

Product

SAP Analytics Cloud 1.0