Symptom
When importing data from SAP Integrated Business Planning it fails with the following error message:
- Couldn't create <Name_Query> job
The HTTP archive (HAR) file contains the information below:
- Response: "status": {
"state": "FAILED",
"details": {
"errorCode": "PLUGIN_ERROR",
"rawError": "Response from external server has status code of 400. Add property UOMTOID to a filter condition in $filter", ... /IBP/CX_BO_EXTR_FILTER_TREE\\\",\\\"message\\\":{\\\"lang\\\":\\\"en\\\",\\\"value\\\":\\\"Add property UOMTOID to a filter condition in $filter\\\"}\\\Add property UOMTOID to a filter condition in $filter...
Environment
SAP Analytics Cloud 2024.8.7
Reproducing the Issue
- Logon to SAP Analytics Cloud
- Create a new model or import job from SAP Integrated Business Planning
- Drag and Drop data to create the query
- Click Next
- Leave the Batch size as it is
- Click Create
- Notice the error message: Couldn't create <Name_Query> job.
Cause
Many IBP key figures rely their calculation in UOM.
Resolution
Add specific UOM conversion to the filter used to bring data from IBP to SAC.
See Also
- 2534015 - IBP - Best Practices on Applying UOM Conversion in IBP for Inventory - SAP for Me
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Analytics Cloud, SAC, Integrated Business Planning IBP, Model, Job, Import, Data, Failure, Query, Couldn't create. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , SCM-IBP-INT-ODT , IBP Master Data and Transactional Data API services , Problem