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

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

• SAP Analytics Cloud

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

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

• This issue is fixed when using optimized view mode.
• If you are not using optimized view mode, then there is a workaround by treating empty/null values as 0 and then wrapping the measure being plotted in the heatmap with a calculation that converts nulls 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) applies and overrides the sort.
• The data model referenced in the Heat Map must be an acquired or HANA Live model.
• The heat map chart must contain values (or null values) for every cell. Non-existent values will not work.
• In optimized design mode Heat Maps can now generate a query that is equivalent to a cross tab which should resolve previous issues such as the one outlined in this KBA. See the Heat Map section of the Optimized Story Improvements for Charts here

• SAP Analytics Cloud Community - Stories, Reporting, and Data Exploration Expert page
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

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 , fpa22-15165 , fpa00-15334 , LOD-ANA-DES , Story Design & Visualizations , Problem