When you try to upload the XML file which contains Extension Fields or a custom report via Key User Analytic tool, you might get an error.
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics Work Center.
- Go to the View Common Tasks.
- Go to subview Upload/Download.
- Go to the Upload tab.
- Click Upload Object.
- Select the XML file.
- After saving it, one of the following error messages appear: 'Unexpected Error' or 'Data type of data source field XYZ is not available' (XYZ represents the data type name).
This import error is due to the content incompatibility in your XML model file. The template file contains customer or partner created Extension fields, which are not supported by the standard Key User Analytics tool.
Upload is failing as the referenced extension fields (Partner/KUA) present in source system are not present in target system. Export and Import Layout feature is not supported in SAP Business ByDesign. Only PDI fields can be transferred to any other tenant by deploying the solution, while KUT created fields cannot be exported.
The PDI solution download/upload should be done from source system to target system first via PDI studio. After that, KUA report/data source upload to target system should work fine.
In order to figure out if there is one or more extension field in the content for the customer file model, it is necessary to open the XML code and seek the following term:
For further details also refer to the SAP Business ByDesign documentation available in the Help Center by searching the term: Upload and Download an Object
Report Upload; Upload Error; Upload Failed; Upload issue; Extension Field; Data Type , KBA , data type not available , data type error , xml upload , report data type , extension field , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-RC-UIF , C4C UI Framework , How To