Method for forming multi-dimensional data in the information financial and economic system at the enterprise of state space corporation “Roscosmos”

The construction of detailed accounting that allows to generate complex analytical reporting is an indispensable requirement of a modern financial system. For enterprises of the State Space Corporation “Roskosmos” with custom-made and small-scale production, operating in the conditions of Federal Law No. 275, characterized by a large amount of R&D and a high degree of uncertainty in the process of creating products, this task is a system-forming one. The reporting should contain consistent data in any area of management and accounting at any given time. Along with this, system must provide the flexibility, reliability and performance inherent in transactional databases. To build information support that satisfies the specified conditions, it is required either to separate OLTP and OLAP data schemas, or to apply specialized solutions based on the use of structures and techniques optimized for performing OLAP operations in traditional RDBMSs. This article discusses an approach to the formation of multidimensional data in an automated management system for economic tasks, as an effective alternative to complex and expensive BI solutions. Unlike many commercial systems, the ASU FEZ does not store redundant data (for example, operational accounting registers in the 1C: Enterprise platform) required to build analytical accounting. The underlying data structures and methods of their processing allow for all types of accounting and have powerful tools for constructing analytical reporting. The article proposes algorithms for the operation of the system using the example of building simple OLAP cubes used in real tasks of automating financial and economic activities in ISS JSC for one of the Purchase subsystems. The formalization of these problems is carried out, the mathematical apparatus for constructing multidimensional data models based on information from a fixed set of normalized tables of a relational database is considered. Examples of SQL queries and outputs are provided. The advantages of using the system in operational, management and accounting at an enterprise, which increase its operational efficiency, are summarized.