SAP Knowledge Base Article - Public

3316092 - The full value of a data cell is not displayed although Adaptive Column Width is enabled in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • Adaptive Column Width is enabled in the table designer.
  • However, for some cell with large numbers, the value is not fully displayed. For example, the full value is 123456789.1234. The displayed value is 123...
  • This issue is related to the screen size. For example, if you use a big monitor, the values are fully displayed; If you use a laptop, the values are not completely shown.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Open a story with Adaptive Column Width ticked.
  2. Check the values in table cells.

Cause

This is the currently designed behavior: the initial width of the column is calculated by looking at a sub-set of all texts in a column. During scrolling we currently keep the column widths to avoid the table layout from being changed, even if there are some texts that will be cut off. 

The table shall not change column width during vertical scrolling. In current design only the upper part of the table is taken into account to adapt the column width. When scrolling down more space may be needed to show the full cell content.

Resolution

The development team decided to work on improving this behavior. However, that will require more work and we cannot provide a timeline at this point.

At the moment, what you can do as a workaround is:

  • hover the mouse over the cell where the text is cut-off and you will get a tooltip with the full text
  • de-select Adaptive Column Width and manually resize the first column to fit the longest text. This will ensure that the first column stays at this size, and other columns will keep the "adaptive" behavior as well (unless they are resized).

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, 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, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, truncated, hidden, cut, part, partially , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0