3542214 - "Query can't be executed without setting values for all mandatory variables" even if the variables have already been set (SAC BW Live Connection)

On an SAP Analytics Cloud story which contains a BW Live model, upon trying to navigate on the model by adding or removing dimensions from rows/columns SAC gives the following message.

"Query can't be executed without setting values for all mandatory variables".

The query from the BW Live model has mandatory parameters, however, they have already been set by the user.

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

• SAP Analytics Cloud
• SAP Business Warehouse
• SAP BW4/HANA
• SAP Netweaver

1. Open an Existing SAC story or create a new one with a BW Live model.
2. Set mandatory variables.
3. Open designer tab and try to add dimensions on rows or columns.
4. Confirm the error.

CORS misconfiguration on backend system.

Missing headers sap-rewrite-url and sap-url-session-id.

On transaction UCONCOCKPIT > HTTP Allowlist Scenario > Cross-origin Resource Sharing > /sap/bw/ina/ make sure the following headers are set:

Allowed Headers:
    x-csrf-token
    x-sap-cid
    authorization
    mysapsso2
    x-request-with
    sap-rewriteurl
    sap-url-session-id
    content-type
    accept-language

Exposed Headers:
    x-csrf-token
    sap-rewriteurl
    sap-url-session-id
    sap-perf-fesrec
    sap-system

SAP Help: Live Data Connection to SAP BW Using a Direct CORS Connection via Unified Connectivity

prompt, parameter, cors, query, story, live data, ina, cloud analytics, sapanalyticscloud, optimized story experience (OSE) optimized design experience ODE Unified story BW live connection InA: Persisted InA support attribute metadata  , KBA , BW-BEX-OT-BICS-INA , BW INA provider , Problem