SAP Knowledge Base Article - Public

3227385 - SAC AD : The Measure sort applied on table is lost after changing the BW prompt variable


  • When using the ‘Edit member order’ option to set the column/measure order for table in SAC analytic application, the order is not getting retained after changing the BW query prompt values.
  • With the table properties enabled to display the sorts applied, the sort applied on the measures is lost after changing the prompt (Setvariablevalue).
  • When running the application for default values (the variable values the application was saved with), no issue occurs.


  •  SAP Analytics Cloud - Analytics Designer


'Always Paused' and 'Refresh Only Active Widget' options are both related to the data pause refresh feature, one is controlled by script api and another is based on widget active state.
It seems that the custom sorting is lost in 'Always Paused' option + variable change case even with my change, there are some time ordering issue for 'Always Paused'.


The issue will be fixed for the system upgraded to SAC version 2022.8.17.

See Also

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


 Always Paused, Setvariablevalue , KBA , LOD-ANA-AD-INF , Analytics Designer Infrastructure , Problem


SAP Analytics Cloud all versions