Hi,
I have a MP that consists of an Actual cube (with actual data) and a Plan cube (no data).
Actual cube has CALMONTH, PRODUCT and ACTUAL QTY.
Plan cube has CALMONTH, PRODUCT, ACTUAL QTY and PLANNED QTY.
I have a input-ready query that base on an aggregation level of this MP. The query is for input of PLANNED QTY by CALMONTH. The changes is then saved in the Plan cube.
This is what I have in Plan cube after i saved the changes.
CALMONTH = 200806
PRODUCT = ''#'
ACTUAL QTY = 0
PLANNED QTY= 100
I created a planning function and planning sequence that do distribution by reference data in the actual data.
I execute the planning sequence in Planning Modeller and I checked the trace, it is executely successfully and the data is distributed correctly to PRODUCT level.
eg:
CALMONTH PRODUCT ACTUAL QTY PLANNED QTY
200806 ABC 0 40
200806 DEF 0 60
I also have a workbook that execute this planning sequence. However, although this planning sequence is executed successfully without error, i can't see the data get distributed in Plan Cube.
What should I do in order to save the distribution result in the Plan Cube?
Please help.
Thanks,
CH