SAP Knowledge Base Article - Public

2923806 - Calculated member appears in a table even if the option "Show Unbooked members" is NOT selected in SAP Analytics Cloud

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • Calculated account member (through a model formula) appears in a story table even if the option "Show Unbooked members" is NOT selected.
  • Example Account A = Account B / Account C, if Account B does NOT contain data and Account C does contain data, Account A is shown in the story table while it is not supposed to appear because the user does not allow unbooked data to appear.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Create a member with formula for example in Account dimension Account A = Account B/Account C
  2. Publish data for only Account C, Account A and Account B should be unbooked then
  3. Create a story table and filter Account dimension with the three members above and do not select the option "Show Unbooked data"
  4. Remove Account B and Account C from the filter, Account A should also disappear as it is unbooked, however it is still displayed which is not expected
  5. Remove data for Account C and publish again, this time Account A disappears

So if one of the formula members has data assigned the system does not consider the calculated member as unbooked.

Cause

Null Suppression is not applied.

Resolution

This is now possible by enabling Null Suppression option in columns or rows.

See https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/92b95e9aeb404b7d9b550e0d5a774f5b.html#hide-zero-or-booked-null-values

See Also

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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, Unbooked Data displayed regardless if option to display is selected or not, calculated measure , KBA , when clculated accounts are displayed , booked data not working when clculated a , calculated calculations calculate calc , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-TAB-COR , Table Core Functionalities, FEC, Hidden Tuples, Drill , Problem

Product

SAP Analytics Cloud 1.0