Improved Input Readiness and Unbooked Data Display in SAP Analytics Cloud

Challenges with Traditional Unbooked Planning Tables

In current planning tables using unbooked mode, all combinations of dimension members are shown even if some combinations are not plannable:

The combination being invalid due to validation rulesThe user lacking write access to the membersThe combination being locked by data locking

And the non-writeable cells due to data security aren’t shown as read-only.

As a result, planners often face large and complex tables with full member combinations. This increases the chance of mistakenly entering data into non-plannable cells, leading to errors or incorrect disaggregation, and creating confusion, wasted effort and planning inaccuracies.

The Improved Input Readiness and Unbooked Data Display

With the QRC3 2025 release in SAP Analytics Cloud, there are a few significant improvements to input readiness and the display of unbooked data, making planning more intuitive and efficient.

Planners gain clear guidance on where they can plan dataStory designers benefit from simplified configurations.

Note:  these new capabilities require opting in to the new table build experience.  See this blog for more details about the new table build experience.

Key Capabilities

Visualized Locking for Input Readiness: Cells that are locked by data access control automatically appear as input-disabled. Planners no long guess where to enter data. The optional “Reasons for Unplannable Data” helps explain the cell is input-disabled because the user is lacking write access.

Safe and Secure Data Disaggregation: when your model has data access control, values entered at a parent node are disaggregated only to leaf nodes where planning is allowed.

Note: Input Readiness and Disaggregation now fully support:

Validation ruleData lockingData access control (new in the QRC3 2025 release)

Cleaner Views with Hiding of Unplannable Unbooked Rows/Columns: Rows and columns where all cells are unbooked and input-disabled (due to validation rule or data access control) are automatically hidden. It gives planners a cleaner and more focused view.  

Note: in the QRC3 2025 release, the unbooked rows/columns locked only by data locking are not hidden.

Unified and Simplified Planning Security Settings:  In the table design panel:

Data disaggregation and input enablement settings are now managed with a single toggle, making configuration faster and less error prone.   Story designers can enforce or ignore individual planning security types: data access control, validation rule and data locking – enabling full flexibility to design different scenarios or simulate planning.

Explore With Examples

Assume your model has:

Data access control: You can write to “Canada” and “Mexico”, but “USA” is read-only.Validation rule: Product “P1” is valid for “Canada”, and Product “P2” is valid for “USA” and “Mexico”

Combination

Plannable?

P1 + Canada

✅Yes

Valid combination and write access

P1 + Mexico

❌No

Invalid combination and write access

P1 + USA

❌No

Invalid combination and no write access

P2 + Canada

❌No

Invalid combination and write access

P2 + USA

❌No

Valid combination but no write access

P2 + Mexico

✅Yes

Valid combination and write access

Prerequisite: your story uses the new table build experience, which you can enable by clicking “Switch All Tables to New Build Experience” to opt in.

Input Readiness Enhancements based on Data Access Control and Validation Rule

With the QRC3 2025 release, input readiness now respects data access control, in addition to validation rule and data locking.

The cell (P1 + USA) is shown as unplannable, with both reasons explained.

The cell (“P1”, “Canada”) is plannable and input-ready.

You no longer need to add every dimension involved in validation rules to the table. If a dimension used in validation rule is not in the table nor filters, it’s treated as if all members are selected.

Any filter applied to a dimension involved in validation rule or data access control is automatically taken in account when determining input readiness, which boosts the accuracy of input readiness. For example,

When all 3 regions are selected in the filter, its parent “North America” stays input-enabled because it has at least an eligible child “Canada”.

When only “USA” (without write access) is selected in the filter, “North America” becomes input-disabled because all its children in the table are now input-disabled.

Data Disaggregation based on Data Access Control

In the model preference, a new toggle – “Disaggregated on Data Access Control” – is available.  

Turned on by default for newly created models.Turned off by default for existing models to preserve current behavior. You can turn it on or off manually, depending on your needs.

When this toggle is turned on, values entered at a parent node are disaggregated only to leaf nodes with write access. In the example above, write access is granted to “Canada” and “Mexico” but “P1 + Mexico” is invalid due to validation rule. Therefore, the data is disaggregation to “P1 + Canada” where write access is permitted and the combination is valid.

Auto-Hiding of Unplannable Unbooked Rows/Columns

In the table design panel, a new table configuration – “Hide Unplannable Unbooked Data” – is available.

When this configuration option is turned on,

Entire rows or columns containing only unbooked and input-disabled cells (due to validation rule or data access control) are automatically hidden.This creates a cleaner and more focused table, allowing users to focus on plannable cells.

In the example above, only “P1 + Canada” and “P2 + Mexico” cells are plannable due to validation rule and data access control. Other rows that are unplannable and unbooked are hidden. 

Note: in the QRC3 2025 release, the unbooked rows/columns locked only by data locking are not hidden.

The input -disabled but booked cells remain visible in the table as they contribute to the parent level aggregation.  In this example, you have read access to “USA”, so the “USA” row is displayed but locked. Other rows that are unplannable and unbooked are hidden.

Simplified and Harmonized Table Settings for Planning Security

In the table design panel, story designers can now decide whether to enable or ignore planning security.

When enabled:Cells that are locked by data locking, validation rule or data access control appear as readonly. Data disaggregation respects model disaggregation settings.When disabled:Cells are input-enabled and values are disaggregated to all leaf nodes.

Conclusion

With these new capabilities, planners are empowered to work more confidently and efficiently, while ensuring consistency and accuracy.

Improved input readinessData disaggregation respecting data access control, validation rule and data lockingCleaner and focused table views, automatically hiding all unplannable unbooked rows and columnsSimplified configuration for story designers 

​ Challenges with Traditional Unbooked Planning TablesIn current planning tables using unbooked mode, all combinations of dimension members are shown even if some combinations are not plannable:The combination being invalid due to validation rulesThe user lacking write access to the membersThe combination being locked by data lockingAnd the non-writeable cells due to data security aren’t shown as read-only.As a result, planners often face large and complex tables with full member combinations. This increases the chance of mistakenly entering data into non-plannable cells, leading to errors or incorrect disaggregation, and creating confusion, wasted effort and planning inaccuracies. The Improved Input Readiness and Unbooked Data DisplayWith the QRC3 2025 release in SAP Analytics Cloud, there are a few significant improvements to input readiness and the display of unbooked data, making planning more intuitive and efficient.Planners gain clear guidance on where they can plan dataStory designers benefit from simplified configurations.Note:  these new capabilities require opting in to the new table build experience.  See this blog for more details about the new table build experience. Key CapabilitiesVisualized Locking for Input Readiness: Cells that are locked by data access control automatically appear as input-disabled. Planners no long guess where to enter data. The optional “Reasons for Unplannable Data” helps explain the cell is input-disabled because the user is lacking write access.Safe and Secure Data Disaggregation: when your model has data access control, values entered at a parent node are disaggregated only to leaf nodes where planning is allowed.Note: Input Readiness and Disaggregation now fully support:Validation ruleData lockingData access control (new in the QRC3 2025 release)Cleaner Views with Hiding of Unplannable Unbooked Rows/Columns: Rows and columns where all cells are unbooked and input-disabled (due to validation rule or data access control) are automatically hidden. It gives planners a cleaner and more focused view.  Note: in the QRC3 2025 release, the unbooked rows/columns locked only by data locking are not hidden.Unified and Simplified Planning Security Settings:  In the table design panel:Data disaggregation and input enablement settings are now managed with a single toggle, making configuration faster and less error prone.   Story designers can enforce or ignore individual planning security types: data access control, validation rule and data locking – enabling full flexibility to design different scenarios or simulate planning. Explore With ExamplesAssume your model has:Data access control: You can write to “Canada” and “Mexico”, but “USA” is read-only.Validation rule: Product “P1” is valid for “Canada”, and Product “P2” is valid for “USA” and “Mexico”CombinationPlannable? P1 + Canada✅YesValid combination and write accessP1 + Mexico❌NoInvalid combination and write accessP1 + USA❌NoInvalid combination and no write accessP2 + Canada❌NoInvalid combination and write accessP2 + USA❌NoValid combination but no write accessP2 + Mexico✅YesValid combination and write access Prerequisite: your story uses the new table build experience, which you can enable by clicking “Switch All Tables to New Build Experience” to opt in.Input Readiness Enhancements based on Data Access Control and Validation RuleWith the QRC3 2025 release, input readiness now respects data access control, in addition to validation rule and data locking.The cell (P1 + USA) is shown as unplannable, with both reasons explained.The cell (“P1”, “Canada”) is plannable and input-ready.You no longer need to add every dimension involved in validation rules to the table. If a dimension used in validation rule is not in the table nor filters, it’s treated as if all members are selected.Any filter applied to a dimension involved in validation rule or data access control is automatically taken in account when determining input readiness, which boosts the accuracy of input readiness. For example,When all 3 regions are selected in the filter, its parent “North America” stays input-enabled because it has at least an eligible child “Canada”.When only “USA” (without write access) is selected in the filter, “North America” becomes input-disabled because all its children in the table are now input-disabled. Data Disaggregation based on Data Access ControlIn the model preference, a new toggle – “Disaggregated on Data Access Control” – is available.  Turned on by default for newly created models.Turned off by default for existing models to preserve current behavior. You can turn it on or off manually, depending on your needs.When this toggle is turned on, values entered at a parent node are disaggregated only to leaf nodes with write access. In the example above, write access is granted to “Canada” and “Mexico” but “P1 + Mexico” is invalid due to validation rule. Therefore, the data is disaggregation to “P1 + Canada” where write access is permitted and the combination is valid. Auto-Hiding of Unplannable Unbooked Rows/ColumnsIn the table design panel, a new table configuration – “Hide Unplannable Unbooked Data” – is available.When this configuration option is turned on,Entire rows or columns containing only unbooked and input-disabled cells (due to validation rule or data access control) are automatically hidden.This creates a cleaner and more focused table, allowing users to focus on plannable cells.In the example above, only “P1 + Canada” and “P2 + Mexico” cells are plannable due to validation rule and data access control. Other rows that are unplannable and unbooked are hidden. Note: in the QRC3 2025 release, the unbooked rows/columns locked only by data locking are not hidden.The input -disabled but booked cells remain visible in the table as they contribute to the parent level aggregation.  In this example, you have read access to “USA”, so the “USA” row is displayed but locked. Other rows that are unplannable and unbooked are hidden.  Simplified and Harmonized Table Settings for Planning SecurityIn the table design panel, story designers can now decide whether to enable or ignore planning security.When enabled:Cells that are locked by data locking, validation rule or data access control appear as readonly. Data disaggregation respects model disaggregation settings.When disabled:Cells are input-enabled and values are disaggregated to all leaf nodes. ConclusionWith these new capabilities, planners are empowered to work more confidently and efficiently, while ensuring consistency and accuracy.Improved input readinessData disaggregation respecting data access control, validation rule and data lockingCleaner and focused table views, automatically hiding all unplannable unbooked rows and columnsSimplified configuration for story designers   Read More Technology Blog Posts by SAP articles 

#SAP

#SAPTechnologyblog