Skip to Content
0
Former Member
Jul 30, 2016 at 07:30 PM

Planning function overwrites user input

154 Views

Hello Experts,

We have two input enabled queries on the same aggregation level as below.

1. Input 0quantity. When user clicks submit button, planning function Formula is triggered to calculate value (0amount)

2. Review and update 0amount

Planning function works as expected on first run. Issue happens when executed again which overwrites manual input from query 2.

Both queries have same characteristics in rows, filter and 36 months in columns, Keyfigure are different as mentioned above.

Is it possible to exclude 0AMOUNT where 0ASOURCE Source of data = query2 in the planning function?

Or execute planning sequence/function only on changed data from query1?

Tried Planning sequence when saving in Central setting but doesn't work.

RSPLAN > Infoprovider > Central Setting > Save plan data > Only Read changed data

Thanks for the help in advance.

Regards,

Subu