Holding has various IT systems within its structure, so it was important to adhere to the established architecture during the project. After determining the source systems and developing a general approach, the following architecture was chosen:
- SAP Analytics Cloud – the main system for the project (analytics and planning)
- SAP HANA - central Data Warehouse (DWH)
- Medoc, SAP ERP, 1C, Excel files - data sources
The integration with Medoc and the data loading of declarations and their attachments posed a challenge. To observe the high security measures of Medoc servers, integration was implemented using XML files. Given the intricate structure of these files, SAP Data Services proved to be instrumental. This tool facilitated the seamless loading of data from any file format into the Data Warehouse.
Thus, all the necessary data for analysis for each legal entity and the overall holding is collected from the source systems. Users enrich the loaded data with specific tax information and planning data using input forms.
During the project, a model was developed in which all indicators are calculated in real-time without the need for manual calculations. As a result, dashboards and summary reports always reflect the most up-to-date situation, reducing the involvement of tax managers in the process.
The customers received the following analytical reports and dashboards as a result:
- Tax payments
- VAT and corporate income tax
- Tax debts and overpayments
- Consolidated dashboard with key performance indicators for tablets.
Tax managers can provide comments on their data directly in the reports to provide explanations and make the dashboards more informative.