Symptom
The following behavior occurs in SAP Analytics Cloud (SAC):
- Tree Map chart doesn't display descriptions longer than 40 characters.
- SAC doesn't use medium texts in Tree Map chart either.
- Objects do not use query setting to use medium texts instead of long texts.
Environment
- SAP Analytics Cloud (Enterprise) 2021.20+
Reproducing the Issue
- Create a story that contains Tree Map chart based on BW live connection.
- Observe that Tree Map chart doesn't display descriptions longer than 40 characters.
- Change the texts to medium in BW query designer settings for affecrected dimension.
- Observe that SAP Analytics Cloud doesn't use medium texts in Tree Map chart .
- No objects uses the query setting to use medium texts instead of long texts.
Observe that other chart type is working fine with long texts, the issue is only for Tree Map chart.
Cause
This is behavior by design.
By default the Tree Map will attempt as a best effort to render a dimension label (if it's enabled under the ... > Show/Hide menu in Edit mode) by wrapping it in the data point that it's available. If it does not fit, it will hide to avoid clutter, with the expectation that user can hover on the data-point to see the Tooltip and dimension label.
Resolution
Options to proceed:
1) Turn off the Dimension Labels: this way the Tree Map will prioritize the data values and you'll have a great likelihood of them showing
2) Truncate the dimension with the long member descriptions: You could use a calculated dimension with the ToText() method to shorten every returned value to a maximum that is most likely to fit. Assuming that you didn't want to modify or cleanse the underlying data to also truncate or reduce it's length.
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,, Issue, Data, User, Unable, Access, Sac, Live, Acquisition, Up, Set, setup, Model, BW, , Story, Tenant, Using, Working, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, Tree map, log text, medium text, chart, dimension, very long , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem