3504028 - 'Submit variables failed' error in a story with live data connection - SAP Analytics Cloud

After setting variables in the SAC Story and submitting them, a set of errors occurs:

--------------------------------------
Submit variables failed...

Server Error: Error [Server]: Unable to initialize query
Error [Server]: Variables exist - enter values and submit -  

Failed to execute firefly query: Value 'XXXX' for variable Receiving Profit Center is invalid - Error: Value 'XXXX' for variable Receiving Profit Center is invalid at Object.onVariableProcessorExecuted
--------------------------------------

On the backend, CX_RSR_BAD_VALUE_COMBINATION exception is thrown in method _DISTINCT_BLOCK_CHECK (class CL_RSR_VAR).

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Read more...

• SAP Analytics Cloud
  
  
• SAP NetWeaver 7.5 up to SP30
• SAP NetWeaver 7.51 up to SP19
• SAP NetWeaver 7.52 up to SP15
• SAP NetWeaver 7.53 up to SP13
• SAP NetWeaver 7.54 up to SP11
• SAP NetWeaver 7.55 up to SP9
• SAP NetWeaver 7.56 up to SP7
• SAP NetWeaver 7.57 up to SP4
• SAP NetWeaver 7.58 up to SP2
• SAP BW/4HANA 2.0 up to SP17
• SAP BW/4HANA 3.0 (2021) up to SP10
• SAP BW/4HANA 4.0 (2023) up to SP2

SAP Analytics Cloud 1.0 ; SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA 2025

CX_RSR_BAD_VALUE_COMBINATION, _DISTINCT_BLOCK_CHECK, CL_RSR_VAR, Submit variables failed, Server Error, Unable to initialize query, Variables exist - enter values and submit, Failed to execute firefly query, Value, for variable, is invalid, Object.onVariableProcessorExecuted, error after variable submit , KBA , BW-BEX-OT-OLAP-VAR , Using Variables , BW-BEX-OT-BICS-INA , BW INA provider , Problem