SAP Knowledge Base Article - Public

3545623 - When creating a filter on a hierarchal dimension the option Exclude selected members is missing in SAP Analytics Cloud (SAC)

Symptom

  • In SAP Analytics Cloud (SAC) creating a filter on a hierarchal dimension the option Exclude selected members is missing in the Set Filters pop-up window
  • This option is still there for non-hierarchal dimensions

 

Environment

  • SAP Analytics Cloud (SAC) 2026.08
  • Business Warehouse

Reproducing the Issue

  1. Create a Story off BW live Connection.
  2. In that story create a filter on a hierarchal dimension.
  3. Try to use option "Exclude Selected Members"

Cause

This is a product limitation

Resolution

In SAP BW, you can't exclude members in a hierarchical presentation as mentioned in User Guide

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/bb580dbd86a84c7694cc56e5155d4fb5/c1c8fbf79de94c32be90466872c13b13.html?locale=en-US&version=2025.8Q#including-and-excluding-members-in-the-filter

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0