SAP Knowledge Base Article - Public

2872808 - Sort does not work in Heat Map chart in SAP Analytics Cloud (SAC) story

Symptom

  • Sort does not work in Heat Map chart in SAP Analytics Cloud (SAC) story when a dimension exists on both X and Y axis and there is unbooked/null data.

Environment

  • SAP Analytics Cloud 2019

Reproducing the Issue

  1. Create a story based on sample BestRun sample data model
  2. Create a Heat Map chart with Sale Manager as X-Axis dimension; Location as Y-Axis dimension; Gross Margin as Color
  3. Click the chart > choose Sort > Location > Add Custom Order
  4. For example: edit the location order to Nevada;Oregon;California > Save
  5. Refresh the story > click the chart > Sort > Location > set to use Custom Order defined above; however Custom Order is not applied on the chart

Cause

This is a known limitation with the current version of SAP Analytics Cloud.

Resolution

This issue is fixed when using optimized view mode.

If you are not using optimized view mode, then there is a workound.  If you don't mind treating empty/null as 0, then you can wrap the measure being plotted in the heatmap with a calculation that converts null to 0.

Example:
IF (ISNULL (["ProfitAndLoss":Gross Margin]), 0 , ["ProfitAndLoss":Gross Margin] )

For the workaround to apply - the following conditions must be met:

  • As long as the chart is filtered to stay under 500 data-points, then the sort should be applied. If there are more than 500 points then Top N (AUTO) will kick in and override the sort.
  • Data model referenced in the Heat Map must be an acquired or HANA Live model
  • Heat map must contain values (or null values) for every cell.  A non-existent value will not work.

See Also

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

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, 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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0