Dead Address Logic
Hello Everyone,
I need some help in understanding how combinations in MDP MATRIX were updated to dead address (predictive status = 99), when I check dying time parameter which is set to 27 week.
While running following sql, which is supposed to give me sales data of dead address combination. But this query gave me sales date of future as well some from past 2 week. Then how these combinations are dead when dying time is 27 week.
Mature age is set as 2 week.
select teo.organization,
sales_date,
load_sig,
tei.item,
sd.sdata15,
sd.actual_quantity
from mdp_matrix mm,
sales_data sd ,