SAP Knowledge Base Article - Public

3157497 - Data action produces data outside of the planning area of the target version in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error message occurs in SAP Analytics Cloud for Planning (SAC):

  • The data action ... couldn’t run successfully on version xxx. Step y tries to write data outside of the planning area of the target version.

It happens when the model is enabled with the Optimized Recommended Planning Area option with Based on Data Access Control and Model Privacy and/or Based on Data Locking.

In the data action trigger, the option Use recommended planning area if target version isn't in edit mode is selected.

Environment

  • SAP Analytics Cloud (Enterprise) 2022

Cause

The behavior is as expected. A data action does not care about the data locks. Data is written to all the places defined in the data action definition. If there is no filter on the Date dimension, data is copied to all dates and thus also to locked areas.

Without the planning area, the SAC detects that the data action is writing to locked areas which are not possible according to the data lock settings during the publishing phase and will not allow publishing the changes on the locked areas (a partial publish however is possible that only publishes the parts not being locked).
When the planning area is enabled, the SAC detects that the data action is writing to locked areas which are not possible according to the data lock settings in an earlier phase (when the data action is run). 

The same applies to data access control and model privacy.

Resolution

The customer has to take care that the data action will only write to areas not being locked, e.g. by adding filters on the dimension (also possible using parameters to make it user-specific if needed).

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, DAC, data lock, locks, role-based security, role based security , KBA , LOD-ANA-PL-AF , Advanced Formulas , LOD-ANA-PL-DA , Data Actions , LOD-ANA-PL-DLK , Data Locking , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , LOD-ANA-PL-VER , Version Management , Problem

Product

SAP Analytics Cloud 1.0