SAP Knowledge Base Article - Public

3562989 - Selected members in the old hierarchy get unselected (SAC table) when updating data in Datasphere

Symptom

 Data hierarchies are not updating correctly when creating a measure or calculation in SAP Analytics Cloud.

 

Environment

SAP Analytics Cloud Enterprise 2024.21.11

Reproducing the Issue

  1. Log into SAC Tenant
  2. Open the affected story based on a Datasphere Live Connection: xxx
  3. Add a restricted measure named "A":xx
  4. Add Dimension: B, select member: C, D, E, F, G, H.
  5. Go to Datasphere Tenant and change the hierarchy to another one.
  6. Go back to SAC, notice the selected members in the old hierarchy get unselected. 

 

Cause

 

This is by design. Manual updates are required after each backend change. The SAC won't recognize new updates automatically, as it's expecting the previous values. When you update the hierarchy, such as adding a new member to an existing node, the SAC won't acknowledge it until it's been manually updated. 

Resolution

Same resolution of the KBA: 2789695 - Considerations when changing backend data models used in SAP Analytics Cloud (SAC) - SAP for Me

"It can occur that affected visualizations of a dashboard or even the whole story/application need to be re-created to resolve the errors."

See Also

Keywords

SAC, hierarchy, Analytics, members, dimensions, restricted measure, live, Datasphere, unselected, bug , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0