SAP Knowledge Base Article - Public

3190726 - Story Filter Hierarchy Nodes Grayed Out when selecting values in another Story Filter in SAP Analytics Cloud (SAC)


  • Hierarchy Nodes that have no data are grayed out.
  • Story Filter showing all the values, instead of only the values that have data.
  • In SAP Analytics Cloud with multiple Page Filters, using the Cascading Effect, does not filter the values out in the other Page Filter. When the Page Filter is based on a Dimension with a Hierarchy, it instead show all the values, with some of the values grayed out.
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP Analytics Cloud

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
  2. Add one Page Filter based on a Dimension.
  3. Add a second Page Filter based on a Dimension with a Hierarchy.
  4. Viewing the Story, and select a value for the first Page Filter.
  5. When selecting the second Page Filter based on a Dimension with a Hierarchy, notice it is showing a couple of gray nodes.
    Those nodes does not have values associated with it, and therefore cannot be selected.

      Cascading Effect - 01.png

    The expectation is to only see the nodes that have relevant values, and not seeing any grayed out nodes.


  • By design, Page Filter based on a Dimension with a Hierarchy will show the nodes that have no values as grayed out, when the option "Cascading Effect" is checked for the Page Filter. 
  • Since there is no data for those values, it is grayed out to avoid selecting those values in the hierarchy, and returning no data in the Story.


  • To show the relevant values only, set the Page Filter to not use a Hierarchy, by setting the Dimension Hierarchy to use a Flat presentation.
    1. In SAP Analytics Cloud, open your Story.
    2. In the toolbar, click on "Edit" ( Located on the upper right corner )
    3. Click on the Page Filter based on the Dimension using a Hierarchy, and select "Edit Filter..."
    4. In the window "Set Filters for ... ", under "Available Members", click on the down arrow to show more options.

      Cascading Effect - 03.png
    5. For the option "Show Hierarchy", select: "Flat presentation"

      Cascading Effect - 02.png
    6. Check the option "All Members"
    7. Click "OK"
    8. Save your Story. 

See Also


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


SAP Analytics Cloud 1.0