SAP Knowledge Base Article - Public

3578620 - Export XLSX File from Story 2.0 on View Mode Scope All does not include all the data - SAP Analytics Cloud

Symptom

- Experiencing an issue with the Export function on tables within a Unified Story in SAP Analytics Cloud.

- The problem arises when using a BW Live query with a hierarchical structure.

- In "View" Mode, when "All" is selected under Scope, not all nodes are exported, just Parent Nodes.

Environment

SAP Analytics Cloud Version -> 2025.1.6

Reproducing the Issue

  1. From SAP Analytics Cloud page open the Affected Story.

  2. Change to "View" Mode.

  3. Click on the three Dots on the Table (Right top Corner) > Export:
    1. File Type: XLSX
    2. Scope: ALL
    3. Click > OK

  4. Open the XLSX File and notice that just the Parent nodes got exported.

Cause

Problem detect on SAP Analytics Cloud Table Export functionality.

Resolution

Fixed on QRC1 2025.

Workaround: In Edit Mode the same behavior is not faced, and it export all the nodes.

See Also

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

Keywords

SAP Analytics Cloud, SAC, SAP, Analytics, Cloud, kba, note, help, knowledge, chart, story, canvas, responsive, model, modeling, connection, tenant, version, View, Mode, All, selected, Scope, Export, XLSX, XLS, CSV, Data, Missing, fields, included, live, bw , KBA , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Problem

Product

SAP Analytics Cloud 1.0