SAP Knowledge Base Article - Public

3523565 - It is possible to export more than 60 measure columns to CSV file in table of SAC story

Symptom

It is possible to export more than 60 measure columns to CSV file in table of SAC story

Environment

  • SAP Analytics Cloud 2024.15.13

Reproducing the Issue

  1. Login to SAC system.
  2. Open one story with table including more than 60 measure columns
  3. Export to CSV file selecting All scope.
  4. It is possible to export the CSV file.
  5. If the measure column is more than 300, then get error that it is not possible to export since reached the maximum measure column (300)

Resolution

  • The maximum limit for exporting CSV is 60 columns and 3 million cells.
  • The feature has been increased to 300 columns in 2024.QRC3 (2024.14), so if exporting the CSV with more than 60 columns, but less than 300 columns , there is no error and exporting is possible. But it is not recommended to exporting with more than 60 columns officially.

Keywords

export, SAC, table, CSV, all, scope, 300, limit, measure, column, columns, excel, 300, max, maximum, story , KBA , LOD-ANA-UNS-DSG , Unified Story Designer Issues , Problem

Product

SAP Analytics Cloud 1.0