SAP Knowledge Base Article - Public

3138134 - Default order of Calendar Month from Live BW appears incorrectly in Explorer Mode View of story in SAP Analytics Cloud (SAC)

Symptom

  • Default order of Calendar Month from Live BW appears incorrectly in Explorer Mode View of story in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2021.20.12

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a new story with table based on Live BW model including [Calendar Month] dimension.
        => In table, dimension [Calendar month] is displayed as ID (Display Options =  Show ID) so sorted by ID from 1 to 12.
  3. Switch to Explorer View Mode.
        => In bottom preview area, dimension [Calendar month] is displayed as ID (Display Options =  Show ID) so sorted by ID too from 1 to 12.
         => In top dimension select area, dimension [Calendar month] is displayed as ID (Display Options =  Show ID) but sorted by Text (from April to September) by default.
  4. Click context menu of dimension [Calendar month] in top dimension select area and then select Sort Z-A.
        => It will be sorted by ID to show from 12 from 1.
  5. Select Sort A-Z again from context menu.
        => It will be sorted by ID to show from 1 to 12.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

AP 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, Explorer, View, sort, order, calendar month, cal month, Live BW, BW query, default , KBA , LOD-ANA-DES-EXP , SAP Analytics Cloud data exploration and explorer views , Problem

Product

SAP Analytics Cloud 1.0