SAP Knowledge Base Article - Public

2586974 - Values Length Restriction in Reports

Symptom

You are looking to display values in a report, but you notice that this report restricts these values up to 60 characters, however, your business requirement is to display the whole value or text in the report.

Environment

  • SAP Hybris Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

In order to reproduce this limitation, kindly follow the step by step below:

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Search and open the report that you would like to use.
  4. Run the report.
  5. Notice that the text values which are displayed in the report, even if they have more than 60 characters, are restricted to display only 60 characters in the report face.

Cause

This is currently the standard system behavior, since reports are mainly created with this limitation to ensure that there won't be performance or design issues on the report face.

Resolution

Even though this is a standard limitation of the system, when accessing your system using the HTML5 UI, you have the possibility of extending the text values of characteristics in the report, where the system defines a new limit of 1024 characters for each text value displayed in the report face. To activate this functionality, kindly follow the step by step below:

  1. Go to the Business Analytics work center.
  2. Go to Design Reports view.
  3. Search and open the report you want to display more than 60 characters per text value.
  4. Run the report.
  5. In C4C, click on Show More button, which is displayed as a wheel on the top right menu of the report. In ByDesign, click on the Configure button in the top right corner.
  6. Hover the mouse cursor to the Show Extended Text option and click on Enable.
  7. A warning message may be raised, asking if you want to proceed, select Yes.
  8. The report will close, then you have to open it again and run the report one more time.
  9. If you try to extend the characteristic box, you will notice that it displays now more than 60 characters per text value if required.

Please note that there is the limitation for 1024 characters which can be displayed in the report, since it can cause performance and design issues within the report if more characters were allowed. The displayed characters are restricted by the column width and you have the option to extend the width. The report will display the characters until a certain length and after that you will see ... but if you hover over with the mouse, you will see the full characters (Internet Explorer and Google Chrome).

Also, notice that if this setting is done from Business Analytics work center, it will be applicable for all users. If the end user performs this by opening the report from the Analysis work center, it will be a personalization.

See Also

If you add a variable to the selection which has values with more than 60 characters, you will not be able to select such a variable. The report will return the message 'Value ABC is not valid for variable XYZ'. However, if you extend the number of characters to 1024, the system will allow you to select such values for the selection.

Keywords

Lenght; Limit; Characters; Report; Analytics; Limitation; Extended; Text; C4C; ByDesign, 60 characters, value is not valid for variable , KBA , byd , c4c , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions