SAP Knowledge Base Article - Public

3565215 - Data Disaggregation does not consider the Read-only Styling in SAP Analytics Cloud (SAC)

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

  1. Open a SAC story.
  2. Lock certain table cells by using styling rules in a story.
  3. Enter data at the parent level.
  4. 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

Data Locking

  1. Configure the Data Locking for this SAC model.
  2. Confirm that the Based on Data Locking option is enabled for Data Disaggregation from the Model Preferences -> Planning.
  3. Set the desired data region to be locked or restricted as per the requirement.
  4. 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)

Lock Cell

  1. 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

Product

SAP Analytics Cloud all versions