SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

  •  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.

Cause

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.

Resolution

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

See Also

Keywords

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

Product

SAP Analytics Cloud 1.0