Symptom
In an SAC table, the property of a dimension is set as one of the row/column axes.
The custom order is applied on this property in the table. However, the order of the table is not updated according to the custom order.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Open an SAC story that contains a table.
- Right click the property header.
- Sort Options -> Add Custom Order ...
- Adjust the order and click OK in the Edit Member Order panel.
- The order in the table is not updated according to the custom order.
Cause
The property where the custom order is applied to is in the row/column axis. The dimension which this property belongs to is in the other axis (column/row).
Because of the strong dependency between the property and the dimensions, it is impossible to sort one without the other. They can only be sorted if they are on the same table axis (both in the column axis or both in the row axis).
Resolution
Set the dimension and property in the same table axis (both in the column axis or both in the row axis).
Please note: If the dimension has a hierarchy, depending on the axis, the property needs to be on the left or above the dimension for the custom order to be considered.
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, attribute , KBA , LOD-ANA-TAB , Table , Problem