SAP Knowledge Base Article - Public

3780967 - SAC Restricted Measure Fails to Enforce Story Range Filter

Symptom

  • Multiple Conditions are configured for a dimension filter in an SAP Analytics Cloud (SAC) story.
  • The expectation is that all conditions will be applied together and only data matching all criteria will be returned.
  • However, the story displays records that satisfy only one of the configured conditions, resulting in a broader set of results than expected.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Log in to SAP Analytics Cloud.
  2. Open an existing story or create a new story based on a model.
  3. Add a table using a dimension that supports filtering.
  4. Open the dimension filter.
  5. Create multiple Include Conditions for the same dimension.
  6. Save and apply the filter.
  7. Refresh the story or table.
  8. Observe that records matching any of the configured conditions are returned.
  9. Review the results and note that the conditions are evaluated using OR logic, not AND logic.

Expected Result

Only records satisfying all configured conditions are returned.

Actual Result

Records satisfying any of the configured conditions are returned because multiple Story Filter conditions are evaluated using OR logic.

Workaround

Use an Advanced Filter if the requirement is to apply multiple conditions using AND logic and return only records that satisfy all specified criteria.

Cause

This behavior is expected.

When multiple Conditions (Include) are defined within a Story Filter, SAC evaluates them using OR logic. Likewise, multiple Restrictions (Exclude) are also evaluated using OR logic.

This means that a record is returned if it satisfies any one of the configured conditions, rather than all conditions simultaneously.

Example: Condition A OR Condition B.

The filter returns records that satisfy either Condition A or Condition B. Reference: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/8e0d92e4495f4fb488e99181b427037d.html.

Resolution

If the requirement is to return data only when all conditions are met, use an Advanced Filter instead of multiple Story Filter conditions.

Advanced Filters support AND logic, meaning every condition must be satisfied before a record is included in the result set.

Example: Condition A AND Condition B.

See Also

Keywords

SAC, restricted measure, functional area filter, range filter, filter not respected, table shows unexpected values, story refresh, import model, story filter, measure filter issue, visualization filter, data range mismatch, story view, sap analytics cloud story , KBA , LOD-ANA-DES , Story Design & Visualizations , How To

Product

SAP Analytics Cloud 1.0