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
- Optimize Planning Models Using the Planning Area https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b7958a0bfceb426c8ac486863ec59abc.html
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