SAP Knowledge Base Article - Preview

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)

Symptom

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."


Read more...

Environment

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

Product

SAP Analytics Cloud 1.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.