item_price in future time buckets
I needed to populate the last non-zero number from sales_data.item_price per item_id/location_id into the future buckets. When I started looking into the table, I found prices in future buckets already exist. As item_price is an average of historic price from TMPL, I have two questions:
1) What procedure/package/function is loading the future prices?
- Testing shows this is done by the batch engine;
2) What is the logic for determining the price to populate?
- Not sure - but perhaps it is using Fill Causals - Note: Price in my model is NOT a causal and thus no FIll Casual flag set.
0