Demantra MDP_MATRIX (p1..p12) calcuation
Hi,
I am trying to understand the exact workings of the calcuations for p1...p12 columns in the MDP_MATRIX
In scenario where forecasting is done on Monthly bucket
hist_glob_prop = 6 (months)
def_delta = .75
history length = 18 (months)
proport_threshold = 0
proport_missing = 0
proport_spread = receive 0 proportions/global proportions
In order to arrive at P1, how many months of past January's it will consider? How does it combine all these to arrive at the P1 value that is stored.
Apart from the calcuation does it apply any internal to Proport algorithm to read the history trend and perform smoothing?
Has any one tried successfully to arrive at P1 value by working it out based on history and above parameters in excel to match with the value in the p1 in MDP_MATRIX.