Problem in fetching the data from previous month
I am facing one problem in integrated planning,scenario is given below:
Real time cube structure:
Basin Subfamily Month Week KF1 KF2
B1 SF1 200801 # 1000 2000
B1 SF1 200802 # 3000 4000
B1 SF1 200803 # 5000 6000
B1 SF1 200804 # 7000 8000
B1 SF1 200805 # 9000 10000
I have a variable on month of multi-type, function should distribute the value for those month only. Value which need to be distributed is derive by below method..
I have to distribute the month value
[( KF1 - KF2 ) of 200802 + KF2 of 200801] into the week
Eg: 3000-4000+2000 =1000
I have to distribute the result value....
But i cannot find any method to derive above equation
How to do this in planning function?
Edited by: DEEPAK SINGH on Sep 10, 2008 10:21 AM