An implementation method of index calculation engine based on multi-dimensional model

Abstract

The invention relates to the field of information technology, and provides a method for realizing an index calculation engine based on a multidimensional model. The main purpose is to solve the problems of different data indicators, inaccurate data, data processing logic hard code stacking, repeated processing, cross-dependency of running batches, and long time-consuming calculations of running batches. The main scheme includes building multidimensional model tables and dimension tables to provide data sources for indicator calculations; designing indicator calculation logic based on multidimensional model tables, and obtaining basic indicator engine configuration tables, addition and subtraction indicator engine configuration tables, and multiplication and division indicator configuration tables; Call the basic indicator engine configuration table to calculate the basic indicator calculation results; call the addition and subtraction indicator engine configuration table to calculate the addition and subtraction indicator calculation results; call the multiplication and division indicator engine configuration table to calculate the multiplication and division indicator engine configuration table. Multiplication and division indicator calculation results. Then use the obtained indicator calculation results as a data interface to provide external services.

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