Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Report generation method and device based on index system

An index system and report generation technology, applied in the field of data processing, can solve the problems of complex and cumbersome report association processing, unfavorable unified maintenance, and inability to report update, so as to facilitate unified maintenance and effective management, avoid inconsistent index calibers, and optimize report generation. effect of the way

Active Publication Date: 2019-12-10
KOUBEI SHANGHAI INFORMATION TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Among them, the first processing method is to obtain various data processing scripts by manually writing structured query language instructions (that is, SQL instructions), and associate and bind data sources and report presentations. This processing method requires a lot of manpower The cost and processing efficiency are low, and the report association processing is complicated and cumbersome, which is not conducive to unified maintenance
The second processing method is to automatically generate SQL instructions based on data tables and multi-table associations, and then bind them to the visual interface of the report. This processing method requires a large amount of data table maintenance, and there will be overlap between data tables indicators, when a data table changes, other data tables do not perceive it, causing serious data quality problems, and when the indicator caliber changes, the client cannot intelligently update the report

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Report generation method and device based on index system
  • Report generation method and device based on index system
  • Report generation method and device based on index system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0081] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0082] Figure 1a A schematic flow diagram showing a method for generating a report based on an indicator system according to an embodiment of the present invention, as shown in Figure 1a As shown, the method includes the following steps:

[0083] Step S100, according to the data table, construct an index system including a plurality of index models and data subject marts.

[0084] This method can be executed by the server. In or...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a report generation method and device based on an indicator system. The report generation method based on the indicator system includes the steps of constructing the indicatorsystem including multiple indicator models and data subject marts according to a data table; configuring data subjects in the data subject markets to obtain configuration data corresponding to the data subjects; generating structured query language instructions and report display page instructions corresponding to the data subjects according to the configuration data; obtaining report services byusing the structured query language instructions and the report display page instructions. According to the technical scheme, the structured query language instructions suitable for various service requirements can be quickly, automatically and flexibly generated, an association mapping relationship between the indicator system and the SQL services is established, various service requirements areeffectively met, the uniqueness of data indicators is guranateed, and the problem of indicator caliber inconsistency is effectively avoided.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a report generation method and device based on an index system. Background technique [0002] With the rapid development of information technology, we ushered in the era of big data, which requires data processing of massive data. Generally, by analyzing and processing the data, the data is converted into dimensions that are easy for users to understand, and the data indicators that users need are obtained from various possible dimensions, and visualized reports are obtained, so that users can quickly and intuitively understand business development and determine business Develop strategy. In the prior art, reports are generally obtained through the following two processing methods. Among them, the first processing method is to obtain various data processing scripts by manually writing structured query language instructions (that is, SQL instructions), and associate and ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/23G06F16/242
Inventor 由治国赵国旗张永志曹铁铮陈洪常炜
Owner KOUBEI SHANGHAI INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products