Symptom
Some table cells are set as read-only as per Apply Styling Rules for Tables.
However, the data is disaggregated to these read-only cells during the data disaggregation.
Environment
SAP Analytics Cloud (Enterprise)
Reproducing the Issue
- Open a SAC story.
- Lock certain table cells by using styling rules in a story.
- Enter data at the parent level.
- The data is distributed to these read-only cells.
Cause
The issue is due to a known limitation where styling rules set to "read-only" only work for direct data entries on the selected cell and do not affect data disaggregation.
Resolution
- Configure the Data Locking for this SAC model.
- Confirm that the Based on Data Locking option is enabled for Data Disaggregation from the Model Preferences -> Planning.
- Set the desired data region to be locked or restricted as per the requirement.
- Ensure the user experiencing the issue is not the data locking power user (details can be found in the Exceptions and Restrictions section of Data Locking)
- manually lock the cells by selecting a cell and then using Lock cell.
Additionally, if the desired feature is to exclude read-only cells set via the Styling panel during data disaggregation, please create an enhancement request as per KBA 2424376 in the SAP Customer Influence Site to follow up.
Keywords
SAP Analytics Cloud, SAC, Data Disaggregation, Data Locking, Styling Rules, Read-Only, Lock Cell, Enhancement Request, distribution, distributing, disaggregating, data entry, locks, formatting, formats, format, styles, style, planning , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , LOD-ANA-TAB-STY , Table Styling Panel, Stying Rules, Number Formatting , Problem