Method for achieving accounting subject dynamic calculation in star-shaped model

Abstract

The invention discloses a method for achieving accounting subject dynamic calculation in a star-shaped model. According to the implementation process, the method comprises the steps that firstly, a calculation formula is imported, in other words, the calculation formula is imported in a database in a manual or filling mode; then, calculation factors are extracted, and a calculation sequence of target subjects is generated according to the calculation factors; according to the content, an SQL for calculation of the target subjects is generated and stored. Compared with the prior art, according to the method for achieving accounting subject dynamic calculation in the star-shaped model, it is not needed that development personnel compile the SQL according to a formula provided by accounting service personnel, and then generate SQL processing logic conforming to the star-shaped model by configuring a program; The method is especially suitable for the scene where a large quantity of accounting subjects need to be calculated in a data warehouse financial data market, the development workload can be reduced, and the ETL developing and testing process can be accelerated.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method for realizing dynamic calculation of accounting items in a star model. Background technique [0002] In the prior art, finance and accounting play a vital role in enterprise management, especially large-scale enterprise management. In the construction of data warehouse, financial-related data mart or data analysis is an indispensable part. However, financial analysis often involves a large number of subjects that need to be calculated, which will bring a huge workload to developers, and the cycle of research and development will also reduce the work efficiency of accounting in enterprises. Based on this, we now provide a star schema. A method of dynamically calculating accounting subjects. This method can generate SQL in batches by itself by configuring SQL generation logic based on the subject calculation formulas provided by business personnel. The robustness of th...

AI Technical Summary

Problems solved by technology

However, financial analysis often involves a large number of subjects that need to be calculated, which will bring a huge workload to developers, and the cycle of research and development will also reduce the work efficiency of accounting in enterprises. Based on this, we now provide a star schema. The method of dynamic calculation of accounting subjects. This method can generate SQL in batches by itself by configuring the SQL generation logic based on the subject calculation formula provided by business personnel.

Images