- 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.
- SAP Analytics Cloud 2019
Reproducing the Issue
- Create a story based on sample BestRun sample data model
- Create a Heat Map chart with Sale Manager as X-Axis dimension; Location as Y-Axis dimension; Gross Margin as Color
- Click the chart > choose Sort > Location > Add Custom Order
- For example: edit the location order to Nevada;Oregon;California > Save
- 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 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.
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.
- 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 incident for SAP Analytics Cloud?
- 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 , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem