SAP Knowledge Base Article - Public

3494536 - Members don't appear upon trying to change the variable values in SAP Analytics Cloud (SAC)

Symptom

One user in SAP Analytics Cloud (SAC), can't see the members displayed when trying to change the variable selection.
However, upon directly using the search function, the searched members will be displayed.

Environment

  • SAP Analytics Cloud (Enterprise) 2024.8.16 

Reproducing the Issue

  1. Open story based on BW Live Data Connection.
  2. Try to change the member selection for one of the variables.
  3. Notice the members are not displayed by default, only when using the search function.

Cause

Due to the current design of the Analysis authorizations, BW returns only the distinct Hierarchy nodes and the SAC linked variable scenario fails because of no common nodes between two different queries based on two different Info Providers sharing a common variable.

Resolution

Following workarounds are possible:
1. The linked variable can be set to optional and no need for passing any values to this variable.
2. Disable linking of variables i.e. variable is used independently in the two models based on two different queries on two different Info Providers.

See Also

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

Keywords

sac, variables, members, dimension, disappear, not shown, hidden, missing, hide , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions