SAP Knowledge Base Article - Public

3283080 - Attribute Month of date dimension is ordered alphabetically in SAP Analytics Cloud(SAC)


In a cross table, attribute 'Month' of date dimension is not ordered by actual month order like Jan, Feb, Mar, and etc. But in alphabetical order as Apr, Aug, Dec, and etc.


  •  SAP Analytics Cloud 2022.21.7 (SAC) 

Reproducing the Issue

1. Create a cross table in story.

2. Add the attribute Month of Date dimension as a dimension to the cross table.

3. See the default sorting of Month is in alphabetical order.


Other than the Date dimension itself, for the attribute of Date dimension, system will treat it as normal strings, then sorting is in alphabetical order.


Add Custom Order to dimension Month and rearrange members as expected.

See Also


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, table, design, sorting, dimension, attribute, date, alphabet , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0