SAP Knowledge Base Article - Public

3391824 - Leading spaces removed for columns data in a Table, on a Story, in SAP Analytics Cloud (SAC)

Symptom

  • Missing data leading spaces.
  • Table widget removes data leading spaces on a Story in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2023.16.4

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
      
  2. Insert a Table, based on a Model that contains data with leading spaces.
      
  3. Insert at least one Diemsion in the Table Rows, that contains data with leading spaces, or
    create a Calculated Dimension that add leading spaces to the data like:

          IF([<Dimension A>]="Value 1","Value 1" ,
          IF([<Dimension A>]="Value 2","       Value 2" ,
          IF([<Dimension A>]="Value 3","       Value 3" , [<Dimension A>])))

  1. When viewing the Table, notice the leading spaces are removed.

    For example, if we have the following data:

         Value 1 
               Value 2 
               Value 3

         The second row, and third row should have 5 leading spaces,
         but the leading spaces are removed, and show on the Table like:

         Value 1 
         Value 2 
         Value 3

Cause

  • By design, Table widget removes leading spaces.

Resolution

  • Workaround: Use an invisible unicode character like (U+200C)

See Also

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

Keywords

SAC, SAP Analytic Cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0