SAP Knowledge Base Article - Public

3723137 - Unable to export to excel from query preview - SAP S/4HANA Cloud Public Edition 2602

Symptom

  • Unable to export custom analytical query to Excel.
  • Export button is missing when previewing a query in the "Custom Analytical Queries and Services" application.
  • Export button is missing when previewing a query in the "View Browser" application.
  • Export button is missing when previewing a query from the "Manage KPIs and Reports" application > Multidimensional Reports > Show preview.

Environment

SAP S/4HANA Cloud Public Edition 2602

Reproducing the Issue

  1. Open the "Custom Analytical Queries and Custom CDS Views" application.
  2. Navigate to the query.
  3. Preview the query.
  4. Observe that the export button is missing.

Cause

Key user extensibility applications (such as Custom Analytical Queries and Services, View Browser, and Manage KPIs and Reports) have changed the default preview from Web Dynpro Grid to Multidimensional Analysis report.

The export function has been removed in Multidimensional Analysis (MDA) preview mode due to enhancements in the export feature, including async exporting and support for comments (cell, page).

Resolution

The export functionality remains available in customer-created applications.

Please refer to the SAP Help Documentation under Multidimensional Analysis: Export Data to Spreadsheet and PDF | SAP Help Portal for detailed instructions on the new export features.

        

In the context of Developer Extensibility, Developers can create a new application variant and release a new Multidimensional Analysis app based on the query. For more information, please refer to Generating Multi-Dimensional Analysis Applications | SAP Help Portal 

     

In the context of Key User Extensibility, key users can use the "Manage KPI and Reports" app to create a new Multidimensional Analysis app based on the queries created with the Custom Analytical Queries and Services application. Please refer to the following documentation: How to Create Multidimensional Analysis | SAP Help Portal.

See Also

Multidimensional Analysis: Export Data to Spreadsheet and PDF | What's New in SAP S/4HANA Cloud Public Edition 2602 | SAP Help Portal

How to Preview Multidimensional Analysis | SAP Help Portal

How to Create Multidimensional Analysis | SAP Help Portal

Custom Analytical Queries and Services | SAP Help Portal

Migrating Custom Queries | SAP Help Portal

Generating Multi-Dimensional Analysis Applications | SAP Help Portal

View Browser | What's New in SAP S/4HANA Cloud Public Edition 2508 |SAP Help Portal

Keywords

custom analytical query, export to excel, missing export button, sap s/4hana cloud public edition, schedule release to plant report, custom cds views, multidimensional analysis, manage kpi and reports, async exporting, query designer, export feature enhancements, view browser, multidimensional report, mda , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , CA-GTF-RB , Review Booklet , CA-GTF-VDM-VB , View Browser , BC-SRV-APS-ANA-SSB , SAP Smart Business , BC-SRV-APS-ANA-MDA , Generic Player for Multidimensional Analysis , BC-DWB-DIC-VB , ABAP CDS View Browser , CA-GTF-SB-S4H-DT , SAP Smart Business S4H - Design Time , CA-GTF-VDM-QB , Query Browser , CA-GTF-SB-S4H-RT , SAP Smart Business S4H - Run Time , BC-SRV-APS-ANA-QB , Analytical Query Browser , BC-SRV-APS-ANA-PRV , Analytical Preview UIs for Developer and Key User , Problem

Product

SAP S/4HANA Cloud Public Edition 2602