SAP Knowledge Base Article - Public

3607430 - Hierarchy order is not correct when changing parameter values in SAP Analytics Cloud (SAC)

Symptom

When viewing a story based on a live BW connection that has a hierarchy and query variables, changing the variable values can change the order of the hierarchy - but that order change may not be reflected in SAC.

e.g
View story - set parameters so the hierarchy is organized:

A
A-B
A-B-C

Change Params so the hierarchy is now
A
A-B
A-C

Change Params back to the first values - SAC will still show the hierarchy as
A
A-B
A-C

Environment

  • SAP Analytics Cloud 2025.1.14

Reproducing the Issue

  1. View story with Hierarchy and Parameters
  2. Change Parameter values multiple times when viewing
  3. Hierarchy order becomes incorrect 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

parameter, values, order, organize, hierarchy, sequence, structure, incorrect , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0