Compilation method and device for multi-dimensional report

Abstract

The invention discloses a compilation method and device for a multi-dimensional report. The method comprises the step of setting essential attributes of the report and the report format, wherein a report code, a report name, a report period and the total column number of the report are set; the step of setting data sources, wherein the data sources of the report are set; the step of setting a dimensional item, wherein the content, an access formula, a dimensional relation, a dimensional item subitem and a numerical value item of the dimensional item are set; the step of compiling the report, wherein access is carried out on a corresponding service system in the set report format according to the set access formula, and the multi-dimensional dynamic report is generated. According to the compilation method, the dimensional item of the report is set on the basis of the data sources, the multi-dimensional dynamic report format and the access formula are flexibly configured, when the access is carried out on the service system, the multi-dimensional dynamic report can be dynamically generated according to the report format and the access formula, the generated report data not only can meet the requirement for statistical analysis, but also can be reported, audited and filed, and the application requirement for report management is met.

Description

technical field [0001] The invention belongs to the technical field of enterprise financial information management systems, and more specifically relates to a method and device for compiling multi-dimensional reports. Background technique [0002] As an important tool for the daily operation and management of an enterprise, reports have specific business requirements, such as support for generating reports from business systems, support for report review, support for convenient query and archiving management, and support for report data to be reported by subordinate units to superior units, and The report has its relatively fixed report format. [0003] In order to reflect the operating status of the enterprise in a comprehensive, in-depth and detailed manner, and to facilitate the effectiveness and correctness of decision-making, it is required that the reports can reproduce the operating status of the enterprise from various angles. For example, the fuel report of the pow...

AI Technical Summary

Problems solved by technology

However, the existing reports are all in the format of fixed rows, which is difficult to meet the statistical requirements of dynamic multi-dimensional analysis of business data, and it is impossible to customize multiple statistical dimensions to form dynamic row reports

If you want to perform multi-dimensional statistical analysis of data, you can only use the query function. Although there are many ways to realize the multi-dimensional query statistics function of the report, the report query results obtained by these methods are only temporary results, and only one can be provided. The temporary data display interface cannot store, report, archive and other operations on the results, nor does it have the functions of data filling and review

Images