Symptom
Using upload jobs to load the data into system.
During mapping, the pivoting settings are based on a specific period range and transforming the period from columns to rows using "unpivot" transpose function.
For the upload file that is used during transformation it's working as expected but when changing the periods and using the upload data button to upload file data again, a mapping error appears:
"The upload job has failed because data upload has failed. Please go to the corresponding data management page to view the details".
Environment
SAP Analytics Cloud 1.0
Reproducing the Issue
- Open story
- Choose an excel file containing periods as column headers
- Run the upload and notice that it is successful
- Change periods in the file and try to upload it once again
- The following error message appears: "The upload job has failed because data upload has failed. Please go to the corresponding data management page to view the details".
Cause
Expected behavior.
The pivoting settings are based on a specific period range, any attempt to upload a file with a different pivot column range will automatically fail.
Resolution
A separate upload job must be configured.
See Also
Keywords
KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem