forecast_api/build/readme.md

Build A New Forecast

• overwrite osmf: review dates and execute build_forecase.sql
• the product and customer attributes are wiped, they will need to be snapped (itemm must come first)
  1. snap_itemm.sql
  2. snap_customer.sql
  3. snap_cost_current.sql
  4. snap_fx.sql (if necessary)
  5. offline/last_price.sql (if necessary)
• build the pool for the more limited UI data set: build_pool.sql
• copy the pool to osmfs_dev from inclusion in the osm_stack and reporting: convert_pool_all.sql
• refresh osm_stack_refresh() to integrate into reporting

Integrate Actuals

• merge_actuals_prep -> push a fresh baseline into a temp table
• merge_actuals_exec -> take the baseline and push it into osmf
• merge_actuals_exec -> manualls splice in osmf into pool