2406057 - Unable to Export Ad Hoc Multi Dataset Reports in Excel with Correctly Named Dataset labels

SAP Knowledge Base Article - Public

2406057 - Unable to Export Ad Hoc Multi Dataset Reports in Excel with Correctly Named Dataset labels

Symptom

When downloading Ad Hoc Multi Dataset Reports to Excel datasets are automatically renamed as “dataset1”, “dataset2” etc, instead of taking the names they have been given.

Environment

  • SAP SuccessFactors HCM Core
  • Ad Hoc Report
  • Analytics & Reporting

Reproducing the Issue

  •  Create a Multi Datset Ad Hoc report giving each individual dataset a name.

       Dataset name.PNG

  • Preview of Multidataset report

Dataset tap preview.png

  • Once this is completed download the output and open it in excel, we can see then see the dataset labels aren’t displaying the correct domain name but instead they are named as “dataset1”, “dataset2” etc

       dataset excel.PNG

Cause

Currently this is expected behavior of the product with Multi Dataset Ad Hoc Reports output in Exel changing to Datasets labels as “dataset1”, “dataset2” etc.

Resolution

  • As a Workaround it is possible to rename these datasets labels in Excel by Right clicking the label ans select "Rename" 
  • Before renaming

       Output in excel.png

  • After renaming

ExcelSheet_Renamed.png

Alternatively You can submit your enhancement request in the Idea Portal at .  https://influence.sap.com/ct/c_ent_homex.bix?level_id=E01EA30D-DF97-462A-9630-A8DB220BC8D1&a=OD5979 for improvements on this feature.

Keywords

Adhoc, Multidatasets, Multi Dataset Export, dataset rename, dataset name , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core 1608