SAP Knowledge Base Article - Public

3597606 - Transformation Changes Overwritten After Scheduled Refresh Job in SAP Analytics Cloud

Symptom

  • The transformation of data in the Data Model is overwritten after each scheduled refresh job.
  • The issue persists even when the job is manually refreshed.
  • Error message: "There are mapping restrictions that need to be fixed."

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Create a model off SAP BW (Import) or any other DB
  2. After the data is imported, create a new Transformation/Calculated dimension column which concatenates 2 columns
  3. Save the Model
  4. Re-import the Job
  5. Error, "There are mapping restrictions that need to be fixed" is displayed

Cause

This is by design

Resolution

Transformations done in the modeler are independent from transformations done in the Import Job. So, if you'd like to keep the transformation, then do it in the import job, rather than in the model. 

See Also

Keywords

SAP Analytics Cloud, Data Model, Transformation, Overwritten, Scheduled Refresh Job, Import Data Connections, SAP BW, Mapping Restrictions. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions