SAP Knowledge Base Article - Public

3135961 - Cut-over date functionality does not work correctly when selecting the Last booked (Actuals) option in SAP Analytics Cloud for Planning (SAC)


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

  • The Forecast Layout is selected for the table structure
  • The cut-over date is set to the Last booked (Actuals) option. In the forecast layout setting, you can see the cut-over date is interpreted as Oct. 31, 2021 by the system.
  • However, month Oct is displayed with the Forecast version.
  • You expect Oct to be displayed with the Actual version.


  • SAP Analytics Cloud (Enterprise) 2021.20.12


Normally, if the month is not completed yet then it should be in forecast and if the cut-over date is the last day of the month then it should be in Actuals means it is completed. That means, if the cut-over date is Dec. 31, Dec should be in Actuals.

However, in your case, fiscal year is set in your modeling for this model.
For example, 2022 P02 is the natural month of Oct. The last day of Oct is Oct.31th, the day 31 cannot be found in P02 (natural month February has 28/29 days). So when using last booked(Actuals), the result will be Forecast October.
But in natural month Sep (2022 P01), the last day of Sep is Sep.30th, the day 30 can be found in P01 (natural month January has 31 days). So when using last booked (Actuals) -Sep.30th, the result will be Forecast October.

In conclusion, it has limitation when using last day for Fiscal year, but it works for calendar year.


This issue can be taken as a feature enhancement.
Please follow this Knowledge Base Article to create an enhancement request: 

See Also

Your feedback is important to help us improve our knowledge base.


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, last booked(Actuals) , KBA , LOD-ANA-PL-FCL , Forecast Layout , Problem


SAP Analytics Cloud all versions