3694951 - the hierarchy expanded state gets lost after changing the variables

the hierarchy expanded state gets lost after changing the variables

SAP Analytics Cloud, add-in for Microsoft Office
can be reproduced in the SAC Data Analyzer for the same scenario

1. Open the workbook attached to the case.
2. Observe that the hierarchies are expanded.
3. Refresh all data in the workbook.
4. Notice that the hierarchies are no longer expanded after the refresh.

BW update needed

Implement the following SAP Notes to resolve the issue:

• SAP Note 3546005: Server-side drill validation.
• SAP Note 3559009: Resolves error with drill groups.
• SAP Note 3607778: Handling missing authorizations.

• Work with hierarchies
• Granting Support Users Access to Live Data
• SAP Note 3546005: Server-side drill validation.
• SAP Note 3559009: Resolves error with drill groups.
• SAP Note 3607778: Handling missing authorizations.

hierarchies collapse, sac add-in, ms excel, refresh issue, hierarchy nodes, expanded state, sac story, sap analytics cloud, hierarchy switch, variable change, sap notes , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem