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) | |
Periodic | 20 | |
YTD | 20 | 20 |
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) | |
Periodic | 30 | |
YTD | 30 | 30 |
Expected result:
Jan (2020) | Feb (2020) | |
Periodic | 20 | 10 |
YTD | 20 | 30 |
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) | |
Periodic | 20 | 0 |
YTD | 20 | 20 |
step 2:
Jan (2020) | Feb (2020) | |
Periodic | 20 | 10 |
YTD | 20 | 30 |
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