Index calculation engine implementation method based on multi-dimensional model

Abstract

The invention relates to the technical field of information, and provides an index calculation engine implementation method based on a multi-dimensional model. The method aims to solve the problems of different data index apertures, inaccurate data, data processing logic hard code stacking, repeated processing, batch running crossing dependence and long batch running operation time consumption. The main scheme comprises steps of constructing a multi-dimensional model table and a dimension table, and providing a data source for index calculation; according to the multi-dimensional model table, carrying out index calculation logic design, and obtaining a basic index engine configuration table, an addition and subtraction index engine configuration table and a multiplication and division index configuration table; calling the basic index engine configuration table, and calculating to obtain a basic index calculation result; calling an addition and subtraction index engine configuration table, and calculating to obtain an addition and subtraction index calculation result; and calling the multiplication and division index engine configuration table, and calculating the multiplication and division index engine configuration table to obtain a multiplication and division index calculation result; taking the obtained index calculation result as a data interface to provide services for the outside.

Description

technical field [0001] The invention relates to the field of information technology, and provides a method for realizing an index calculation engine based on a multidimensional model. Background technique [0002] At present, each application system of the banking system builds its own reports and processing indicators, or builds a data report application in a subject area based on a theme-based data mart, but it still cannot solve the problems of unified management, calculation, and usage of bank-level data. As a result, data indicators are not managed by a centralized department, data quality is difficult to locate and improve, indicator calculation efficiency is low, batch processing cross-dependence, and various systems repeatedly create wheels and repeat coding. Contents of the invention [0003] The purpose of the present invention is to build a bank-wide index library, provide data interface services and report processing data sources, support the daily demand of th...

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to build a bank-wide index library, provide data interface services and report processing data sources, support the daily demand of the whole bank for T+1, and solve the problem of different data index calibers, inaccurate data, and data processing logic hard code Technical problems such as stacking, repeated processing, cross-dependency of running batches, and long time-consuming calculations of running batches;

Images