Analytical system for the large holding
Developer: Jet BI, LLC | all projects
Within the project an analytical reports system was developed on the platform of SAP Business Objects, built on the basis of corporate storage on the platform SAP Business Warehouse on HANA. Data model of the corporate storage is OLAP-cube, which contains transaction systems data and allows to build complex reports.
For convenient data research and analysis there was SAP BO Explorer functionality included, there were spaces on the main company key performance indicators customized: production, retail and wholesale, purchase, costs, financial and management reporting. Within the project, based on statistical data there was a seasonally adjusted sales rate forecast mechanism developed, a module for input, consolidation and coordination of the annual business plans and operational plans was designed.
As source systems we included and used: SAP ERP (modules POSDMBW, MM, SD, LE, FI-GL, FI-AR, FI-AP, PP, CO-OM, CO-PA, CO-PC), SAP ERP Retail, SAP HR, 1C, MS SQL, Oracle SQL.
Implementation of the project allows to create a single information space for all employees; reduce inventory and terms of purchases and sales of materials due to the clear planning system; automate the production plans formation process, thereby the time and plans coordination iterations were reduced.
The system allows to fully automate the process of reports creating, replacing manual data collection and processing, load historical data for past periods, which increased greatly detail and depth of data analysis. Provision of information is implemented in accordance with the concept of “single truth” – a single data source for all reports of all users.
Customer(-s): Large FMCG Company with its own developed retail network
Technologies: SAP ERP, SAP