SAP Knowledge Base Article - Public

3163479 - YTD and periodic data conversion issue in SAP Analytics Cloud for Planning (SAC)

Symptom

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

The original data is as below:

 Jan (2020)Feb (2020)
Periodic  
YTD  

You input value 20 in YTD for Jan (2020), the periodic value is updated as expected. (the input data is in bold font)

 Jan (2020)Feb (2020)
Periodic20 
YTD2020

After that, you input value 30 in YTD for Feb (2020), the periodic value is not updated as expected.
Actual result:

 Jan (2020)Feb (2020)
Periodic30 
YTD3030

Expected result:

 Jan (2020)Feb (2020)
Periodic2010
YTD2030

Environment

  • SAP Analytics Cloud (Enterprise) 2021.20.22

Cause

The feature behaves as it is designed.
Please see more details about how it is functioning in the SAC online help -> https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/172a080eb0ab4a5982c9364dba43e484.html

Resolution

The issue you raised is a feature enhancement. Please follow this Knowledge Base Article to create an enhancement request: https://launchpad.support.sap.com/#/notes/2424376 

You can work around by pre-filling the cells with zeros.

step 1:

 Jan (2020)Feb (2020)
Periodic200
YTD2020

step 2:

 Jan (2020)Feb (2020)
Periodic2010
YTD2030

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, PER, MTD, year to date, month, measure, cross calculation , KBA , HAN-DB-EPM , SAP HANA Planning and Simulation Platform , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Product Enhancement

Product

SAP Analytics Cloud 1.0