Reporting:

• Automated download from legacy system like SAP to the reporting database with validation of the structure and requesting user input to complete the process.
• Support up to consolidation with contribution margin report, profit and loss statement and balance sheet on monthly bases including transparent entry of additional accruals, nettings and corrections.
• Multidimensional data handling ensures complex analysis and ensures correct results in every view
• In addition to the structure data from the legacy systems a own set of structure data can be build up to support actual decisions with showing the figures in the future companies structure (rearranging of product groups and more).
• Compartment of different periods are easy supported with different versions of the plan and even different version of actual (preliminary for group consolidation and final) are implemented.
• Client Server application with tool for administration is implemented with ACCESS, a complete version control guarantees reproduceable and auditable results.
• Integrated in the reporting enviroment a business unit P&L calculation can be established including many different methods to allocate internally services and cost. Automated calculation of KPI (Key Performance Indicators) is possible. This could be extended to Customer segment and Key customer P&L views.

Output:

• Automated reports can be generated via EXCEL or using the Microsoft Web Report Extension.
• Individual Analysis can be generated via EXCEL pivot and SQL server OLAP extension.
• The complete picture is finished by a Management Information tool called Web Analysis which is a WEB based multidimensional BAR Chart with drilldown and color coding for actual versus plan .
• Interface file for DT delivery could be implemented.