SAP Knowledge Base Article - Public

3544581 - String type dimension from data source failed to map to date type dimension in the model with "May by ID" in SAP Analytics Cloud (SAC)

Symptom

  • There's one string type dimension from the data source.
  • Map it to existing model and the target dimension is Date type, map it via "Map By ID"
  • Mapping failed with:
    Import to model ended unexpectedly. Error code: 1020

Environment

SAP Analytics Cloud (Enterprise) 2024.21.8

Reproducing the Issue

  1. Logon to SAC tenant and open an imported model.
  2. Create a new draft file and start mapping.
  3. Find the string type dimension in datasource and map it to the date type dimension in the model.
  4. Select May By ID during the mapping.
  5. Data mapping failed with error:
    Import to model ended unexpectedly. Error code: 1020

Cause

This issue is judged as a system bug.

Resolution

This issue is fixed after 8th Jan 2025.

See Also

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

Keywords

Year, Month, Fiscal, bug, failed, cannot, map by date , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0