Project 1: Currently a weekly BO report based on forecast snapshot is run and the data pasted into a complex Excel workbook. Goal is to automate this with a BO Webi or Lumira or Analysis for office type report.
Skills required: Understanding of Supply vs. Demand data model, Webi, Lumira, AO. Potentially regular BW data modeling in case we need create a new data model to support this.
Project 2: MOT and line splits based on if the demand is Sales Order, Forecast or Safety stock. Goal is to create a data model that does the component breakdown with forecast, safety stock and open orders correctly broken out.
Skills required: Basic understanding of APO Demand Planning and SAP master data / Bill of Material structure. BW and/or HANA data modeling to create the necessary data model