SAP Knowledge Base Article - Public

3420785 - The measure order in the table does not follow the order set in the measure filter in SAP Analytics Cloud (SAC)

Symptom

In the past, the order of the measure follows the sequence of selecting the measures in the filter.

Now, the sequence to select the measures in the filter does not matter anymore. 

For example, in the measure filter, the selected measure is in order M2, M1, M3.

However, in the table row, the order of the measure is always M1, M2, M3.

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

The Measure sort order is not guaranteed to be the same as the order in the filter. The SAC backend returns the members without considering the filter order. 

There has been no changes regarding the sorting function recently. The fact that it was resulting as the users expected in the past was a coincidence but it could happen as it happens now that the members from backend will be returned with a different order.

Resolution

In order to make sure that the order is maintained, please set a custom order as per Changing Member Order

If you want the feature to consider the filter order when sorting the measures in the table, this can be seen as a new feature enhancement request. Please create an enhancement request as per KBA 2424376

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, sorting, sorted, sort, customized , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud all versions