SAP Knowledge Base Article - Public

2810005 - Importing data to a model which has Currency Conversion enabled will fail with error: Attribute "Currency" must be mapped

Symptom

  • The model has one dimension with Enable Currency properties checked on.
  • In Model Preferences -> Currency -> Currency Conversion is also checked on and the dimension is used as Currency dimension.
  • When do the data import to the model, after editing the data mapping and click Finish Mapping button. An error dialog comes with information below, and the Finish button in this dialog is disabled so user cannot complete the data mapping.

    The following issues will be dropped during import:
    Attribute "Currency" must be mapped

 

Environment

  • SAP Analytics Cloud 2019.12.1

Reproducing the Issue

  1. Create a new model with EXCEL data. The EXCEL data should contains one column data with Currency. (JPY, USD, CNY, etc)
  2. Open the model, and edit for the dimension of the Currency column, check on option Enable Currency
  3. Go to Model Preferences -> Currency, check on Currency Conversion. And choose the dimension in Step 2 as Currency dimension.
  4. Save this Model.
  5. Go to Data Management and import the same EXCEL data again.
  6. Click the imported one from Draft Sources to go to the data mapping page.
  7. Click Finish Mapping button.
  8. Notice error comes as: The following issues will be dropped during import: Attribute "Currency" must be mapped

Cause

This is because, when a dimension has Enable Currency checked,  the dimension will have a Currency attribute assigned. When Currency Conversion is enabled in Model Preferences and the dimension is used as Currency dimension, the Currency attribute value will be used and checked. In the original EXCEL data, there is no column which is mapped to this new Currency attribute. That is why such information is displayed to ask for mapping to Attribute Currency.

Resolution

  1. In the data mapping page, duplicate the column data with Currency to generate a new column for the Draft sources.
  2. Double click the Currency dimension to find the Currency attribute.
  3. Drag & drop the duplicated column into the Currency attribute to do the mapping.
  4. Click Finish Mapping button and confirm the mapping will be successful.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0