SAP Knowledge Base Article - Public

3559240 - Incorrect auto-mapping of column headers in import job in SAP Analytics Cloud (SAC)

Symptom

When creating an import job, the table column headers are incorrectly auto-mapped to the model public-dimension headers

 

Environment

SAP ANALYTICS CLOUD 2024.21.11
Connection: import

Reproducing the Issue

  1. Login to SAC.
  2. Open Modeler>Public Dimension.
  3. Switch to 'Data Management' mode.
  4. Import data from file and select 'Use first row as column headers'.

    Notice: Some mappings are done incorrectly, under 'Dimension Mapping'.

Cause

  • This is by design behavior of the product.
  • The automapping feature is designed for convenience and is based on simple inference and the accuracy of the automatic mapping is not always guaranteed

Resolution

Create an enhancement request to request this feature https://influence.sap.com/sap/ino/#/campaign/884 

Workaround:

User can review and correct the mapping as it seems fit.

See Also

Keywords

SAP Analytics Cloud, SAC, Mapping, Dimension, Import job, Public Dimension, Modeler , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement

Product

SAP Analytics Cloud 1.0