SAP Knowledge Base Article - Public

3483212 - An extra field shows up in SAC but that field does not exist when previewing the Analytic Model in Datasphere

Symptom

  • An extra field shows up in SAP Analytics Cloud (SAC) but that field does not show up when previewing the Analytic Model in Datasphere
  • "The query is inconsistent : Following compound key column(s): '[ID of the field]' must be defined either in Dimensions or in Filter in order to make a consistent." error shows after adding that field in the story

Environment

  • SAP Analytics Cloud 2024.8
  • SAP Datasphere

Reproducing the Issue

  1. Logon to SAC
  2. Create a new ODE story with the problem Datasphere model
  3. In Builder Panel
  4. Notice that the an extra dimension "<Field name>" is available
  5. Select that dimension field and a measure. Could see below error shows in har trace

    ----
    {
        "Messages": [
            {
                "Type": 2,
                "Number": 42764,
                "Text": "The query is inconsistent : Following compound key column(s): '[ID of the field]' must be defined either in Dimensions or in Filter in order to make a consistent."
            }
        ]
    }
    ----
  6. Logon to  Datasphere, and open the Analytic Model that used in step2
  7. Preview the model, that field does not exist 

Cause

  • In Datasphere, that field is indeed defined as an exposed dimension, however, it's hidden in Datasphere due to it being one of the key attributes of a compounded dimension.
  • The behavior in SAC is a product limitation.
  • In SAC, several workflows do not correctly handle dimensions with compound keys defined in SAP Datasphere and they are not blocked:
    •  Key columns are exposed as navigational attributes in Stories even though they should not be.
      • When key columns are used in queries it may result in "query inconsistent" errors like the one shown here.
    • Datasphere compound keys only support exact matches ("=" comparisons), and as a consequence:
      • Searching on a partial key value may fail with a server error.
      • Any exclude filters defined on compound dimension keys will cause a query to fail.
      • Range/Condition filtering is not supported on a compound dimension key and will cause a query to fail.
    • Datasphere compound dimension keys cannot be used in certain advanced features:
      • Calculated Dimensions
      • Certain Filtering Across Models (FAM) workflows
      • Histogram charts

Resolution

An upcoming feature enhancement is planned for the 2024 Q3 QRC release. The enhancement should:

  • Update query generation to enable supportable workflows
  • Block unsupported workflows

Keywords

DWC, inconsistant, wrong, unexpected, er, missing function, display, design , KBA , LOD-ANA-DES-SMQ , SAP Analytics Cloud Story Metadata and Queries , DS-MD-AM , Analytic Model , Problem

Product

SAP Analytics Cloud 1.0 ; SAP Datasphere 1.0