Symptom
- When users with a Custom role try execute the import job in SAP Analytics Cloud (SAC), it fails with the following message:
"Import to model ended unexpectedly. Error code: 5021". - Users have all the required permissions in order to perform actions on a model: the general application permission (via role) to Read, Update, Delete, or Maintain analytic or planning models, and they also have the Read, Update, Delete, or Maintain permission granted via the Sharing Settings directly on the model itself.
- The same users have no problem importing data in other models with the same authorizations.
Environment
SAP Analytics Cloud (Enterprise) 2024.2.6
Reproducing the Issue
- Access the model.
- Navigate to Data Management then run the import job manually.
- Failed with error:
"Import to model ended unexpectedly. Error code: 5021".
Cause
This is by Design.
Resolution
- The Maintain permission on Dimensions is needed in order to update dimension members.
- If a user doesn't need to add or update dimension members during data import process, there is an option in the data import job setting to turn off the update of local dimension members.
---> If this option is off, the data import job will succeed even if the user doesn't have permission to dimension.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem