I am new to BW IP. One of my client was to plan as per below for Brand across whole year..
ColC is prepoulated and is available for Input.
ColD is also prepopulated and is only for review and not for input.
ColE is calculated as ColC*ColD.
Both ColC with changes and ColE with updated results should be visible immediately and also should be saved back to Real time cube.
Please let me know how I would model this?
I think it is not a good idea to save redundant information on DB; there is always the danger of inconsistent data. You have two options:
1. Don't save e.g 'Planned Price' but model this as an input-ready formula.
2. If you really want to store e.g. 'Planned Price' you should use a DSO to save this kind of non-aggregateable key figure and you can write a planning function of type FOX to do the calculation.