SAP Knowledge Base Article - Public

3221814 - Table Columns not sorted in Time order when the Totals columns is sorted in Ascending, or Descending order in SAP Analytics Cloud (SAC)

Symptom

  • Table Columns sorted in the incorrect order.
  • Table based on an SAP BW Query, the Time Dimension like "Calendar Year / Month" shows in incorrect Time order, when the Totals columns is sorted in Descending, or Ascending order, in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.8.10

Reproducing the Issue

  1. In SAP Analytics Cloud, create an SAP BW Live Connection to a BW Query with Time Dimension, like: Calendar Year / Month.
  2. Create a Story, and add a Table.
  3. Add a Dimension for the Rows.
  4. Add a Measures and a Time Dimension for the Columns, like: Calendar Year / Month.
  5. Sort the Totals column of the Table in Descending, or Ascending order.
    The Time Dimension columns displays in incorrect Time order on the Table.

Cause

  • This issue is currently under investigation by development.

Resolution

  • This issue is currently under investigation by development.

See Also

Keywords

SAC , KBA , LOD-ANA-TAB , Table , Bug Filed

Product

SAP Analytics Cloud 1.0