SAP Knowledge Base Article - Public

3472749 - 'Except' option in filter is not available as a condition while importing a BW query in the model in SAP Analytics Cloud (SAC)

Symptom

'Except' option in filter is not available while importing a BW query in the model in SAP Analytics Cloud (SAC)

Environment

SAP Analytics Cloud Version: 2024.8.7

Reproducing the Issue

  1. Login to SAC.
  2. Create a new model.
  3. Select the BW Connection.
  4. Select the Query.
  5. Add Measures.
  6. Add Dimensions.
  7. Add dimension in the filter.

Notice that only 'Equal to' as the condition is coming.

Cause

This is by design.

Resolution

'Except' and other conditions like 'Greater Than' and 'Less Than' will only come for the measures and not for the dimension because measure is a metrics and dimensions are members only.

See Also

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a8435da6970041d2beb3299cdcff7026.html

Keywords

except, equal to, measure, dimension, filter, import job, query, model, SAC , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions