SAP Knowledge Base Article - Public

3658382 - Data Action is executed successfully even some of the data region is locked

Symptom

Prerequisites:

  • You have a Data Action whose "Publish to Target Version after Execution" setting is set to be  “Publish and Ignore warnings”.
  • Data Locking is enabled for the target model.

Behavior:

  1. Case 1: You fully lock the target version for every year and run the Data Action. In this case, you get an error message saying that the Data Action failed since you do not have the rights to change the target version.
  2. Case 2:You lock the year 2024 and open a period like 2025.06 for that version , run the Data Action for a period in 2024. In this case, there is no error message, the Data Action executes successfully.Your expectation might be that the Data Action should succeeds in case 1 the same as in case 2, since it is specified “Publish and Ignore warnings”.
  3. If you change the Publish setting to "Publish and fail if there are warnings", you will get an error for both case 1 and 2. 

Environment

SAP Analytics Cloud 1.0.

Reproducing the Issue

 

Cause

It works as designed.

Whenever data is being changed and eventually published there is a two-step process that takes place:

    1. A “pre-check step” that is validating whether the target version can be changed at all.
      • In case 1 from above, the target version will be detected as “fully locked” and the entire process aborted (the next step, step 2, will not be executed)
    2. The “publish step” with its two options, (i) “Publish and fail if there are warnings” and (ii) “Publish and Ignore warnings”
      • Each data slice modified will be checked against the security layers (e.g. Data Locking, DAC) and approved or rejected for publish.
      • In (i) if at least one slice is rejected, the data action execution finishes with an error.
      • In (ii) the data action is always marked as completed successfully. 
  •  The step (1) and (2) are completely independent and the options of step 2 do not influence step 1.

Resolution

If you prefer a different behavior , please follow the Knowledge Base Article 2424376  to create an Enhancement Request.

Keywords

KBA , LOD-ANA-PL-DLK , Data Locking , Problem

Product

SAP Analytics Cloud 1.0