Analysis, design, implementation and testing of multiple reporting systems for identifying the available and required capacity for each workstation.
The Business Content data sources (SAP APO and R/3 PP) are analyzed. The aim is to contrast the available capacity and the capacity requirement for each workstation, in order to display utilization (especially overloads) for the next 12 months. Other tasks include customizing the extract structures, setting up the loading processes (transfer and update rules), creating and modeling an InfoCube, and developing multiple queries in the BEx Analyzer.
Originally, the relevant data was to be extracted from SAP APO. However, the analysis showed that the desired information could only be determined with a great deal of effort. As a consequence, the evaluation only concerns workstations that are not relevant to APO and workstations that cause bottlenecks.