86225ea7e5
Lots of cleanup here too, removing large swaths of code that are no longer needed. Many improvements the Excel workbook, which is kept in Teams, not git. These changes may or may not have had accompanying VBA changes. |
||
|---|---|---|
| .. | ||
| build_baseline.sql | ||
| build_baseline_from_FAnalysis.sql | ||
| build_forecast.sql | ||
| build_pool.sql | ||
| build_pullforward.sql | ||
| build_rolling.sql | ||
| convert_pool_all.sql | ||
| convert_to_budget.sql | ||
| osm_pool.sql | ||
| readme.md | ||
| rebuild_script.sh | ||
| round_pool.sql | ||
| snap_cost_current.sql | ||
| snap_cust_osmfs.sql | ||
| snap_cust_pool.sql | ||
| snap_customer.sql | ||
| snap_fx.sql | ||
| snap_itemm.sql | ||
| snap_itemm_pool.sql | ||
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)
- snap_itemm.sql
- snap_customer.sql
- snap_cost_current.sql
- snap_fx.sql (if necessary)
- 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 tablemerge_actuals_exec-> take the baseline and push it intoosmfmerge_actuals_exec-> manualls splice inosmfintopool