Multi-dimensional data analysis device, electronic equipment and readable storage medium

Abstract

The invention provides a multi-dimensional data analysis device, electronic equipment and a readable storage medium, after a spreadsheet plug-in receives a hierarchical dimension selected by a user, a multi-dimensional query condition is automatically generated, and a dimension request instruction and a multi-dimensional data request instruction are triggered to a multi-dimensional data engine. And the multi-dimensional data engine calls dimension data in the dimension table from the data storage system according to the instruction, processes the multi-dimensional data in the fact table to generate an operation result, returns the dimension data and the operation result to the spreadsheet plug-in to generate a report, generates a multi-dimensional analysis table, and returns the multi-dimensional analysis table to the storage system for archiving. According to the device, one-stop processing of multi-dimensional data query, calculation analysis and report generation is realized through automatic cooperation among the components, a user only needs to select a plurality of required dimensions in the spreadsheet and initiate a request, automatic report generation and subsequent multi-dimensional analysis are directly realized through interaction of the three components, and the user experience is improved. Complex and frequent multi-system operation is reduced, and the efficiency and convenience of report generation and multi-dimensional analysis are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of table tool development, and in particular to a multidimensional data analysis device, an electronic device and a readable storage medium. Background Art

[0002] Spreadsheets have become an essential tool for daily office work in many industries. Users have certain basic knowledge and experience, and have accumulated a large number of work-related spreadsheets. However, the business data of enterprises is usually stored in different databases. Users usually have to frequently log in to various information systems to query data and export the query results to spreadsheets to form reports, or fill in the data directly in the spreadsheets. Every statistical report or analysis has to repeat the same process, which is inefficient. In addition, the multidimensional spreadsheets on the market have the following defects: 1) Dimensional drilling up and drilling down are not supported, and the report data is presented in a single format.

[0003] 2) Does not support importing and analyzing customized report data or generated multidimensional data. Summary of the invention

[0004] In view of the above problems, the present invention is proposed to provide a multidimensional data analysis device, an electronic device and a readable storage medium that overcome the above problems or at least partially solve the above problems.

[0005] The present invention provides a multidimensional data analysis device, which includes an electronic spreadsheet plug-in, a multidimensional data engine, and a data storage system. The electronic form plug-in is used to respond to the user's selection of multiple hierarchical dimensions in the electronic form, generate multi-dimensional query conditions, and generate dimension request instructions and multi-dimensional data request instructions based on the multi-dimensional query conditions, and send them to the multi-dimensional data engine; The multidimensional data engine is used to obtain the dimension data corresponding to each dimension in the multidimensional query condition from the data storage system according to the dimension request instruction, obtain and process the multidimensional data according to the multidimensional data request instruction to obtain the multidimensional data operation result, return the dimension data corresponding to each dimension and the multidimensional data operation result to the spreadsheet plug-in to generate a report, and generate a multidimensional analysis table in a specified format based on the multidimensional data operation result and upload it to the data storage system; The data storage system is used to store dimension tables that record dimensional data, fact tables that record multidimensional data, and receive and store multidimensional analysis tables uploaded by the multidimensional data engine.

[0006] Optionally, the multidimensional data engine includes a dimension metadata database, a dimension data importer, a multidimensional data analyzer, a multidimensional data operator, and a data file generator. Dimension metadata database, used to store dimension metadata obtained by elementization and regularization of dimension data. Dimension metadata includes dimension basic information, dimension hierarchical relationship information, and calculation caliber information; A dimension data importer, used to receive a dimension request instruction of a spreadsheet plug-in, and obtain dimension metadata of the multi-dimensional query condition from a dimension metadata database according to the multi-dimensional query condition recorded in the dimension request instruction, and obtain dimension data corresponding to the multi-dimensional query condition from a dimension table of a data storage system according to the dimension metadata of the multi-dimensional query condition, and return the dimension data to the spreadsheet plug-in to generate a report template; A multidimensional data analyzer, used for receiving a multidimensional data request instruction from a spreadsheet plug-in, parsing the multidimensional data request instruction to obtain a basic dimension, an operation dimension and a multidimensional data operation rule, and inputting the basic dimension, the operation dimension and the multidimensional data operation rule into a multidimensional data operator; The multidimensional data operator is used to read and import the data corresponding to the basic dimension and the operation dimension from the data storage system, and to perform operations using the data corresponding to the basic dimension and the operation dimension according to the multidimensional data operation rules to obtain the multidimensional data operation result, and return the multidimensional data operation result to the electronic form plug-in to generate a report in combination with the report template; The data file generator is used to read the multidimensional data operation results and generate a multidimensional analysis table in a specified format based on the multidimensional data operation results, and upload it to the data storage system.

[0007] Optionally, the dimension data importer includes a first instruction recognition module, a dimension parsing module and a dimension data importing module. A first instruction recognition module is used to recognize a dimension data acquisition instruction from various request instructions sent by the electronic form plug-in, and convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to a first preset interface specification format, and input the standard dimension data acquisition instruction into a dimension parsing module; A dimension parsing module, used to read the dimension metadata of the multi-dimensional query condition from the dimension metadata database according to the multi-dimensional query condition recorded in the standard dimension data acquisition instruction, and input the dimension metadata into the dimension data import module; The dimension data import module is used to read and import the dimension data corresponding to the multi-dimensional query conditions from the dimension table of the data storage system according to the dimension metadata of the multi-dimensional query conditions, and send the dimension data corresponding to the multi-dimensional query conditions to the electronic spreadsheet plug-in.

[0008] Optionally, the multidimensional data analyzer includes a second instruction recognition module and a multidimensional data request instruction parsing module. A second instruction recognition module, used to recognize a multidimensional data request instruction from the request instruction sent by the electronic form plug-in, and convert the multidimensional data request instruction into a standard multidimensional data request instruction according to a second preset interface specification format, and input the standard multidimensional data request instruction into the multidimensional data request instruction parsing module; The multidimensional data request instruction parsing module is used to parse the standard multidimensional data request instruction to obtain the basic dimension, operation dimension and multidimensional data operation rules, and input the basic dimension, operation dimension and multidimensional data operation rules into the multidimensional data operator.

[0009] Optionally, the multidimensional data operator includes a multidimensional data import module and a multidimensional data operation module. A multidimensional data import module is used to read data corresponding to basic dimensions and operation dimensions from the dimension table and fact table of the data storage system, and import the data corresponding to the basic dimensions and operation dimensions into the multidimensional data operation module; The multidimensional data operation module uses the data corresponding to the basic dimension and the operation dimension to perform operations according to the multidimensional data operation rules to obtain the multidimensional data operation results.

[0010] Optionally, the data file generator includes an analysis data import module, a data conversion module, and a file upload module. An analysis data import module is used to read multidimensional data operation results and / or custom report data, and import the multidimensional data operation results and / or custom report data into a data conversion module; A data conversion module, used to convert multidimensional data operation results and / or custom report data into a multidimensional analysis table in a specified format; The file upload module is used to upload the multidimensional analysis tables corresponding to the multidimensional data operation results and / or the custom report data to the data storage system.

[0011] Optionally, the multidimensional data engine is also used to receive and execute drill-down request instructions from a spreadsheet plug-in, expand the data of the next level of a certain dimension in the form of rows or columns, and receive and execute drill-up request instructions from a spreadsheet plug-in, collapse the data of the same level of a certain dimension in the form of rows or columns.

[0012] Optionally, the data storage system is a relational database or a distributed database or a distributed file system.

[0013] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor. When the electronic device executes the computer program, the multidimensional data analysis device as described in any one of the embodiments of the present invention is loaded.

[0014] The present invention further provides a readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the multidimensional data analysis device as described in any one of the embodiments of the present invention is loaded.

[0015] The present invention includes the following advantages: The multidimensional data analysis device of the present invention is composed of an electronic spreadsheet plug-in, a multidimensional data engine and a data storage system. After the electronic spreadsheet plug-in receives the hierarchical dimension selected by the user, it automatically generates a multidimensional query condition and triggers a dimension request instruction and a multidimensional data request instruction to the multidimensional data engine. The multidimensional data engine retrieves the dimension data in the dimension table from the data storage system according to the instruction, and processes the multidimensional data in the fact table to generate the calculation result, returns the two to the electronic spreadsheet plug-in to generate a report, and returns the structured multidimensional analysis table to the storage system for archiving. The device realizes one-stop processing of multidimensional data query, calculation analysis and report generation through automatic collaboration between components. Users no longer need to frequently log in to various information systems to query and export data. They only need to select multiple dimensions of the requirements in the electronic spreadsheet and initiate a request. The automatic generation of the report and subsequent multidimensional analysis will be realized directly through the interaction of the electronic spreadsheet plug-in, the multidimensional data engine and the data storage system, which reduces the complex and frequent multi-system operations and improves the efficiency and convenience of report generation and multidimensional analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 is a structural block diagram of a multidimensional data analysis device provided by an embodiment of the present invention; Figure 2 is a structural block diagram of a multidimensional data engine provided by an embodiment of the present invention; Figure 3 is a structural block diagram of a dimension data importer provided by an embodiment of the present invention; Figure 4 is a structural block diagram of a multidimensional data analyzer provided by an embodiment of the present invention; Figure 5 It is a structural block diagram of a multidimensional data operator provided by an embodiment of the present invention; Figure 6 It is a structural block diagram of a data file generator provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0017] The following are the relevant glossaries of the present invention: Table 1 Explanation of terms in the present invention

[0018] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0019] Reference Figure 1 , shows a structural block diagram of a multidimensional data analysis device provided in an embodiment of the present invention, which may specifically include the following modules: The electronic form plug-in is used to respond to the user's selection of multiple hierarchical dimensions in the electronic form, generate multi-dimensional query conditions, and generate dimension request instructions and multi-dimensional data request instructions based on the multi-dimensional query conditions, and send them to the multi-dimensional data engine; The multidimensional data engine is used to obtain the dimension data corresponding to each dimension in the multidimensional query condition from the data storage system according to the dimension request instruction, obtain and process the multidimensional data according to the multidimensional data request instruction to obtain the multidimensional data operation result, return the dimension data corresponding to each dimension and the multidimensional data operation result to the spreadsheet plug-in to generate a report, and generate a multidimensional analysis table in a specified format based on the multidimensional data operation result and upload it to the data storage system; The data storage system is used to store dimension tables that record dimensional data, fact tables that record multidimensional data, and receive and store multidimensional analysis tables uploaded by the multidimensional data engine.

[0020] The present invention can be applied to scenarios including Excel scenarios, WPS table scenarios, etc., wherein the electronic table can include Excel, WPS table, etc. The data storage system is a production database, which can store dimension tables that record dimensional data, fact tables that record multidimensional data, and can also receive and store multidimensional analysis tables uploaded by a multidimensional data engine. Using the multidimensional data analysis device of the present invention, the user can directly select multiple levels of dimensions on the specified cells of the electronic table, and add them to a specific table area in the form of rows or columns in sequence, and then select the relevant area, "set rows", "set columns", or "set filter items" in sequence, obtain the dimension ID, dimension name, dimension value information (including the ID, Value, hierarchical relationship of the dimension), and sequence number of each dimension, form the query conditions of the multidimensional data, send a request instruction to the multidimensional data engine, the multidimensional data engine recognizes the instruction and parses it, reads the dimensional data and multidimensional data from the pre-processed data storage system, returns the dimensional data to the electronic table plug-in to form a report template, and the multidimensional data undergoes a specified aggregation operation, returns the operation result to the plug-in client, forms a report with the report template, and caches the operation result. If necessary, read the cache to generate a data file in a specified format and upload it to the data storage system for multidimensional analysis.

[0021] It can be seen that the device of the present invention realizes one-stop processing of multidimensional data query, calculation analysis and report generation through automated collaboration between components. Users no longer need to frequently log in to various information systems to query and export data. They only need to select multiple dimensions of requirements in the spreadsheet and initiate a request. The automatic generation of reports and subsequent multidimensional analysis will be realized directly through the interaction of the spreadsheet plug-in, the multidimensional data engine and the data storage system, which reduces complex and frequent multi-system operations and improves the efficiency and convenience of report generation and multidimensional analysis.

[0022] In an optional embodiment of the present invention, the multidimensional data engine includes a dimension metadata database, a dimension data importer, a multidimensional data analyzer, a multidimensional data operator, and a data file generator. Dimension metadata database, used to store dimension metadata obtained by elementization and regularization of dimension data. Dimension metadata includes dimension basic information, dimension hierarchical relationship information, and calculation caliber information; A dimension data importer, used to receive a dimension request instruction of a spreadsheet plug-in, and obtain dimension metadata of the multi-dimensional query condition from a dimension metadata database according to the multi-dimensional query condition recorded in the dimension request instruction, and obtain dimension data corresponding to the multi-dimensional query condition from a dimension table of a data storage system according to the dimension metadata of the multi-dimensional query condition, and return the dimension data to the spreadsheet plug-in to generate a report template; A multidimensional data analyzer, used for receiving a multidimensional data request instruction from a spreadsheet plug-in, parsing the multidimensional data request instruction to obtain a basic dimension, an operation dimension and a multidimensional data operation rule, and inputting the basic dimension, the operation dimension and the multidimensional data operation rule into a multidimensional data operator; The multidimensional data operator is used to read and import the data corresponding to the basic dimension and the operation dimension from the data storage system, and to perform operations using the data corresponding to the basic dimension and the operation dimension according to the multidimensional data operation rules to obtain the multidimensional data operation result, and return the multidimensional data operation result to the electronic form plug-in to generate a report in combination with the report template; The data file generator is used to read the multidimensional data operation results and generate a multidimensional analysis table in a specified format based on the multidimensional data operation results, and upload it to the data storage system.

[0023] Reference Figure 2 The multidimensional data engine of this embodiment is composed of a dimensional metadata database, a dimensional data importer, a multidimensional data analyzer, a multidimensional data operator, and a data file generator.

[0024] This embodiment elementizes and regularizes the related attributes of the dimension and stores them in the dimension metadata database. As an important part of the dimension engine, the dimension metadata database provides strong support for dimension processing. By storing the basic information of the dimension, the hierarchical relationship and the calculation rules, users can ensure that the data standards are unified and reusable.

[0025] The dimension metadata database stores dimension information, dimension hierarchical relationships, calculation caliber and other related dimension metadata.

[0026] 1) Dimension information table: saves basic information of dimensions.

[0027] Table 2 Dimension information table structure

[0028] 2) Dimension hierarchy table: saves the hierarchical relationship of dimensions.

[0029] Table 3 Dimensional hierarchy table structure

[0030] The dimension data importer receives a request instruction for a certain dimension from the spreadsheet plug-in, reads the metadata related to the dimension for parsing, obtains dimension related information (such as dimension basic information, dimension hierarchical relationship information, etc.), and then obtains the corresponding dimension data from the dimension table of the data storage system through the dimension related information, and returns the dimension data to the spreadsheet plug-in to form a report template. The dimension data importer dynamically associates metadata and dimension table data based on user requests, realizes accurate mapping of query conditions and dimension data, and supports the rapid construction of report templates. When the calculation dimension remains unchanged, a new basic dimension can be added without redesigning the report template, which is convenient for user maintenance.

[0031] The multidimensional data analyzer receives the multidimensional data request instruction of the spreadsheet plug-in, parses the multidimensional data request instruction to obtain the basic dimension, operation dimension and multidimensional data operation rules, and inputs the basic dimension, operation dimension and multidimensional data operation rules into the multidimensional data operator. The multidimensional data analyzer analyzes the operation requirements, separates the basic dimension, operation dimension and operation logic, drives the multidimensional data operator to perform operation operations, and completes complex calculations such as cross-level aggregation and multidimensional slicing.

[0032] The multidimensional data operator receives the basic dimensions and operation dimensions output by the multidimensional data analyzer, first reads the data of the corresponding dimension table and fact table of the data storage system according to the required dimensions and imports them into the multidimensional data operator, and then calculates according to the multidimensional data operation rules to finally obtain the multidimensional data operation results. The multidimensional data operator requests only data that meets the query conditions from the production database according to the instructions, reducing unnecessary data transmission. The multidimensional data operator performs aggregation operations on the returned data, and then forms a report as the input of the report template.

[0033] The data file generator reads the multidimensional data operation results or customized report data in the cache, generates a data file in a specified format and uploads it to the data storage system. The data file generator automatically converts the operation results into a standardized multidimensional analysis table to achieve the structuring of the analysis results for multidimensional analysis.

[0034] It can be seen that the multidimensional data engine of the present invention builds a full-link closed-loop processing mechanism for multidimensional data analysis and report generation through the synergy of the dimensional metadata database, dimensional data importer, multidimensional data analyzer, multidimensional data operator, and data file generator, so that users do not need to perform complex and frequent multi-system operations.

[0035] In an optional embodiment of the present invention, the dimension data importer includes a first instruction recognition module, a dimension parsing module and a dimension data importing module. A first instruction recognition module is used to recognize a dimension data acquisition instruction from various request instructions sent by the electronic form plug-in, and convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to a first preset interface specification format, and input the standard dimension data acquisition instruction into a dimension parsing module; A dimension parsing module, used to read the dimension metadata of the multi-dimensional query condition from the dimension metadata database according to the multi-dimensional query condition recorded in the standard dimension data acquisition instruction, and input the dimension metadata into the dimension data import module; The dimension data import module is used to read and import the dimension data corresponding to the multi-dimensional query conditions from the dimension table of the data storage system according to the dimension metadata of the multi-dimensional query conditions, and send the dimension data corresponding to the multi-dimensional query conditions to the electronic spreadsheet plug-in.

[0036] Reference Figure 3 The dimension data importer of this embodiment includes an instruction recognition module, a dimension parsing module and a dimension data importing module, which are as follows: 1) Command recognition module The instruction recognition module receives various instructions sent by the spreadsheet plug-in, identifies the dimension request instruction, and converts the format according to the internal interface specification as the input of the dimension parsing module.

[0037] 2) Dimensional analysis module The dimension parsing module reads and parses the dimension from the dimension metadata database according to the dimension request instruction sent by the instruction recognition module, and obtains the dimension related information (including dimension basic information and dimension hierarchical relationship information) as the input of the dimension data import module.

[0038] 3) Dimension data import module The dimension data import module obtains and imports the corresponding dimension data from the dimension table of the data storage system based on the input dimension related information.

[0039] In an optional embodiment of the present invention, the multidimensional data analyzer includes a second instruction recognition module and a multidimensional data request instruction parsing module. A second instruction recognition module, used to recognize a multidimensional data request instruction from the request instruction sent by the electronic form plug-in, and convert the multidimensional data request instruction into a standard multidimensional data request instruction according to a second preset interface specification format, and input the standard multidimensional data request instruction into the multidimensional data request instruction parsing module; The multidimensional data request instruction parsing module is used to parse the standard multidimensional data request instruction to obtain the basic dimension, operation dimension and multidimensional data operation rules, and input the basic dimension, operation dimension and multidimensional data operation rules into the multidimensional data operator.

[0040] Reference Figure 4 The multidimensional data analyzer of this embodiment includes an instruction recognition module and a multidimensional data request instruction parsing module, which are as follows: 1) Command recognition module Receive various instructions sent by the spreadsheet plug-in, identify the multidimensional data request instructions, and convert the format according to the internal interface specification as the input of the multidimensional data request instruction parsing module.

[0041] 2) Multidimensional data request instruction parsing module The multidimensional data request instruction parsing module parses the multidimensional data request instruction sent by the instruction recognition module to obtain the basic dimension, operation dimension and multidimensional data operation rules contained in the multidimensional data request.

[0042] In an optional embodiment of the present invention, the multidimensional data operator includes a multidimensional data import module and a multidimensional data operation module. A multidimensional data import module is used to read data corresponding to basic dimensions and operation dimensions from the dimension table and fact table of the data storage system, and import the data corresponding to the basic dimensions and operation dimensions into the multidimensional data operation module; The multidimensional data operation module uses the data corresponding to the basic dimension and the operation dimension to perform operations according to the multidimensional data operation rules to obtain the multidimensional data operation results.

[0043] Reference Figure 5 The multidimensional data operator of this embodiment includes a multidimensional data import module and a multidimensional data operation module, which are as follows: 1) Multidimensional data import module The multidimensional data import module reads the data of the corresponding dimension table and wide table of the data storage system according to the basic dimension and operation dimension output by the multidimensional data analyzer, and imports the data into the multidimensional data operator.

[0044] 2) Multidimensional data operation module The multidimensional data operation module reads the basic dimensions and operation dimensions required for multidimensional data operation, and finally obtains the multidimensional data operation result according to the multidimensional data operation rules.

[0045] In an optional embodiment of the present invention, the data file generator includes an analysis data import module, a data conversion module, and a file upload module. An analysis data import module is used to read multidimensional data operation results and / or custom report data, and import the multidimensional data operation results and / or custom report data into a data conversion module; A data conversion module, used to convert multidimensional data operation results and / or custom report data into a multidimensional analysis table in a specified format; The file upload module is used to upload the multidimensional analysis tables corresponding to the multidimensional data operation results and / or the custom report data to the data storage system.

[0046] Reference Figure 6 The data file generator of this embodiment includes an analysis data import module, a data conversion module and a file upload module, which are as follows: 1) Analysis data import module The analytical data import module reads the multidimensional data operation results or customized report data in the cache and imports them into the data conversion module.

[0047] 2) Data conversion module The data conversion module receives multidimensional data operation results or custom report data and generates corresponding data files according to the specified format.

[0048] 3) File upload File upload uploads the data files generated by the data conversion module to the data storage system.

[0049] It can be seen that through the multidimensional data engine of this embodiment, the multidimensional data calculation results can be converted into multidimensional analysis tables, the custom report data can be converted into specified data files, and both can be uploaded to the data storage system for multidimensional analysis. The diversified report data presentation forms can meet the various personalized needs of users.

[0050] In an optional embodiment of the present invention, the multidimensional data engine is also used to receive and execute a drill-down request instruction of a spreadsheet plug-in, expand the data of the next level of a certain dimension in the form of rows or columns, and receive and execute a drill-up request instruction of a spreadsheet plug-in, collapse the data of the same level of a certain dimension in the form of rows or columns.

[0051] For the generated reports and multidimensional analysis tables, this embodiment supports drilling down to expand the data of the next level of a certain dimension in the form of rows or columns, and supports drilling up to collapse the data of the same level of a certain dimension in the form of rows or columns, so that the display of multidimensional table data is more layered.

[0052] Specifically, the user can select the dimension of the specified cell to drill down / up, form a request instruction to obtain the next level / previous level data of the dimension and send it to the multidimensional data engine. After receiving the instruction, the multidimensional data engine applies for the required data from the production database, and then returns the dimension drill-down / drill-up data after calculation by the multidimensional data engine, and presents the report data in the form of rows or columns.

[0053] In an optional embodiment of the present invention, the data storage system is a relational database or a distributed database or a distributed file system.

[0054] It can be seen that the present invention supports the use of relational database / distributed database / distributed file system as the data storage system, and can flexibly select relational database, distributed database or distributed file system based on actual scenario requirements, which not only supports the efficient management of structured dimension tables and fact tables, but also can adapt to the needs of massive data storage, high concurrent access and horizontal expansion. The multidimensional data engine seamlessly adapts to different types of storage systems through standardized interfaces to ensure the full process compatibility of metadata analysis, data loading and calculation result return.

[0055] As an example of the present invention, the financial statistical analysis report supports the construction of multidimensional reports by selecting multiple dimensions including currency, time, organization, column, product, project, etc., and performs flexible statistical analysis through drilling up / down in hierarchical relationships. When other dimensions remain unchanged, choose to change one dimension to query the general ledger data (measurement value), and support real-time calculation according to the statistical caliber formula during retrieval. The financial statistical analysis report supports the display of data in multiple dimensions, such as: 1) Currency dimension, including three categories: original currency (more than 130 kinds), summary RMB, and summary US dollars. The currency amount is converted and summarized according to the exchange rate and calculation formula. 2) Time dimension, the time dimension supports annual, quarterly, and first, middle, and last ten days of the week. 3) Institutional dimension, data and FTU data can be summarized by institutions at all levels, and statistics can be performed according to the following rules: a) Institutional summary = non-FTU data + FTU data, b) Provincial summary = Guangzhou area + key lines + non-key lines. 4) Column dimension, including 8 categories: debit balance, credit balance, cumulative debit amount, cumulative credit amount, monthly average debit balance, monthly average credit balance, annual average debit balance, and annual average credit balance. 5) Product dimension, products come from the general ledger product code table, and there are more than 700 products. 6) Project dimension, a total of nearly 4,000 items, divided into three categories: exchange rate, profit and loss statement, and accounting subjects. The various levels of the project are summarized according to the hierarchical relationship and calculation formula.

[0056] Based on the same inventive concept, another embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory, wherein the processor executes the computer program to load the multidimensional data analysis device as described in any one of the embodiments of the present invention.

[0057] Specifically, the electronic device includes: a memory and a processor, the memory and the processor are connected via a bus communication, the memory stores a computer program, the computer program can be run on the processor, and then loads the multidimensional data analysis device described in any one of the first aspects of the embodiments of the present invention.

[0058] The memory may include a random access memory (RAM) or a non-volatile memory, such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.

[0059] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.

[0060] Based on the same inventive concept, another embodiment of the present invention provides a computer-readable storage medium having a computer program / instruction stored thereon. When the computer program / instruction is executed by a processor, it loads the multidimensional data analysis device as described in any one of the first aspects of the embodiments of the present invention.

[0061] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0062] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, devices, electronic devices, storage media or computer program products. Therefore, embodiments of the present invention may take the form of complete hardware embodiments, complete software embodiments, or embodiments combining software and hardware. Moreover, embodiments of the present invention may take the form of computer program products implemented on one or more computer-usable storage media (including but not limited to disk storage, CD ROM, optical storage, etc.) containing computer-usable program codes.

[0063] Although the embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the claims and their equivalents.

[0064] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or terminal device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or terminal device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the elements.

[0065] The above is a detailed introduction to a multidimensional data analysis device, an electronic device and a readable storage medium provided by the present invention. Specific examples are used herein to illustrate the principles and implementation methods of the present application. The description of the above embodiments is only used to help understand the method and its core idea of ​​the present application. At the same time, for those of ordinary skill in the art, according to the idea of ​​the present application, there will be changes in the specific implementation methods and application scopes. In summary, the content of this specification should not be understood as a limitation on the present application. The above embodiments are only preferred embodiments cited to fully illustrate the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or changes made by those skilled in the art on the basis of the present invention are all within the protection scope of the present invention.

Claims

1. A multidimensional data analysis device, characterized in that: The multidimensional data analysis device includes a spreadsheet plug-in, a multidimensional data engine, and a data storage system. The electronic form plug-in is used to respond to the user's selection of multiple hierarchical dimensions in the electronic form, generate multi-dimensional query conditions, and generate dimension request instructions and multi-dimensional data request instructions based on the multi-dimensional query conditions, and send them to the multi-dimensional data engine; The multidimensional data engine is used to obtain the dimension data corresponding to each dimension in the multidimensional query condition from the data storage system according to the dimension request instruction, obtain and process the multidimensional data according to the multidimensional data request instruction to obtain the multidimensional data operation result, return the dimension data corresponding to each dimension and the multidimensional data operation result to the spreadsheet plug-in to generate a report, and generate a multidimensional analysis table in a specified format based on the multidimensional data operation result and upload it to the data storage system; The data storage system is used to store dimension tables that record dimensional data, fact tables that record multidimensional data, and receive and store multidimensional analysis tables uploaded by the multidimensional data engine.

2. The multidimensional data analysis device according to claim 1, characterized in that: The multidimensional data engine includes a dimension metadata database, a dimension data importer, a multidimensional data analyzer, a multidimensional data operator, and a data file generator. Dimension metadata database, used to store dimension metadata obtained by elementization and regularization of dimension data. Dimension metadata includes dimension basic information, dimension hierarchical relationship information, and calculation caliber information; A dimension data importer, used to receive a dimension request instruction of a spreadsheet plug-in, and obtain dimension metadata of the multi-dimensional query condition from a dimension metadata database according to the multi-dimensional query condition recorded in the dimension request instruction, and obtain dimension data corresponding to the multi-dimensional query condition from a dimension table of a data storage system according to the dimension metadata of the multi-dimensional query condition, and return the dimension data to the spreadsheet plug-in to generate a report template; A multidimensional data analyzer, used for receiving a multidimensional data request instruction from a spreadsheet plug-in, parsing the multidimensional data request instruction to obtain a basic dimension, an operation dimension and a multidimensional data operation rule, and inputting the basic dimension, the operation dimension and the multidimensional data operation rule into a multidimensional data operator; The multidimensional data operator is used to read and import the data corresponding to the basic dimension and the operation dimension from the data storage system, and to perform operations using the data corresponding to the basic dimension and the operation dimension according to the multidimensional data operation rules to obtain the multidimensional data operation result, and return the multidimensional data operation result to the electronic form plug-in to generate a report in combination with the report template; The data file generator is used to read the multidimensional data operation results and generate a multidimensional analysis table in a specified format based on the multidimensional data operation results, and upload it to the data storage system.

3. The multidimensional data analysis device according to claim 2, characterized in that: The dimension data importer includes a first instruction recognition module, a dimension parsing module and a dimension data importing module. A first instruction recognition module is used to recognize a dimension data acquisition instruction from various request instructions sent by the electronic form plug-in, and convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to a first preset interface specification format, and input the standard dimension data acquisition instruction into a dimension parsing module; A dimension parsing module, used to read the dimension metadata of the multi-dimensional query conditions from the dimension metadata database according to the multi-dimensional query conditions recorded in the standard dimension data acquisition instruction, and input the dimension metadata into the dimension data import module; The dimension data import module is used to read and import the dimension data corresponding to the multi-dimensional query conditions from the dimension table of the data storage system according to the dimension metadata of the multi-dimensional query conditions, and send the dimension data corresponding to the multi-dimensional query conditions to the electronic spreadsheet plug-in.

4. The multidimensional data analysis device according to claim 2, characterized in that: The multidimensional data analyzer includes a second instruction recognition module and a multidimensional data request instruction parsing module. A second instruction recognition module, used to recognize a multidimensional data request instruction from the request instruction sent by the electronic form plug-in, and convert the multidimensional data request instruction into a standard multidimensional data request instruction according to a second preset interface specification format, and input the multidimensional data request instruction into the multidimensional data request instruction parsing module; The multidimensional data request instruction parsing module is used to parse the standard multidimensional data request instruction to obtain the basic dimension, operation dimension and multidimensional data operation rules, and input the basic dimension, operation dimension and multidimensional data operation rules into the multidimensional data operator.

5. The multidimensional data analysis device according to claim 2, characterized in that: The multidimensional data operator includes a multidimensional data import module and a multidimensional data operation module. A multidimensional data import module is used to read data corresponding to basic dimensions and operation dimensions from the dimension table and fact table of the data storage system, and import the data corresponding to the basic dimensions and operation dimensions into the multidimensional data operation module; The multidimensional data operation module uses the data corresponding to the basic dimension and the operation dimension to perform operations according to the multidimensional data operation rules to obtain the multidimensional data operation results.

6. The multidimensional data analysis device according to claim 2, characterized in that: The data file generator includes an analysis data import module, a data conversion module, and a file upload module. An analysis data import module is used to read multidimensional data operation results and / or custom report data, and import the multidimensional data operation results and / or custom report data into a data conversion module; A data conversion module, used to convert multidimensional data operation results and / or custom report data into a multidimensional analysis table in a specified format; The file upload module is used to upload the multidimensional analysis tables corresponding to the multidimensional data operation results and / or the custom report data to the data storage system.

7. The multidimensional data analysis device according to claim 1 or 6, characterized in that: The multidimensional data engine is also used to receive and execute the drill-down request instructions of the spreadsheet plug-in, expand the data of the next level of a certain dimension in the form of rows or columns, and receive and execute the drill-up request instructions of the spreadsheet plug-in, collapse the data of the same level of a certain dimension in the form of rows or columns.

8. The multidimensional data analysis device according to claim 1, characterized in that: The data storage system is a relational database or a distributed database or a distributed file system.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the electronic device executes the computer program, the multidimensional data analysis device according to any one of claims 1 to 8 is loaded.

10. A readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the multidimensional data analysis device according to any one of claims 1 to 8 is loaded.

Images