SAP Knowledge Base Article - Public

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


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.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP Successfactors Workforce Analytics

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


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


As a Workaround it is possible to rename these datasets labels in Excel by Right clicking the label and select "Rename" . Below screenshot is the view before renaming

       Output in excel.png

Below screenshot is the view after renaming


If you would like to see this feature introduced, please check if there is already a Customer Influence request on the Influence portal that you can add your vote to, or create a new enhancement request for this feature:


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


SAP SuccessFactors HCM suite all versions