ABSTRACTS OF ARTICLES OF THE JOURNAL "INFORMATION TECHNOLOGIES".
No. 10. Vol. 29. 2023

DOI: 10.17587/it.29.540-548

A. S. Kartamyshev, Head of the group of the department of automation of financial and economic tasks,
B. A. Chernysh, Software engineer of the group of the department of automation of financial and economic tasks, Academician M. F. Reshetnev Information Satellite Systems

Approach to Generating Data for Analytical Reporting in the Enterprise Management System

Analytical reporting tools allow to turn disparate data accumulated in the information system into structured information described in terms of the relevant subject area. This information makes it possible to timely and adequately respond to changes, make informed management decisions for business leaders, analysts, economists, etc. The article describes the composition of business analysis systems, the components of which are built using OLAP technology. Varieties of OLAP solutions are considered. A method for constructing multidimensional cubes is proposed, developed and implemented by the authors in an automated system for managing financial and economic tasks. The scheme of storage, methodology and algorithm of data processing are described on the example of the "Purchases" subsystem. Examples of real analytical problems solved during the operation of the system at an industrial enterprise are given. A comparative analysis of data sampling time measurements based on structures and algorithms that provide the described approach to data generation, with a sample from unprepared relational tables for real problems from examples, was carried out. The texts of the corresponding SQL queries are given. The measurement results are summarized in tables and visualized in the form of a diagram. The evaluation of the results obtained is carried out, the problems of using unprepared data are described. The article also discusses the features of the analytical mechanisms of commercial accounting systems on the example of the 1C: Enterprise 8.3 platform (registers of accumulation, information, accounting, calculations). The effectiveness of the considered mechanisms for the formation of analytical reporting was assessed in comparison with the proposed approach to data structuring.
Keywords: database, OLTP, OLAP, ETL, Data Mining, multidimensional cube, analytical reporting, data processing, transaction, information system

P. 540-548

References

1. Sorokina V. V., Fedoryak D. A. Advanced BI systems for business analytics, Modern Science, 2022, no. 2-1, pp. 119—122 (in Russian).
2. Vychugzhanina T. V., Dolgova I. A. Using data ware­houses and OLAP technology in modern ERP-systems, Materialy I Vserossiyskoy nauchnoy konferencii "Informacionnye tehnologii v modelirovanii i upravlenii: podhody, metody, resheniya", 2017, pp. 305—309 (in Russian).
3. Kuznetsov S. D., Velihov P. E., Fu Q. Real-time analytics, hybrid transactional/analytical processing, in-memory data management, and non-volatile memory, Trudy instituta sistemnogo programmirovaniya RAN, 2021, vol. 33, no. 3, pp. 171—198 (in Russian).
4. Berezovskaya E. A., Kryukov S. V. Working with the Qlik Sense business intelligence system, Rostov-on-Don, Published by Yuzhniy Federalniy Universitet, 2019, 98 p. (in Russian).
5. Tkachyova N. V., Sukhomlinove M. I., Severina Y. N., Shevchenko A. N. Comparative appraisal of Bl-products and platforms as an instrument of analytical systems engeneering, Region: Systemy, economica, upravleniye, 2014, no. 4 (27), pp. 235—240 (in Russian).
6. Vahmyanin I. S. Analytical Platform Visiology, Otkrytye systemy. SUBD, 2020, no. 3, pp. 29—31 (in Russian).
7. Ilyashenko V. M. Overview of Russian Business Intelligence Systems: Challenges and Opportunities, Sbornik materialov X Mezhdunarodnoy nauchno-prakticheskoy konferencii "Razvitie nauki i praktiki v globalno menyayuschemsya mire v usloviyah riskov", 2022, pp. 109—113 (in Russian).
8. Kartamyshev A. S., Chernysh B. A., Murygin A. V. Method for forming multi-dimensional data in the information financial and economic system at the enterprise of state space corporation "Roscosmos", Sibirskiy aerokosmicheskiy zhurnal, 2021, vol. 22, no. 4, pp. 589—599 (in Russian).
9. Ulman J. Fundamentals of database systems, Moscow, Finansy i statistica, 1983 (in Russian).
10. Harrington J. Relational Database Design and Implementation, Morgan Kaufmann, 2016.
11. Berger A. B. Microsoft SQL Server 2005 Analysis Ser­vices. OLAP è multidimensional data analysis, St. Petersburg, BHV-Peterburg, 2007 (in Russian).
12. Redreev P. G. Construction of hierarchies in multidimen­sional data models, Izvestiya Saratovskogo universiteta, 2009, no. 4, pp. 7—12 (in Russian).
13. Zykin S. V. Formation of Hypercube Representation of Relational Database, Programming and Computer Software, 2006, vol. 32, no. 6, pp. 348—354.
14. Radchenko M. G., Hrustaleva E. Y. 1C: Enterprise 8.3. Practical Developer's Guide. Examples and typical techniques, Moscow, 1 Ñ -Publishing, 2023 (in Russian).

To the contents