Symptom
After the 2021 QRC3 update (Version 2021.14) tables have zero suppression enabled by default (if and only if booked mode is activated).
This can cause the following symptoms to occur:
- Certain rows might disappear. Check the following example. Before the update the row/account ‘Sample Measure’ was visible. With zero suppression activated this row might disappear.
Before zero suppression is activated:
After zero suppression is activated: - Account hierarchy nodes with drill level 1 and aggregation type ‘label’ might disappear.
Before zero suppression is activated:
After zero suppression is activated: - certain columns in tables with deprecated forecast layout using cross calculations disappear
Before zero suppression is activated:
After zero suppression is activated:
Environment
- SAP Analytics Cloud (Enterprise) 2021.14
Cause
In SAC QRC3 (Version 2021.14), SAC provides a new feature: Zero suppression for tables. By default, null suppression and booked mode will be activated in tables. That has the following changes in behavior:
- Accounts (and/or calculated accounts, cross calculations) that are null or zero appeared in booked mode before the release. After the release, null suppression is enabled by default and this causes certain rows to be not visible anymore.
- In case an account member uses ‘Label’ as an aggregation type (in combination with a table with booked mode and zero suppression enabled), the account will disappear by default. Note, this might only appear for tables with selected drill Level 1 (which is a default setting)
- In case tables use the deprecated forecast layout using cross calculations certain columns disappear. This is also due to zero suppression (which is enabled by default).
Resolution
1. In cases where the original behaviour of showing the suppressed zero rows is required, there are two options:
a. Disable zero suppression for the particular axis (in this example: rows)
or
b. Use unbooked mode instead of booked mode (in this example: account dimension)
2. In case one needs to make the label account visible again there are two options:
a. Model the aggregation type to ‘None’ instead of ‘Label’
or
b. Use unbooked mode instead of booked mode (for the account dimension)
3. In order to make the suppressed column appear again, turn on unbooked mode for the cross-calculation dimension.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-TAB , Table , LOD-ANA-PL , Planning , Problem
Product
Attachments
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |