SAP Knowledge Base Article - Public

2996671 - SAC Disaggregation on non-accessible members - LOD-ANA-PL

Symptom

When entering a value on a node of a hierarchy, the value is distributed also to members which are out of Data Access Control.

For example, a value entered into an empty cell is booked to the unassigned member (#) of a dimension that is not on the table axis and not restricted by a filter, even though the user is only allowed to read and write to specific members of the dimension (that do not include the unassigned member). This may be noticed only later, when the user tries to publish the changes to the version. It may also be observed when putting the dimension in question on the table axis or looking at the members offered by filter controls.

Environment

SAP Analytics Cloud, all versions

Reproducing the Issue

Perform a data entry on a node in a hierarchy for a model that has Data Access Control enabled and that has leaves for which the user does not have write access.

Cause

The behavior has been enhanced as of Q3.2025.

Resolution

With the Q3.2025 release, in the Planning tab of the Model Preferences, there is a Data Disaggregation section to let you decide whether to disaggregate the data based on Data Locking, Validation Rules or/and Data Access Control.

Note:

  • Currently, the data disaggregation only supports the Data Access Control on dimensions and does not suport the Model Data Privacy (role based security). 
    If you would like the Model Data Privacy to be also supported, please create an enhancement request as per KBA 2424376 and follow up with the product owner team about this enhancement request on the SAP Customer Influence Site https://influence.sap.com/sap/ino/#/campaign/884. 
  • This solution is effective in the new table (UQM table) and not the old table.

See Also

Your feedback is important to help us improve our knowledge base.

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 , distribute , distribution , mbr , value , amount , data , DAC , dim , dimension member , data access , data access control , bookmarks , dimension-based DAC , role , dimension-based data access control , READ and WRITE, READ , WRITE , cell, validation rule, model privacy, role-based security , KBA , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , LOD-ANA-PL , Planning , LOD-ANA-TAB , Table , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Product Enhancement

Product

SAP Analytics Cloud 1.0