SAP Knowledge Base Article - Public

2957247 - LAST aggregation on Time should consider unbooked values in SAP Analytics Cloud (SAC)

Symptom

  • The exception aggregation LAST shows the last booked value in SAP Analytics Cloud (SAC).
  • For example when April is the last month in Q2, the Q2 value shows the April value.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Set up account dimension member with Exception Aggregation Type "Last" and Exception Aggregation Dimension "Date".
  2. When there are unbooked values in the last period, the quarterly sum shows the total from the last booked values and not the end of the quarter value. 

Cause

This is a product limitation in SAP Analytics Cloud (SAC).

Resolution

See Also

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, FPA34-5295, 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, sap analyst cloud, connected, failure, stopped   , KBA , balance is wrong in detailed reports , aggregated headcount balance is wrong in , LOD-ANA-PL , Planning , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-TAB , Table , LOD-ANA-ML , SAC Modelling , Product Enhancement

Product

SAP Analytics Cloud 1.0