Improvement of information support for formation of management reporting on the example of the activities of an energy company

The purpose of the study is to develop a system for generating management reporting on the production activities of an energy company on the SAP Business Objects Platform. To build a reporting system, the following tasks has been set and solved: the conceptual and datalogical models of the data warehouse were created, data areas have been selected from the general data model, the data warehouse has been designed and developed, universes for report groups have been created, a mechanism for integrating data with the data warehouse has been implemented.

The paper analyses the information and technological infrastructure of an energy company as well as formulates the basic requirements for the system being created for generating reporting. Two main subsystems have been designed: data storage and integration. The process of implementing the designed subsystems in physical form has been described using the appropriate software products: SAP Hana, SAP Universe Designer, SAP Data Services, SAP Business Intelligence.

Thanks to the configured system through the corporate data bus, a relatively simple data integration mechanism became possible. In its information and technological architecture, the company managed to simulate an acceptable data warehouse model and set up the appropriate data flows. A complex data warehouse model has been implemented, and a convenient platform for further data processing has been provided. A clear data integration scheme is configured using SAP Data Services, with the ability to scale and configure the data loading schedule. The developed system has been put into operation and is used by employees to make management decisions within the framework of their professional activities.

1. Ah-Soon С., Vezzosi P., and Mazoue D. (2013), Universe design with SAP business objects BI: The Comprehensive Guide, SAP Press, 265 p.

2. Amaral M., Polo J., Carrera D., and Steinder M. (2015), “Performance evaluation of microservices architectures using containers”, 2015 IEEE 14th International Symposium on Network Computing and Applications (NCA), pp. 27–34. https://doi.org/ 10.1109/NCA.2015.49

3. Ananyin V.I., Zimin K.V., Gimranov R.D., Lugachev M.I., and Skripkin K.G. (2019), “Real-time enterprise management in the digitalization era”, Business Informatics, vol. 13, no. 1, pp. 7–17. (In Russian). https://doi.org/10.17323/1998-0663.2019.1.7.17

4. Artamonov Yu.S., and Vostokin S.V. (2016), “Development of distributed applications for data collection and analysis on the basis of a microservice architecture”, Izvestia of the Samara Scientific Center of the Russian Academy of Sciences, no. 4-4, pp. 688–692 (In Russian).

5. Balalaie A., Heydarnoori A., Jamshidi P., Tamburri D.A., and Lynn T. (2015), “Microservices migration patterns”, Software: Practice and Experience, vol. 48, isse 11, pp. 2019-2042. https:// doi.org/ 10.1002/spe.2608

6. Doljenko A.I., Shpolianskaya I.Yu., and Glushenko S.A. (2020), “Fuzzy production network model for quality assessment of an information system based on microservices”, Business-Informatics, vol. 14, no. 4, pp. 36–46. (In Russian). https:// doi.org/10.17323/2587-814X.2020.4.36.46

7. Fernández-Villamor J.I., Iglesias Á.C., and Garijo M. (2010), “Microservices: Lightweight service descriptions for REST architectural style”, In: Proceedings of the International Conference on Agents and Artificial Intelligence, vol. 1: ICCART, Valencia, Spain, pp. 576–579. https://doi.org/10.5220/0002720105760579

8. Guseva E.S., and Kruglov D.V. (2014), “The meaning of information technology in the process of formation of financial information in integrated reporting”, Modern Problems of Science and Education, no. 6, pp. 448–456 (In Russian).

9. Makarov V.L., Bakhtizin A.R., and Beklaryan G.L. (2019), “Developing digital twins for production enterprises”, Business-Informatics, vol. 13, no. 4, pp. 7–16. (In Russian). https://doi.org/10.17323/1998-0663.2019.4.7.16

10. Malyzhenkov P.V., and Ivanova M.I. (2017), “An architectural approach to IT–business alignment”, Business-Informatics, no. 3 (41). pp. 56–64. (In Russian). https://doi.org/10.17323/1998- 0663.2017.3.56.64.

11. Mitrovich S. (2017), “Specifics of the integration of business intelligence technologies and big data technologies in the processed of economic analysis”, Business-Informatics, vol. 42, no. 4, pp. 40–46. (In Russian). https://doi.org/ 10.17323/1998- 0663.2017.4.40.46.

12. Shytska A.M. (2017), “The design of the microservice architecture of software”, Proceedings of BSTU. Issue 3, Physics and Mathematics. Informatics, no. 2 (200), pp. 122–125. (In Russian).

13. Toffetti G., Brunner S., Blöchlinger M., Dudouet F., and Edmonds A. (2015), “An architecture for self-managing microservices”, AIMC’15: Proceedings of the 1st International Workshop on Automated Incident Management in Cloud, ACM, pp. 19–24. https://doi.org/10.1145/2747470.2747474

14. Villamizar M., Garcés O., Ochoa L. [et al]. (2016), “Infrastructure cost comparison of running web applications in the cloud using AWS Lambda and monolithic and microservice architectures”, 2016 16th IEEE/ACM International Symposium on Cluster, Cloud and Grid Computing (CCGrid), IEEE, pp. 179–182. https://doi.org/10.1109/CCGrid.2016.37