A Multidimensional Data Analysis Device, an Electronic Device, and a Readable Storage Medium

Abstract

The present invention provides a multi-dimensional data analysis device, an electronic device, and a readable storage medium. After the spreadsheet plug-in receives the hierarchical dimensions selected by the user, it automatically generates multi-dimensional query conditions and triggers a dimension request instruction and a multi-dimensional data request instruction to the multi-dimensional data engine. The multi-dimensional data engine retrieves the dimension data in the dimension table from the data storage system according to the instructions, and at the same time processes the multi-dimensional data in the fact table to generate an operation result, returns the two to the spreadsheet plug-in to generate a report, and generates a multi-dimensional analysis table and sends it back to the storage system for archiving. Through the automated collaboration between components, the device realizes one-stop processing of multi-dimensional data query, calculation analysis, and report generation. The user only needs to select multiple dimensions required in the spreadsheet and initiate a request, and the report will be automatically generated and subsequent multi-dimensional analysis will be directly realized through the interaction of the three components, reducing complex and frequent multi-system operations and improving the efficiency and convenience of report generation and multi-dimensional analysis.

Description

Technical Field

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

[0002] Spreadsheets have become essential tool software for daily office work in many industries. Users have certain basic knowledge and usage experience, and have also accumulated a large number of work-related tables. However, enterprise business data is usually stored in different databases. Users usually have to log in to various information systems frequently to query data, export the query results to spreadsheets to form reports, or directly fill in the data in spreadsheets. Every time for statistical reporting or analysis, the same process has to be repeated, resulting in low efficiency. Moreover, the existing multi-dimensional tables on the market also have the following defects:

[0003] 1) It does not support dimension drilling up and down, and the display form of report data is single.

[0004] 2) It does not support customizing report data or importing and analyzing the generated multi-dimensional data. Summary of the Invention

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

[0006] The present invention provides a multi-dimensional data analysis device, which includes a spreadsheet plugin, a multi-dimensional data engine, and a data storage system.

[0007] The spreadsheet plugin is used to respond to the user's selection of multiple hierarchical dimensions in the spreadsheet, generate multi-dimensional query conditions, and generate a dimension request instruction and a multi-dimensional data request instruction based on the multi-dimensional query conditions, and send them to the multi-dimensional data engine.

[0008] The multi-dimensional data engine is used to obtain the dimension data corresponding to each dimension in the multi-dimensional query conditions from the data storage system according to the dimension request instruction, obtain and process the multi-dimensional data according to the multi-dimensional data request instruction to obtain a multi-dimensional data operation result, return the dimension data corresponding to each dimension and the multi-dimensional data operation result to the spreadsheet plugin to generate a report, and generate a multi-dimensional analysis table in a specified format based on the multi-dimensional data operation result and upload it to the data storage system.

[0009] The data storage system is used to store a dimension table recording dimension data, a fact table recording multi-dimensional data, and receive and store the multi-dimensional analysis table uploaded by the multi-dimensional data engine.

[0010] Optionally, the multi-dimensional data engine includes a dimension meta-database, a dimension data importer, a multi-dimensional data analyzer, a multi-dimensional data operator, and a data file generator.

[0011] The dimension meta-database is used to store dimension metadata obtained by elementizing and regularizing dimension data. The dimension metadata includes dimension basic information, dimension hierarchy relationship information, and calculation caliber information.

[0012] The dimension data importer is used to receive the dimension request instruction of the spreadsheet plug-in, obtain the dimension metadata of the multi-dimensional query condition from the dimension meta-database according to the multi-dimensional query condition recorded in the dimension request instruction, and obtain the dimension data corresponding to the multi-dimensional query condition from the dimension table of the 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.

[0013] The multi-dimensional data analyzer is used to receive the multi-dimensional data request instruction of the spreadsheet plug-in, parse the multi-dimensional data request instruction to obtain the basic dimension, operation dimension, and multi-dimensional data operation rule, and input the basic dimension, operation dimension, and multi-dimensional data operation rule into the multi-dimensional data operator.

[0014] The multi-dimensional data operator is used to read and import the data corresponding to the basic dimension and operation dimension from the data storage system, and perform operations on the data corresponding to the basic dimension and operation dimension according to the multi-dimensional data operation rule to obtain the multi-dimensional data operation result, and return the multi-dimensional data operation result to the spreadsheet plug-in to combine with the report template to generate a report.

[0015] The data file generator is used to read the multi-dimensional data operation result and generate a multi-dimensional analysis table in a specified format based on the multi-dimensional data operation result, and upload it to the data storage system.

[0016] Optionally, the dimension data importer includes a first instruction recognition module, a dimension parsing module, and a dimension data import module.

[0017] The first instruction recognition module is used to recognize the dimension data acquisition instruction from various request instructions sent by the spreadsheet plug-in, convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to the first preset interface specification format, and input it into the dimension parsing module.

[0018] The dimension parsing module is used to read the dimension metadata of the multi-dimensional query condition from the dimension meta-database according to the multi-dimensional query condition recorded in the standard dimension data acquisition instruction, and input it into the dimension data import module.

[0019] A dimension data import module, which is used to read and import dimension data corresponding to 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 spreadsheet plug-in.

[0020] Optionally, the multi-dimensional data analyzer includes a second instruction recognition module and a multi-dimensional data request instruction parsing module.

[0021] The second instruction recognition module is used to recognize the multi-dimensional data request instruction from the request instruction sent by the spreadsheet plug-in, convert the multi-dimensional data request instruction into a standard multi-dimensional data request instruction according to the second preset interface specification format, and input it into the multi-dimensional data request instruction parsing module.

[0022] The multi-dimensional data request instruction parsing module is used to parse the standard multi-dimensional data request instruction to obtain the basic dimension, operation dimension and multi-dimensional data operation rule, and input the basic dimension, operation dimension and multi-dimensional data operation rule into the multi-dimensional data operator.

[0023] Optionally, the multi-dimensional data operator includes a multi-dimensional data import module and a multi-dimensional data operation module.

[0024] The multi-dimensional data import module is used to read the data corresponding to the basic dimension and operation dimension from the dimension table and fact table of the data storage system, and import the data corresponding to the basic dimension and operation dimension into the multi-dimensional data operation module.

[0025] The multi-dimensional data operation module performs operations on the data corresponding to the basic dimension and operation dimension according to the multi-dimensional data operation rule to obtain the multi-dimensional data operation result.

[0026] Optionally, the data file generator includes an analysis data import module, a data conversion module and a file upload module.

[0027] The analysis data import module is used to read the multi-dimensional data operation result and / or custom report data, and import the multi-dimensional data operation result and / or custom report data into the data conversion module.

[0028] The data conversion module is used to convert the multi-dimensional data operation result and / or custom report data into a multi-dimensional analysis table in a specified format.

[0029] The file upload module is used to upload the multi-dimensional analysis tables corresponding to the multi-dimensional data operation result and / or custom report data to the data storage system.

[0030] Optionally, the multi-dimensional data engine is further configured to receive and execute a drill-down request instruction of a spreadsheet plug-in to expand data at the next level of a certain dimension in the form of rows or columns, and receive and execute a roll-up request instruction of the spreadsheet plug-in to collapse data at the same level of a certain dimension in the form of rows or columns.

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

[0032] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the electronic device executes the computer program, it loads the multi-dimensional data analysis device according to any one of the embodiments of the present invention.

[0033] The present invention also provides a readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it loads the multi-dimensional data analysis device according to any one of the embodiments of the present invention.

[0034] The present invention has the following advantages:

[0035] The multi-dimensional data analysis device of the present invention is composed of a spreadsheet plug-in, a multi-dimensional data engine, and a data storage system. After the spreadsheet plug-in receives the hierarchical dimension selected by the user, it automatically generates multi-dimensional query conditions and triggers a dimension request instruction and a multi-dimensional data request instruction to the multi-dimensional data engine. The multi-dimensional data engine retrieves dimension data in the dimension table from the data storage system according to the instructions, and at the same time processes the multi-dimensional data in the fact table to generate an operation result, returns the two to the spreadsheet plug-in to generate a report, and uploads the structured multi-dimensional analysis table back to the storage system for archiving. Through the automated cooperation between components, the device realizes one-stop processing of multi-dimensional data query, calculation analysis, and report generation. Users no longer need to frequently log in to each information system to query and export data. They only need to select multiple dimensions of requirements in the spreadsheet and initiate a request, and the report will be automatically generated directly through the interaction of the spreadsheet plug-in, the multi-dimensional data engine, and the data storage system, and subsequent multi-dimensional analysis will be carried out, reducing complex and frequent multi-system operations and improving the efficiency and convenience of report generation and multi-dimensional analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 is a structural block diagram of a multi-dimensional data analysis device provided by an embodiment of the present invention;

[0037] Figure 2 is a structural block diagram of a multi-dimensional data engine provided by an embodiment of the present invention;

[0038] Figure 3 is a structural block diagram of a dimension data importer provided by an embodiment of the present invention;

[0039] Figure 4 It is a structural block diagram of a multi - dimensional data analyzer provided by an embodiment of the present invention;

[0040] Figure 5 It is a structural block diagram of a multi - dimensional data arithmetic unit provided by an embodiment of the present invention;

[0041] Figure 6 It is a structural block diagram of a data file generator provided by an embodiment of the present invention. Specific Embodiments

[0042] The following are the relevant glossary explanations of the present invention:

[0043] Table 1 Glossary Explanation of the Present Invention

[0044]

[0045] To make the above - mentioned objects, features, and advantages of the present invention more obvious and understandable, the present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.

[0046] Refer to Figure 1 , which shows a structural block diagram of a multi - dimensional data analysis device provided by an embodiment of the present invention. Specifically, it may include the following modules:

[0047] A spreadsheet plug - in, which is used to respond to the user's selection of multiple hierarchical dimensions in the spreadsheet, generate multi - dimensional query conditions, and generate a dimension request instruction and a multi - dimensional data request instruction based on the multi - dimensional query conditions, and send them to the multi - dimensional data engine;

[0048] A multi - dimensional data engine, which is used to obtain the dimension data corresponding to each dimension in the multi - dimensional query conditions from the data storage system according to the dimension request instruction, obtain and process the multi - dimensional data according to the multi - dimensional data request instruction to obtain a multi - dimensional data operation result, return the dimension data corresponding to each dimension and the multi - dimensional data operation result to the spreadsheet plug - in to generate a report, and generate a multi - dimensional analysis table in a specified format and upload it to the data storage system;

[0049] A data storage system, which is used to store the dimension table recording the dimension data, the fact table recording the multi - dimensional data, and receive and store the multi - dimensional analysis table uploaded by the multi - dimensional data engine.

[0050] Scenarios where the present invention can be applied include Excel scenarios, WPS spreadsheet scenarios, etc. Among them, the spreadsheet can include Excel, WPS spreadsheet, etc. The data storage system is a production database, which can store dimension tables recording dimension data, fact tables recording multi-dimensional data, and can also receive and store multi-dimensional analysis tables uploaded by the multi-dimensional data engine. Using the multi-dimensional data analysis device of the present invention, the user can directly select multiple levels of dimensions on the specified cells of the spreadsheet, and add them to a specific table area in the form of rows or columns in sequence. Then, select the relevant area and perform "set row", "set column", or "set filter items" in sequence to obtain the dimension ID, dimension name, dimension value information (including the ID, Value, and hierarchical relationship of the dimension), and serial number of each dimension, constituting the query conditions for multi-dimensional data. Send a request instruction to the multi-dimensional data engine. The multi-dimensional data engine recognizes and parses the instruction, reads the dimension data and multi-dimensional data from the pre-processed data storage system, returns the dimension data to the spreadsheet plug-in to form a report template. The multi-dimensional data undergoes specified aggregation operations, and the operation results are returned to the plug-in client, forming a report with the report template. At the same time, the operation results are cached. When necessary, the cached data is read to generate a data file in a specified format and uploaded to the data storage system for multi-dimensional analysis.

[0051] It can be seen that through the automated collaboration among components, the device of the present invention realizes one-stop processing of multi-dimensional data query, calculation analysis, and report generation. Users no longer need to frequently log in to various information systems to query and export data. They only need to select multiple dimensions required in the spreadsheet and initiate a request, and the report will be automatically generated directly through the interaction of the spreadsheet plug-in, multi-dimensional data engine, and data storage system, and subsequent multi-dimensional analysis will be carried out, reducing complex and frequent multi-system operations, and improving the efficiency and convenience of report generation and multi-dimensional analysis.

[0052] In an alternative embodiment of the present invention, the multi-dimensional data engine includes a dimension metadata database, a dimension data importer, a multi-dimensional data analyzer, a multi-dimensional data operator, and a data file generator.

[0053] The dimension metadata database is used to save the dimension metadata obtained by elementizing and regularizing dimension data. The dimension metadata includes dimension basic information, dimension hierarchical relationship information, and calculation caliber information.

[0054] The dimension data importer is used to receive the dimension request instruction from the spreadsheet plug-in, obtain the dimension metadata of the multi-dimensional query condition from the dimension metadata database according to the multi-dimensional query condition recorded in the dimension request instruction, and obtain the dimension data corresponding to the multi-dimensional query condition from the dimension table of the 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.

[0055] A multi-dimensional data analyzer is used to receive multi-dimensional data request instructions from a spreadsheet plugin, parse the multi-dimensional data request instructions to obtain basic dimensions, operation dimensions, and multi-dimensional data operation rules, and input the basic dimensions, operation dimensions, and multi-dimensional data operation rules into a multi-dimensional data operator;

[0056] A multi-dimensional data operator is used to read and import data corresponding to the basic dimensions and operation dimensions from a data storage system, and perform operations using the data corresponding to the basic dimensions and operation dimensions according to the multi-dimensional data operation rules to obtain a multi-dimensional data operation result, and return the multi-dimensional data operation result to the spreadsheet plugin to generate a report in combination with a report template;

[0057] A data file generator is used to read the multi-dimensional data operation result and generate a multi-dimensional analysis table in a specified format based on the multi-dimensional data operation result, and upload it to the data storage system.

[0058] Refer to Figure 2 In this embodiment, the multi-dimensional data engine is composed of a dimension meta-database, a dimension data importer, a multi-dimensional data analyzer, a multi-dimensional data operator, and a data file generator.

[0059] In this embodiment, the relevant attributes of the dimension are elementized and regularized, and stored in the dimension meta-database. As an important part of the dimension engine, the dimension meta-database provides strong support for dimension processing. By storing the basic information, hierarchical relationship, and calculation rules of the dimension, users can ensure the unity and reusability of data standards.

[0060] The dimension meta-database stores relevant dimension metadata such as dimension information, dimension hierarchical relationship, and calculation caliber.

[0061] 1) Dimension information table: Save the basic information of the dimension.

[0062] Table 2 Dimension information table structure

[0063]

[0064] 2) Dimension hierarchy table: Save the hierarchical relationship of the dimension.

[0065] Table 3 Dimension hierarchy table structure

[0066]

[0067] The dimension data importer receives a request instruction for a certain dimension sent by the spreadsheet plugin, reads and parses the metadata related to this dimension to obtain dimension-related information (such as dimension basic information, dimension hierarchy relationship information, etc.), 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 plugin to form a report template. The dimension data importer dynamically associates the metadata with the dimension table data based on the user request, realizes the accurate mapping between the query conditions and the dimension data, and supports the rapid construction of the report template. When the calculation dimensions remain unchanged, adding a new basic dimension does not require re-designing the report template, which is convenient for users to maintain.

[0068] The multi-dimensional data analyzer receives the multi-dimensional data request instruction from the spreadsheet plugin, and parses the multi-dimensional data request instruction to obtain the basic dimension, calculation dimension, and multi-dimensional data operation rules, and inputs the basic dimension, calculation dimension, and multi-dimensional data operation rules into the multi-dimensional data operator. The multi-dimensional data analyzer separates the basic dimension, calculation dimension, and operation logic by parsing the operation requirements, and drives the multi-dimensional data operator to execute the operation to complete complex calculations such as cross-level aggregation and multi-dimensional slicing.

[0069] The multi-dimensional data operator receives the basic dimension and calculation dimension output by the multi-dimensional data analyzer. First, it reads the data of the corresponding dimension table and fact table in the data storage system according to the required dimensions and imports them into the multi-dimensional data operator, and then calculates according to the multi-dimensional data operation rules to finally obtain the multi-dimensional data operation result. The multi-dimensional data operator requests only the data that meets the query conditions from the production database according to the instruction, reducing unnecessary data transmission. The multi-dimensional data operator performs aggregation operations on the returned data and then uses it as the input of the report template to form a report.

[0070] The data file generator reads the multi-dimensional data operation result or custom report data in the cache, generates a data file in the specified format and uploads it to the data storage system. The data file generator automatically converts the operation result into a standardized multi-dimensional analysis table to realize the structuring of the analysis results for multi-dimensional analysis.

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

[0072] 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 import module.

[0073] The first instruction recognition module is used to recognize the dimension data acquisition instruction from various request instructions sent by the spreadsheet plug-in, convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to the first preset interface specification format, and input it into the dimension parsing module;

[0074] The dimension parsing module is 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 it into the dimension data import module;

[0075] The dimension data import module is used to read and import the dimension data corresponding to the multi-dimensional query condition from the dimension table of the data storage system according to the dimension metadata of the multi-dimensional query condition, and send the dimension data corresponding to the multi-dimensional query condition to the spreadsheet plug-in.

[0076] Refer to Figure 3 , the dimension data importer of this embodiment includes an instruction recognition module, a dimension parsing module and a dimension data import module, specifically as follows:

[0077] 1) Instruction recognition module

[0078] The instruction recognition module receives various instructions sent by the spreadsheet plug-in, recognizes the dimension request instruction, and performs format conversion according to the internal interface specification as the input of the dimension parsing module.

[0079] 2) Dimension parsing module

[0080] 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 information related to the dimension (including dimension basic information, dimension hierarchy relationship information) as the input of the dimension data import module.

[0081] 3) Dimension data import module

[0082] The dimension data import module combines the input dimension-related information to obtain and import the corresponding dimension data from the dimension table of the data storage system.

[0083] In an alternative embodiment of the present invention, the multi-dimensional data analyzer includes a second instruction recognition module and a multi-dimensional data request instruction parsing module,

[0084] The second instruction recognition module is used to recognize the multi-dimensional data request instruction from the request instructions sent by the spreadsheet plug-in, convert the multi-dimensional data request instruction into a standard multi-dimensional data request instruction according to the second preset interface specification format, and input it into the multi-dimensional data request instruction parsing module;

[0085] The multi-dimensional data request instruction parsing module is used to parse the standard multi-dimensional data request instruction to obtain the basic dimension, operation dimension, and multi-dimensional data operation rule, and input the basic dimension, operation dimension, and multi-dimensional data operation rule into the multi-dimensional data arithmetic unit.

[0086] Refer to Figure 4 , the multi-dimensional data analyzer of this embodiment includes an instruction recognition module and a multi-dimensional data request instruction parsing module, specifically as follows:

[0087] 1) Instruction recognition module

[0088] Receives various instructions sent by the spreadsheet plug-in, identifies the multi-dimensional data request instruction, and performs format conversion according to the internal interface specification, as the input of the multi-dimensional data request instruction parsing module.

[0089] 2) Multi-dimensional data request instruction parsing module

[0090] The multi-dimensional data request instruction parsing module parses the multi-dimensional data request instruction sent by the instruction recognition module to obtain the basic dimension, operation dimension, and multi-dimensional data operation rule included in the multi-dimensional data request.

[0091] In an alternative embodiment of the present invention, the multi-dimensional data arithmetic unit includes a multi-dimensional data import module and a multi-dimensional data operation module.

[0092] The multi-dimensional data import module is used to read the data corresponding to the basic dimension and operation dimension from the dimension table and fact table of the data storage system, and import the data corresponding to the basic dimension and operation dimension into the multi-dimensional data operation module;

[0093] The multi-dimensional data operation module performs operations using the data corresponding to the basic dimension and operation dimension according to the multi-dimensional data operation rule to obtain the multi-dimensional data operation result.

[0094] Refer to Figure 5 , the multi-dimensional data arithmetic unit of this embodiment includes a multi-dimensional data import module and a multi-dimensional data operation module, specifically as follows:

[0095] 1) Multi-dimensional data import module

[0096] The multi-dimensional 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 multi-dimensional data analyzer, and imports it into the multi-dimensional data arithmetic unit.

[0097] 2) Multi-dimensional data operation module

[0098] The multi-dimensional data operation module reads the basic dimension and operation dimension required for the multi-dimensional data operation, and finally obtains the multi-dimensional data operation result according to the multi-dimensional data operation rule.

[0099] In an alternative embodiment of the present invention, the data file generator includes an analysis data import module, a data conversion module, and a file upload module.

[0100] The analysis data import module is configured to read the multi-dimensional data operation results and / or custom report data, and import the multi-dimensional data operation results and / or custom report data into the data conversion module.

[0101] The data conversion module is configured to convert the multi-dimensional data operation results and / or custom report data into a multi-dimensional analysis table in a specified format.

[0102] The file upload module is configured to upload the multi-dimensional analysis tables corresponding to the multi-dimensional data operation results and / or custom report data to the data storage system.

[0103] Referring to Figure 6 , the data file generator of this embodiment includes an analysis data import module, a data conversion module, and a file upload module, specifically as follows:

[0104] 1) Analysis data import module

[0105] The analysis data import module reads the multi-dimensional data operation results or custom report data in the cache and imports them into the data conversion module.

[0106] 2) Data conversion module

[0107] The data conversion module receives the multi-dimensional data operation results or custom report data and generates a corresponding data file according to the specified format.

[0108] 3) File upload

[0109] The file upload uploads the data file generated by the data conversion module to the data storage system.

[0110] It can be seen that through the multi-dimensional data engine of this embodiment, the multi-dimensional data operation results can be converted into a multi-dimensional analysis table, the custom report data can be converted into a specified data file, and both can be uploaded to the data storage system for multi-dimensional analysis, with diverse report data presentation forms to meet various personalized needs of users.

[0111] In an alternative embodiment of the present invention, the multi-dimensional data engine is further configured to receive and execute the drill-down request instruction of the spreadsheet plug-in to expand the data at the next level of a certain dimension in the form of rows or columns, and receive and execute the drill-up request instruction of the spreadsheet plug-in to collapse the data at the same level of a certain dimension in the form of rows or columns.

[0112] For the generated reports and multi-dimensional analysis tables, this embodiment supports drilling down to expand the data at the next level of a certain dimension in the form of rows or columns, and supports drilling up to collapse the data at the same level of a certain dimension in the form of rows or columns, making the display of multi-dimensional table data more hierarchical.

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

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

[0115] It can be seen that the present invention supports using a relational database / distributed database / distributed file system as the data storage system, and can flexibly select a relational database, a distributed database, or a distributed file system based on actual scenario requirements. It not only supports the efficient management of structured dimension tables and fact tables, but also can adapt to the requirements of massive data storage, high-concurrency access, and horizontal expansion. The multi-dimensional data engine is seamlessly adapted to different types of storage systems through a standardized interface, ensuring the full-process compatibility of metadata parsing, data loading, and calculation result feedback.

[0116] As an example of the present invention - the financial statistical analysis report, it supports selecting multiple dimensions including currency, time, institution, column, product, project, etc. to construct a multi-dimensional report, and performs flexible statistical analysis through drilling up / down of the hierarchical relationship. When other dimensions remain unchanged, the general ledger data (measure value) is queried by changing one dimension, and it supports real-time calculation according to the statistical caliber formula during retrieval. The financial statistical analysis report supports displaying data in multiple dimensions, such as: 1) Currency dimension, including original currency (more than 130 kinds in total), aggregated RMB, and aggregated US dollars. The currency amount is converted and aggregated according to the exchange rate and calculation formula. 2) Time dimension, the time dimension supports display in years, quarters, and the first, middle, and last ten days. 3) Institution dimension, data can be aggregated by each level of institution and FTU data, and it supports statistical calculation according to the following rules: a) Institution aggregation = non-FTU data + FTU data; b) Province-wide aggregation = Guangzhou area + key branches + non-key branches. 4) Column dimension, including 8 classifications: debit balance, credit balance, cumulative debit occurrence amount, cumulative credit occurrence amount, average monthly debit balance, average monthly credit balance, average annual debit balance, and average annual credit balance. 5) Product dimension, the products come from the general ledger product code table, and there are more than 700 existing products. 6) Project dimension, there are nearly 4,000 items in total, divided into three categories: exchange rate, profit and loss statement, and accounting subject. The levels of the project are aggregated according to the hierarchical relationship and calculation formula.

[0117] 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 on the memory, and the processor executes the computer program to load the multi-dimensional data analysis device according to any one of the embodiments of the present invention.

[0118] Specifically, the electronic device includes: a memory and a processor. The memory and the processor are communicatively connected via a bus. A computer program is stored in the memory, and the computer program can run on the processor, thereby loading the multi-dimensional data analysis device according to any one of the first aspects of the embodiments of the present invention.

[0119] The memory may include a random access memory (RAM), or may also include 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.

[0120] The above-mentioned processor may be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it may 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.

[0121] Based on the same inventive concept, another embodiment of the present invention provides a computer-readable storage medium, on which a computer program / instructions are stored, and when the computer program / instructions are executed by a processor, the multi-dimensional data analysis device according to any one of the first aspects of the embodiments of the present invention is loaded.

[0122] The embodiments in this specification are all described in a progressive manner. Each embodiment focuses on the differences from other embodiments. The same or similar parts among the embodiments can be referred to each other.

[0123] Those skilled in the art should understand that the embodiments of the present invention can be provided as a method, a device, an electronic device, a storage medium, or a computer program product. Therefore, the embodiments of the present invention can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the embodiments of the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk memory, CD ROM, optical memory, etc.) that contain computer-usable program code.

[0124] Although the embodiments of the present invention have been shown and described, those of ordinary skill in the art can understand that various changes, modifications, substitutions, and variations can be made to these embodiments without departing from the principles and spirit of the present invention. The scope of the present invention is defined by the claims and their equivalents.

[0125] Finally, it should also be noted that in this text, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the term "comprising", "including", or any other variant thereof is intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device comprising a series of elements not only includes those elements but also includes other elements not expressly listed, or further includes elements inherent to such process, method, article, or terminal device. Without further limitation, an element defined by the statement "comprising an..." does not exclude the existence of additional identical elements in the process, method, article, or terminal device comprising the said element.

[0126] The above has introduced in detail a multi-dimensional data analysis device, an electronic device, and a readable storage medium provided by the present invention. Specific examples are used in this text to elaborate on the principles and implementation manners 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 manners and application scopes. In summary, the content of this specification should not be construed as a limitation to the present application. The above embodiments are only the preferred embodiments cited to fully illustrate the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or transformations made by those skilled in the art on the basis of the present invention are within the protection scope of the present invention.

Claims

1. A multi-dimensional data analysis device, characterized in that, The multi-dimensional data analysis device includes a spreadsheet plug-in, a multi-dimensional data engine, and a data storage system. The spreadsheet plug-in is used to respond to the user's selection of multiple hierarchical dimensions in the spreadsheet, generate multi-dimensional query conditions, and generate a dimension request instruction and a multi-dimensional data request instruction based on the multi-dimensional query conditions, and send them to the multi-dimensional data engine. The multi-dimensional data engine is used to obtain the dimension data corresponding to each dimension in the multi-dimensional query conditions from the data storage system according to the dimension request instruction, obtain and process the multi-dimensional data according to the multi-dimensional data request instruction to obtain a multi-dimensional data operation result, return the dimension data corresponding to each dimension and the multi-dimensional data operation result to the spreadsheet plug-in to generate a report, and generate a multi-dimensional analysis table in a specified format based on the multi-dimensional data operation result and upload it to the data storage system. The data storage system is used to store the dimension table recording the dimension data, the fact table recording the multi-dimensional data, and receive and store the multi-dimensional analysis table uploaded by the multi-dimensional data engine. The multi-dimensional data engine includes a dimension meta-database, a dimension data importer, a multi-dimensional data analyzer, a multi-dimensional data operator, and a data file generator. The dimension meta-database is used to save the dimension metadata obtained by elementizing and regularizing the dimension data. The dimension metadata includes dimension basic information, dimension hierarchical relationship information, and calculation caliber information. The dimension data importer is used to receive the dimension request instruction from the spreadsheet plug-in, obtain the dimension metadata of the multi-dimensional query conditions from the dimension meta-database according to the multi-dimensional query conditions recorded in the dimension request instruction, and obtain 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 return the dimension data to the spreadsheet plug-in to generate a report template. The multi-dimensional data analyzer is used to receive the multi-dimensional data request instruction from the spreadsheet plug-in, parse the multi-dimensional data request instruction to obtain the basic dimension, operation dimension, and multi-dimensional data operation rule, and input the basic dimension, operation dimension, and multi-dimensional data operation rule into the multi-dimensional data operator. The multi-dimensional data operator is used to read and import the data corresponding to the basic dimension and operation dimension from the data storage system, and perform operations on the data corresponding to the basic dimension and operation dimension according to the multi-dimensional data operation rule to obtain a multi-dimensional data operation result, and return the multi-dimensional data operation result to the spreadsheet plug-in to generate a report in combination with the report template. The data file generator is used to read the multi-dimensional data operation result and generate a multi-dimensional analysis table in a specified format based on the multi-dimensional data operation result, and upload it to the data storage system.

2. The multi-dimensional data analysis device according to claim 1, wherein The dimension data importer includes a first instruction recognition module, a dimension parsing module, and a dimension data import module. The first instruction recognition module is used to recognize the dimension data acquisition instruction from various request instructions sent by the spreadsheet plug-in, convert the dimension data acquisition instruction into a standard dimension data acquisition instruction according to the first preset interface specification format, and input it into the dimension parsing module. A dimension analysis module, configured to obtain, according to the multi-dimensional query conditions recorded in the instruction based on the standard dimension data, the dimension metadata of the multi-dimensional query conditions from the dimension meta-database, and input it into the dimension data import module; A dimension data import module, configured 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 spreadsheet plug-in.

3. The multi-dimensional data analysis device according to claim 1, wherein The multi-dimensional data analyzer includes a second instruction recognition module and a multi-dimensional data request instruction parsing module. The second instruction recognition module is configured to recognize the multi-dimensional data request instruction from the request instruction sent by the spreadsheet plug-in, convert the multi-dimensional data request instruction into a standard multi-dimensional data request instruction according to the second preset interface specification format, and input it into the multi-dimensional data request instruction parsing module; The multi-dimensional data request instruction parsing module is configured to parse the standard multi-dimensional data request instruction to obtain the basic dimension, the operation dimension, and the multi-dimensional data operation rule, and input the basic dimension, the operation dimension, and the multi-dimensional data operation rule into the multi-dimensional data operator.

4. The multi-dimensional data analysis device according to claim 1, characterized in that The multi-dimensional data operator includes a multi-dimensional data import module and a multi-dimensional data operation module. The multi-dimensional data import module is configured to read the data corresponding to the basic dimension and the operation dimension from the dimension table and the fact table of the data storage system, and import the data corresponding to the basic dimension and the operation dimension into the multi-dimensional data operation module; The multi-dimensional data operation module performs operations using the data corresponding to the basic dimension and the operation dimension according to the multi-dimensional data operation rule to obtain the multi-dimensional data operation result.

5. The multi-dimensional data analysis device according to claim 1, characterized in that, The data file generator includes an analysis data import module, a data conversion module, and a file upload module. The analysis data import module is configured to read the multi-dimensional data operation result and / or the custom report data, and import the multi-dimensional data operation result and / or the custom report data into the data conversion module; The data conversion module is configured to convert the multi-dimensional data operation result and / or the custom report data into a multi-dimensional analysis table in a specified format; The file upload module is configured to upload the multi-dimensional analysis tables corresponding to the multi-dimensional data operation result and / or the custom report data to the data storage system.

6. The multi-dimensional data analysis device according to claim 1 or 5, wherein the multi-dimensional data engine is further configured to receive and execute the drill-down request instruction of the spreadsheet plug-in to expand the data of the next level of a certain dimension in the form of rows or columns, and receive and execute the roll-up request instruction of the spreadsheet plug-in to collapse the data of the same level of a certain dimension in the form of rows or columns.

7. The multi-dimensional data analysis device according to claim 1, wherein the data storage system is a relational database, a distributed database, or a distributed file system.

8. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the electronic device executes the computer program, it loads the multi-dimensional data analysis device according to any one of claims 1 to 7.

9. A readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it loads the multi-dimensional data analysis device according to any one of claims 1 to 7.

Images