3626558 - Default sort order of filter and table/chart is different in SAP Analytics Cloud (SAC)

Symptom

Dimension member sort order is different in the Input Control/Story filter vs the Table/Chart in SAC.
Sort of Input Control is alphabetical order in ID, however sort of table is defined in BW query.
Note: same behavior in widget filter editor.

Environment

SAP Analytics Cloud 2025.8.13
SAP BW/4HANA 2023

Reproducing the Issue

Login to SAC.
Create a story based on live data connection to BW.
Insert a chart/table and add a dimension.
Insert a filter (input control or story filter) based on the same dimension => Sort of input control/story filter is alphabetical order in ID, however sort of table is defined in BW query.

Cause

By design behavior.
On client, each filter and chart/table can have own sort order, so:
- If the filter in the story is set to ascending, sortDirection in the query will be ascending and the LOV will be sorted ascendingly. Note this setting won't affect any chart or table.
- If the filter doesn't specify sort, we use sortDirection=None in the query for LOV, and the order is determined by the three rules from the backend team:
  - if there's a selection defined → sort by selection
  - if there's a hierarchy set → sort by hierarchy
  - if there's no selection defined → sort ascending using to first presentation (e.g. DISPLAY_KEY).
- If the chart/table doesn't specify sort order, the resultset query doesn't contain any Sort section, not even sortDirection=None. And this would returned original sort order defined in BW query, and can be inconsistent with the filter LOV query.

Resolution

Workaround: in the filter go to Sort - Add Customer Order => the proposed default customer order is exactly same as sort of the table / chart. Apply.
Please, open an enhancement request for the topic per KBA 2424376 - How to create an enhancement request for SAP Analytics Cloud?

This document and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.

This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem

Product

SAP Analytics Cloud all versions