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 HCM Suite
Reproducing the Issue
- Create a Multi Datset Ad Hoc report giving each individual dataset a name.
- Preview of Multidataset report
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
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"
- Before renaming
- After renaming
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.
Adhoc, Multidatasets, Multi Dataset Export, dataset rename, dataset name , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem