SAP Knowledge Base Article - Public

3419178 - Dimension hierarchy flattened when exporting a Story to Excel in SAP Analytics Cloud (SAC)

Symptom

  • Hierarchy lost when exporting to Excel.
  • Table Dimension hierarchy flattened when exporting a Story to MS Excel format, in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2023.21.8

Reproducing the Issue

  1. In SAP Analytics Cloud, create a Story.
  2. Insert a Table with at least one Dimension with a hierarchy.
  3. Export the Table to MS Excel format.
  4. In MS Excel, open the generated MS Excel spreadsheet, and notice the hierarchy is flattened.

Cause

Resolution

  • The suggestion is to propose a product enhancement on the SAP Customer Influence.
      
  • For information on how to propose product enhancements for SAP Analytics Cloud, see the SAP Knowledge Base Article:

    2424376 - How do you create an enhancement request for SAP Analytics Cloud?

Keywords

SAC, export, xlsx, xport , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0