3701595 - Understanding Differences Between Booked and Unbooked Member Totals in SAP Analytics Cloud (SAC)

• A discrepancy in totals is observed when comparing booked versus unbooked member selections in the planning model within SAP Analytics Cloud (SAC).
• The issue occurs in both SAC Excel Add-in and SAC Web interface.
• Unbooked members on Account and Account detail dimensions also show different totals in SAC Web interface.

• SAP Analytics Cloud (Enterprise)

1. Login to the Tenant.
2. Open the Story containing Booked and Unbooked Member.
3. Observe that SAC displays different totals when comparing booked versus unbooked member selections.

• In SAP Analytics Cloud, unbooked members are dimension members for which no data has been entered yet, resulting in NULL values.
• When unbooked members are shown without zero suppression, SAC includes these NULL members in aggregations and hierarchy roll-ups, leading to differences in totals compared to booked-only selections.
• This is expected behavior.

1. Enable zero suppression (hide zero/null values) at the row/column level from the right-side builder panel within SAC.
2. Verify that unbooked members are excluded, and the totals match the booked selection.

• Refer to: Show or Hide Elements in Tables (New Table Build Experience) | SAP Help Portal.

SAC, planning model, booked members, unbooked members, zero suppression, data discrepancy, SAC Excel Add-in, SAC Web interface, hierarchy roll-ups, NULL values, data aggregation, story design, visualization. , KBA , LOD-ANA-TAB , Table , Problem