SAP Knowledge Base Article - Public

3559151 - Restricted Measure created in a Story based on an SAP BW Live connection does not work in SAP Analytics Cloud (SAC)

Symptom

  • Restricted Measure does not work.
  • Restricted Measure created in SAP Analytics Cloud does not filter the data based on the selected hierarchical node value.

Environment

  • SAP Analytics Clouds 2024.21.11

Reproducing the Issue

  1. In SAP Analytics Cloud, create a SAP BW Live Connection.
  2. Create a Model based on an SAP BW Query containing Dimensions with a hierarchy.
  3. Create a Story, and add a Table based on the Model created in step 2.
  4. On the Table, under Dimensions, create a Restricted Measure.
  5. Set the value of the Restricted Measure based on a Hierarchy node value.
  6. When viewing the Story, notice the Restricted Measure does not filter on the hierarchy node value selected.

Cause

Resolution

Keywords

SAC, Restricted Measure , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0