SACP create plan for annual but system distribute it and store in model by period

[koravits]

Dear expert,

I would like to input plan by annual (total year) but SACP distribute and store the data in model by period.

example

I planned sales price 120$ in fiscal year 2022. The system distribute price (divided by 12) and store in each month 10$, but the price in each month should be 120$ same as total.

Is there any solutions to solve this issue?

Regards.

James

[N1kh1l · Accepted solution]

koravits

Adjust the aggregation type of Sales price member of Account dimension. By default it is sum and hence distribution happens to child members. Make the Exception aggregation type as AVG and select Exception Aggregation dimension as your Date dimension. Something like below. Please delete the entered data and reenter again.

Please upvote/accept if this helps.

Regards

Nikhil

[koravits]

Dear nikhil_1486,

I fill the exception aggregation type as below image but the system still distributed the value into period.

I input price = 1000$. it was distributed into each month = 83.34.

Regards

James

[N1kh1l]

koravits

Please check what is the structure priority in your model preference as shown below. If you have both Accounts and Measure you need to tell the system from where to pick up the Aggregation behavior. Please change the priority to Accounts.

You can get more information here.

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

Regards

Nikhil