Data Entry Table Planning

[nasser_itani]

Hello Experts,

Is there anyway to do data entry to be entered on total level and be the same as leaf member.

For example, entering 100 on all dates should be in 2022 as 100 and 2023 as 100.

Any way to do this on SAC?

[N1kh1l]

nasser_itani

Try setting the Exception aggregation as Average for the Account member where you want this. If you are using the new model type (measure based), you would need to do this to measure instead of account.

Output

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/fac0e8d372634024b7f2f...

Hope this helps.

Nikhil

[JefB]

Yes, that works for unbooked cells.

But for already booked cells, with existing data underneath, you have to be very careful and first delete existing values before planning new values.

This requires end user training...

Unfortunately there's still no copy disaggregation yet in SAC that could make this failure proof.