Search

CN-122022561-A - Method and device for determining business index data and readable storage medium

CN122022561ACN 122022561 ACN122022561 ACN 122022561ACN-122022561-A

Abstract

The application provides a method, a device and a readable storage medium for determining service index data, wherein the method is used for a service system, the service system is in communication connection with a client, the method comprises the steps of obtaining calculation requirement data, obtaining a plurality of formulas according to the calculation requirement data, obtaining time grid associated logic data in each formula according to the formulas, obtaining service basic data stored in the service system, determining index basic data corresponding to the time grid associated logic data according to the time grid associated logic data and the service basic data, obtaining a cross-dimension level calculation result based on the formulas and the index basic data, and obtaining the service index data according to the cross-dimension level calculation result. Through multi-step collaborative design, the dimension level limit breaking through single calculation is realized, and the accurate index calculation of cross-dimension level is realized.

Inventors

  • GAO XIN
  • HOU YUQUAN

Assignees

  • 用友网络科技股份有限公司

Dates

Publication Date
20260512
Application Date
20260113

Claims (10)

  1. 1. A method for determining traffic index data, the method being for a traffic system, the traffic system being communicatively connected to a client, the method comprising: Acquiring calculation demand data, and acquiring a plurality of formulas according to the calculation demand data; acquiring time grid associated logic data in each formula according to a plurality of formulas; Acquiring business basic data stored in the business system; determining index basic data corresponding to the time-grid-associated logic data according to the time-grid-associated logic data and the service basic data; acquiring a cross-dimension level calculation result based on the formula and the index basic data; and obtaining service index data according to the cross-dimension level calculation result.
  2. 2. The method for determining traffic index data according to claim 1, wherein after obtaining the traffic index data according to the cross-dimension level calculation result, the method further comprises: responding to the data update request of the client, receiving the data update request carrying the update data identifier sent by the client, and determining the corresponding update data type according to the update data identifier; the updating data type comprises a business basic data updating type and an index basic data updating type; and acquiring updated business index data according to the updated data type, the formula, the time grid associated logic data and the business index data, and sending the updated business index data to a client.
  3. 3. The method for determining traffic index data according to claim 2, wherein said obtaining updated traffic index data according to the updated data type, the formula, the time-grid-associated logic data, and the traffic index data comprises: when the update data type is a service basic data update type, re-determining index basic data according to the updated service basic data and the time grid associated logic data, and updating the service index data by combining a formula and a cross-dimension level calculation rule; When the update data type is an index basic data update type, updating service index data by combining a formula, time grid associated logic data and updated index basic data; and taking the updated business index data as final updated business index data.
  4. 4. The method of claim 1, wherein the formulas include a general formula, a dimensional formula, and a recalculation formula; the general formula calculates basic dimension data according to a summation aggregation mode; The dimension formula is configured according to the appointed dimension and the effective time grid, and is disassembled to the basic dimension according to a preset resolution rule after calculation; And the recalculation formula is dynamically adjusted along with the dimension and the time grid.
  5. 5. The method for determining traffic index data according to claim 1, wherein said determining the index base data corresponding to the time-grid-associated logic data based on the time-grid-associated logic data and the traffic base data comprises: determining a target time grid range according to the time grid association logic data, wherein the target time grid range comprises one or more of a historical time grid, a current time grid and a future time grid; and screening the original data belonging to the target time grid range from the service basic data, and taking the original data as the index basic data.
  6. 6. The method for determining business index data according to claim 1, wherein the obtaining a cross-dimension level calculation result based on the formula and the index base data comprises: configuring a business definition of a cross-dimension hierarchy for an index based on a dimension formula in the formula; And according to the service definition, the formula and the index basic data, performing index formula calculation of the cross-dimension level to obtain a calculation result of the cross-dimension level.
  7. 7. The method for determining business index data according to claim 1, wherein obtaining business index data according to the cross-dimension level calculation result comprises: Analyzing the dependency relationship among the indexes in the cross-dimension level calculation result; segmenting according to the priority of the dependency relationship, starting parallel calculation, and determining a calculation result; And determining the business index data according to the calculation result.
  8. 8. A device for determining traffic index data, wherein the device is used for a traffic system, the traffic system is in communication connection with a client, and the device comprises: the first acquisition module is used for acquiring calculation demand data and acquiring a plurality of formulas according to the calculation demand data; the second acquisition module is used for acquiring the time grid association logic data in each formula according to a plurality of formulas; The third acquisition module is used for acquiring the business basic data stored in the business system; The first determining module is used for determining index basic data corresponding to the time grid association logic data according to the time grid association logic data and the service basic data; the fourth acquisition module is used for acquiring a cross-dimension level calculation result based on the formula and the index basic data; and the second determining module is used for obtaining service index data according to the cross-dimension level calculation result.
  9. 9. A device for determining traffic index data, comprising: A processor; a memory in which a program or instructions are stored, the processor implementing the steps of the method of determining business metric data as claimed in any one of claims 1 to 7 when the program or instructions in the memory are executed.
  10. 10. A readable storage medium, wherein a program or instructions is stored on the readable storage medium, which when executed by a processor, implements the steps of the method for determining business metric data according to any one of claims 1 to 7.

Description

Method and device for determining business index data and readable storage medium Technical Field The present invention relates to the field of computer technologies, and in particular, to a method and apparatus for determining service index data, and a readable storage medium. Background In the related technology, in the business processing work of an enterprise, the index formula calculation of a common working view or Excel (electronic table) is limited by the dimension of the current view, and the index formula calculation of a cross-dimension level under the current view cannot be broken through, so that the cross-level summarization and disassembly of multi-dimensional business indexes in the business management of the enterprise need manual repeated operation, and the efficiency is low and the error is easy to occur. Disclosure of Invention The present invention aims to solve at least one of the technical problems existing in the prior art or related art. To this end, a first aspect of the present invention proposes a method for determining traffic index data. A second aspect of the present invention proposes a device for determining traffic index data. A third aspect of the present invention proposes another apparatus for determining traffic index data. A fourth aspect of the application proposes a readable storage medium. In view of the above, a first aspect of the present invention provides a method for determining service index data, where the method is used in a service system, and the service system is communicatively connected with a client, and the method includes obtaining calculation requirement data, obtaining a plurality of formulas according to the calculation requirement data, obtaining time-grid associated logic data in each formula according to the plurality of formulas, obtaining service base data stored in the service system, determining index base data corresponding to the time-grid associated logic data according to the time-grid associated logic data and the service base data, obtaining a cross-dimension level calculation result based on the formulas and the index base data, and obtaining service index data according to the cross-dimension level calculation result. The method is used for a business system, the business system is in communication connection with a client, calculation demand data in the method refers to data which is provided by business personnel aiming at scenes such as planning budget, data analysis, monitoring and early warning and the like in the business management process and is used for defining calculation targets, ranges and requirements of business indexes, for example, quantitative description data corresponding to requirements such as 'calculating regional annual cost to monthly dimension of each subsidiary company of a group', and the like are core basis for acquiring a follow-up formula. The formula provided by the application is a rule expression which is determined based on calculation demand data and used for realizing business index calculation, and comprises a general formula, a dimension formula and a recalculation formula, and is a core logic carrier for connecting basic data and business indexes. The time grid association logic data is analyzed from a formula, and is used for defining a time dimension association rule of data required by index calculation, for example, the corresponding relation between the current time grid and the historical time grid and the corresponding relation between the current time grid and the future time grid are key logic data for realizing cross-time grid data retrieval and linkage calculation. The business basic data is original data which is stored in a business system and generated by the development of daily business of an enterprise, and comprises objective data such as sales, cost, purchase quantity, inventory and the like, and is an original data source for calculating business indexes. The index basic data is target data which is screened and extracted from the service basic data according to the time-grid-associated logic data and is matched with a specific time grid range, and is direct input data calculated by a formula. The cross-dimension level calculation result is intermediate data obtained after the multi-dimension level linkage calculation, which is based on a formula and index basic data, breaks through the single-view fixed dimension limit and comprises dimension summary data, dimension disassembly data and the like, is realized, and the multi-dimension level linkage is, for example, "group-subsidiary company-department" or "regional-city-store". The business index data refers to the quantized result data which can reflect the actual situation of the business and is finally produced after cross-dimension level calculation and dependency parallel calculation, and the quantized result data meets the calculation requirement. In conclusion, based on the steps and the data, the technical scheme of