SAP Knowledge Base Article - Public

3193181 - SAP Analytics Cloud (SAC) to BW/4HANA or BW OData Service Export Job Error: "At least one Unit or Currency dimension has invalid mapping"

Symptom

When exporting data from SAP Analytics Cloud (SAC) to BW/4HANA or BW using an OData service connection, the following error occurs during the mapping between the source and target dimensions.

  • At least one Unit or Currency dimension has invalid mapping. Please make sure that these dimensions are mapped to a correct value or dimension, chosen in the measure settings.

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

  • Defect in the dimension mapping logic, which corrupts the target measure and source measure.
  • For example, if you have an SAC measure QUANTITY and a BW InfoObject 0QUANTITY, then in some cases the system will read the SAC measure while it's supposed to read the BW InfoObject.

Resolution

Planned to be fixed with the QRC3 2022 (2022.15) release.

Workaround:

Use a different name for your SAC measure "QUANTITY", such as "QUANTITY_L", even if your SAC measure "QUANTITY" is not used for the export.

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, odata services, measures, 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, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, OData fails. Export job from SAC to BW with OData fails. , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Known Error

Product

SAP Analytics Cloud 1.0