Search

CN-115270744-B - Multi-dimensional data processing method, device, medium and electronic equipment

CN115270744BCN 115270744 BCN115270744 BCN 115270744BCN-115270744-B

Abstract

The application discloses a multi-dimensional data processing method, a device, a medium and electronic equipment, wherein the method comprises the steps of acquiring data, wherein the data comprises at least one existing data table and at least one piece of scattered data; the method comprises a table extraction configuration, a preprocessing step, a first generation step and a second generation step, wherein the table extraction configuration is used for extracting at least one field in at least one data table, the dimension mapping configuration is used for mapping the extracted at least one field to a corresponding dimension, so as to form a first multi-dimensional data table, at least one piece of scattered data is complemented into the first multi-dimensional data table, and the first generation step is used for integrating data conforming to the index dimension in the first multi-dimensional data table to each preset index based on at least one preset index and the index dimension corresponding to each preset index, so as to generate the first index data table. When the multi-dimensional damage condition is needed to be known, the application can avoid a great deal of repeated development/modification work, and saves manpower resources and technological construction cost.

Inventors

  • ZHANG QIANG
  • CAI JINFA

Assignees

  • 建信金融科技有限责任公司

Dates

Publication Date
20260505
Application Date
20220817

Claims (13)

  1. 1. A method of multidimensional data processing, the method comprising: An acquisition step of acquiring data, wherein the data comprises at least one existing data table and at least one piece of scattered data; Preprocessing, namely extracting at least one field in the at least one data table based on table extraction configuration, mapping the extracted at least one field to a corresponding dimension based on dimension mapping configuration, so as to form a first multidimensional data table, and complementarily recording the at least one piece of scattered data into the first multidimensional data table; A first generation step of gathering data conforming to index dimensions in the first multidimensional data table to each of the predetermined indexes based on at least one set predetermined index and an index dimension corresponding to each of the predetermined indexes, thereby generating a first index data table; A general score checking step, namely performing general score checking on the first index data table and the general account data table, and supplementing difference data into the first multi-dimensional data table to form a second multi-dimensional data table; and a second generation step of collecting data conforming to the index dimension in the second multidimensional data table to each of the predetermined indexes based on at least one of the predetermined indexes and the index dimension, thereby generating a second index data table.
  2. 2. The method of claim 1, wherein the total score checking step further comprises: Collecting the value of at least one subject in the general ledger data table into a check value of a check index, collecting the value of the check index collected in the first index data table into a total value, wherein the check index is one of at least one preset index; Comparing the check value with the summary value to obtain a difference value; according to the dimension processing mode of each dimension, determining a dimension value of each dimension, and supplementing each dimension value and the difference value serving as the difference data into the first multidimensional data table to form a second multidimensional data table.
  3. 3. The method of claim 1, wherein in the preprocessing step, the table extraction configuration includes a data table, a field, and a data filtering condition to be extracted, such that corresponding data of at least one field in the at least one data table is extracted, The dimension mapping configuration includes a plurality of dimensions, and a mapping manner for each dimension, such that the corresponding data of the at least one field is mapped to a corresponding dimension according to the mapping manner.
  4. 4. The method of claim 1, further comprising, in the preprocessing step, adjusting data in the first multi-dimensional data table.
  5. 5. The method of claim 4, wherein at least one of the tables entered into the first multi-dimensional data table is adjusted using a scaling method and wherein the at least one piece of scattered data is adjusted using a commission method and then re-entered into the first multi-dimensional data table.
  6. 6. A multi-dimensional data processing apparatus, the apparatus comprising: the acquisition unit acquires data, wherein the data comprises at least one existing data table and at least one piece of scattered data; the preprocessing unit is used for extracting at least one field in the at least one data table based on table extraction configuration, mapping the extracted at least one field to a corresponding dimension based on dimension mapping configuration, so as to form a first multidimensional data table, and complementarily recording the at least one piece of scattered data into the first multidimensional data table; A first generation unit configured to aggregate data conforming to index dimensions in the first multidimensional data table to each of the predetermined indexes based on at least one set predetermined index and an index dimension corresponding to each of the predetermined indexes, thereby generating a first index data table; the general score checking unit is used for checking the general score of the first index data table and the general account data table, and supplementing the difference data into the first multi-dimensional data table to form a second multi-dimensional data table; And a second generation unit configured to aggregate data conforming to the index dimension in the second multidimensional data table to each of the predetermined indices based on at least one of the predetermined indices and the index dimension, thereby generating a second index data table.
  7. 7. The apparatus according to claim 6, wherein the total score checking unit further performs the operations of: Collecting the value of at least one subject in the general ledger data table into a check value of a check index, collecting the value of the check index collected in the first index data table into a total value, wherein the check index is one of at least one preset index; Comparing the check value with the summary value to obtain a difference value; according to the dimension processing mode of each dimension, determining a dimension value of each dimension, and supplementing each dimension value and the difference value serving as the difference data into the first multidimensional data table to form a second multidimensional data table.
  8. 8. The apparatus of claim 6, wherein in the preprocessing unit, the table extraction configuration includes a data table, a field, and a data filtering condition to be extracted, such that corresponding data of at least one field in the at least one data table is extracted, The dimension mapping configuration includes a plurality of dimensions, and a mapping manner for each dimension, such that the corresponding data of the at least one field is mapped to a corresponding dimension according to the mapping manner.
  9. 9. The apparatus of claim 6, wherein the preprocessing unit further adjusts the data in the first multi-dimensional data table.
  10. 10. The apparatus of claim 9, wherein at least one of the tables entered into the first multi-dimensional data table is adjusted using a scaling method and wherein the at least one piece of scattered data is adjusted using a commission method and is then re-entered into the first multi-dimensional data table.
  11. 11. A computer readable storage medium having stored thereon instructions which, when executed on a computer, cause the computer to perform the multi-dimensional data processing method of any one of claims 1 to 5.
  12. 12. An electronic device comprising one or more processors, one or more memories, the one or more memories storing one or more programs that, when executed by the one or more processors, cause the electronic device to perform the multi-dimensional data processing method of any of claims 1-5.
  13. 13. A computer program product comprising computer executable instructions, wherein the instructions are executed by a processor to implement the multi-dimensional data processing method of any one of claims 1 to 5.

Description

Multi-dimensional data processing method, device, medium and electronic equipment Technical Field The present application relates to the field of data processing technologies, and in particular, to a multidimensional data processing method, an apparatus medium, an electronic device, and a computer program product. Background Many companies lack fine financial management statistical analysis on own business operation conditions, especially lack multidimensional loss and benefit conditions, have urgent demands for use, but have no clear multidimensional loss and benefit condition data to be checked, the data are scattered in business manual accounts, the data are inaccurate, historical data cannot be checked, and statistical work is difficult to realize. The traditional system is used for developing the functions, a large amount of development is needed according to the service demands, and a large amount of manpower resources and technological construction cost are consumed. The general multidimensional damage solution is developed by data batch processing according to the requirement. The process belongs to the traditional software development process and comprises the steps of demand analysis, design, development, test and maintenance. However, existing solutions require long development cycles, rule change handling is inflexible, and frequent system updates are required to be put on-line. Disclosure of Invention The embodiment of the application provides a multi-dimensional data processing method, a multi-dimensional data processing device, an electronic device and a computer program product. In a first aspect, an embodiment of the present application provides a multidimensional data processing method, where the method includes an obtaining step of obtaining data, where the data includes at least one existing data table and at least one piece of scattered data, a preprocessing step of extracting at least one field in the at least one data table based on a table extraction configuration, mapping the extracted at least one field to a corresponding dimension based on a dimension mapping configuration, thereby forming a first multidimensional data table, and logging the at least one piece of scattered data into the first multidimensional data table, and a first generating step of collecting data, which meets the index dimension, in the first multidimensional data table to each of the predetermined indexes based on at least one set predetermined index and an index dimension corresponding to each of the predetermined indexes, thereby generating a first index data table. In one possible implementation of the first aspect, the method further includes a total score checking step of checking the first index data table and the general ledger data table together, and supplementing difference data into the first multidimensional data table to form a second multidimensional data table, and the second generating step is based on at least one predetermined index and the index dimension, and gathers data conforming to the index dimension in the second multidimensional data table to each of the predetermined indexes, so as to generate a second index data table. In one possible implementation of the first aspect, the general ledger checking step further includes integrating a value of at least one subject in the general ledger data table into a check value of a check index, integrating the value of the at least one subject in the first index data table into the check index to obtain a total value, where the check index is one of at least one predetermined index, comparing the check value with the integrated value to obtain a difference value, determining a dimension value of each dimension according to a dimension processing mode of each dimension, and supplementing each dimension value and the difference value as the difference data into the first multidimensional data table to form a second multidimensional data table. In a possible implementation of the first aspect, in the preprocessing step, the table extraction configuration includes a data table to be extracted, fields, and data filtering conditions, so as to extract corresponding data of at least one field in the at least one data table, and the dimension mapping configuration includes a plurality of dimensions and a mapping manner of each dimension, so as to map the corresponding data of the at least one field to a corresponding dimension according to the mapping manner. In a possible implementation of the first aspect, in the preprocessing step, the method further includes adjusting data in the first multidimensional data table. In a possible implementation manner of the first aspect, at least one data table entering the first multidimensional data table is adjusted by using a scaling method, and the at least one piece of scattered data is adjusted by using a commission method and then is re-recorded in the first multidimensional data table. In a second aspect, an