SAP Knowledge Base Article - Public

3071804 - “Failed to upsert dimension members in dimension” when you import data from BPC to SAP Analytics Cloud for Planning (SAC)

Symptom

When you try to import data from BPC (Business Planning and Consolidation) to SAP Analytics Cloud for Planning (SAC), you receive the following error:

  • Failed to upsert dimension members in dimension <SAC currency dimension>

Environment

  • SAP Analytics Cloud (Enterprise) 2020.7.7

Cause

Dimension <SAC currency dimension> has enabled currency, the property is Currency.
In Mapping, the BPC dimension which is mapped to this <SAC currency dimension> is not right: in this BPC dimension, there is no proper attribute that can map to the Currency property.

Resolution

Modify the structure of the BPC dimension or choose "Not mapped" for dimension <SAC currency dimension>.

See Also

Your feedback is important to help us improve our knowledge base.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, import job, currency conversion , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem

Product

SAP Analytics Cloud 1.0