SAP Knowledge Base Article - Public

3583538 - Data Actions need to be validated and re-saved when a new measure is added in the model

Symptom

  • Data Actions are deactivated and need validation when a new measure is added in the model.
  • Data Actions generate the error “The Measures have been updated in the model since the last update of this data action”.
  • The error occurs in the data actions in which no MEMBERSET for measure or no measure in Calculation. 
  • The error is generated if the data action has measure restricted.

Environment

  • SAP Analytics Cloud(Enterprise) 

Reproducing the Issue

  1. Add Measures in the model.
  2. Observe that existing Data Actions where no restrictions for the measure are specified get deactivated and need to be validated and saved. 

Cause

The data action script is compiled according to the HANA stored procedure when saving the data action. When no restrictions for measure or no measure in Calculation are specified, a HANA stored procedure with All measures as the calculation scope is created. After adding a new measure, the new measure should be added to the calculation scope where set to "ALL" scope for Measures. Therefore the data action throws an error and needs to be re-saved to include the "New measure" in the calculation scope of the HANA stored procedure.

Resolution

It is the expected behavior. When a new measure is added in the model, validate and re-save the data actions in which no measures are restricted. 

See Also

Keywords

SAP Analytics Cloud, Data Actions, Measure Change, Deactivation Issue, HANA stored procedure, Calculation scope, Measure restriction. , KBA , LOD-ANA-PL-DA , Data Actions , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud all versions