CN112199930A - Method and system for automatically generating report according to report configuration - Google Patents
Method and system for automatically generating report according to report configuration Download PDFInfo
- Publication number
- CN112199930A CN112199930A CN202011181311.4A CN202011181311A CN112199930A CN 112199930 A CN112199930 A CN 112199930A CN 202011181311 A CN202011181311 A CN 202011181311A CN 112199930 A CN112199930 A CN 112199930A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- index
- original
- determining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 238000012545 processing Methods 0.000 claims description 64
- 230000006870 function Effects 0.000 claims description 44
- 238000003860 storage Methods 0.000 claims description 40
- 238000009825 accumulation Methods 0.000 claims description 4
- 230000008569 process Effects 0.000 description 23
- 238000011161 development Methods 0.000 description 14
- 238000010586 diagram Methods 0.000 description 14
- 238000004364 calculation method Methods 0.000 description 8
- 230000014509 gene expression Effects 0.000 description 5
- 210000001072 colon Anatomy 0.000 description 3
- 230000006872 improvement Effects 0.000 description 3
- 239000000463 material Substances 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000000644 propagated effect Effects 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000009795 derivation Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 239000000047 product Substances 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000000712 assembly Effects 0.000 description 1
- 238000000429 assembly Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 239000010977 jade Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000003607 modifier Substances 0.000 description 1
- 238000011946 reduction process Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 241000894007 species Species 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Quality & Reliability (AREA)
- General Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the specification discloses a method and a system for automatically generating a report according to report configuration. The method comprises the following steps: after receiving a report generation request, loading a report configuration associated with the report generation request. Determining a derivative index based on the report generation request and the report configuration; wherein, a functional relation associated with the original index is configured in the derived index. Determining an original index based on the derived index and the functional relation; and determining target report data for generating a report based on the derived index and the original index, and automatically generating the report based on the target report data.
Description
Technical Field
The present disclosure relates to the field of data processing, and in particular, to a method and system for automatically generating a report according to report configuration.
Background
With the rapid development of the internet and the continuous increase of the business volume, data of various businesses generally need to be displayed in the form of reports. In the related technology, the generation of the report needs a developer to develop the code of the computer language according to the actual use requirement of the report, and then the report is generated according to the computer language, however, the code is complex, so that the process of generating the report is complicated, the time consumption is long, and the efficiency is low.
Therefore, it is desirable to provide a method and system for automatically generating reports according to a report configuration to improve the efficiency of generating reports.
Disclosure of Invention
One aspect of an embodiment of the present specification provides a method for automatically generating a report according to a report configuration, where the method includes: after receiving a report generation request, loading report configuration associated with the report generation request; determining a derivative index based on the report generation request and the report configuration; wherein, a functional relation associated with the original index is configured in the derived index; determining an original index based on the derived index and the functional relation; and determining target report data for generating a report based on the derived index and the original index, and automatically generating the report based on the target report data.
Another aspect of an embodiment of the present specification provides a system for automatically generating a report according to a report configuration, the system including: the loading module can be used for loading the report configuration associated with the report generation request after receiving the report generation request; the first determination module can be used for determining a derivation index based on the report generation request and the report configuration; wherein, a functional relation associated with the original index is configured in the derived index; a second determination module, configured to determine an original indicator based on the derived indicator and the functional relationship; the third determining module may be configured to determine target report data used for generating a report based on the derived index and the original index, and automatically generate a report based on the target report data.
Another aspect of the embodiments of the present specification provides an apparatus for automatically generating a report according to a report configuration, including a processor, where the processor is configured to execute a method for automatically generating a report according to a report configuration.
Another aspect of the embodiments of the present specification provides a computer-readable storage medium storing computer instructions, and when the computer reads the computer instructions in the storage medium, the computer executes a method for automatically generating a report according to a report configuration.
Drawings
The present description will be further explained by way of exemplary embodiments, which will be described in detail by way of the accompanying drawings. These embodiments are not intended to be limiting, and in these embodiments like numerals are used to indicate like structures, wherein:
FIG. 1 is an exemplary diagram illustrating a system application scenario for automatically generating reports from a report configuration according to some embodiments of the present description;
FIG. 2 is an exemplary flow diagram illustrating a method for automatically generating reports from a report configuration according to some embodiments of the present description;
FIG. 3 is an exemplary flow diagram illustrating the determination of target reporting data according to some embodiments of the present description;
FIG. 4 is an exemplary flow diagram illustrating the determination of target reporting data according to further embodiments of the present description;
FIG. 5 is a block diagram of a system for automatically generating reports from a report configuration, according to some embodiments of the present description;
FIG. 6 is an exemplary diagram of a reporting configuration shown in accordance with some embodiments of the present description;
FIG. 7 is an exemplary diagram of a data table used to generate reports in accordance with some embodiments of the present description.
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure, the drawings used in the description of the embodiments will be briefly described below. It is obvious that the drawings in the following description are only examples or embodiments of the present description, and that for a person skilled in the art, the present description can also be applied to other similar scenarios on the basis of these drawings without inventive effort. Unless otherwise apparent from the context, or otherwise indicated, like reference numbers in the figures refer to the same structure or operation.
It should be understood that "system", "apparatus", "unit" and/or "module" as used herein is a method for distinguishing different components, elements, parts, portions or assemblies at different levels. However, other words may be substituted by other expressions if they accomplish the same purpose.
As used in this specification and the appended claims, the terms "a," "an," "the," and/or "the" are not intended to be inclusive in the singular, but rather are intended to be inclusive in the plural, unless the context clearly dictates otherwise. In general, the terms "comprises" and "comprising" merely indicate that steps and elements are included which are explicitly identified, that the steps and elements do not form an exclusive list, and that a method or apparatus may include other steps or elements.
Flow charts are used in this description to illustrate operations performed by a system according to embodiments of the present description. It should be understood that the preceding or following operations are not necessarily performed in the exact order in which they are performed. Rather, the various steps may be processed in reverse order or simultaneously. Meanwhile, other operations may be added to the processes, or a certain step or several steps of operations may be removed from the processes.
A report refers to a table or chart for displaying data. Such as a data table, line graph, bar graph, etc. The report is widely applied to various application scenarios, such as financial scenarios, internet scenarios, logistics scenarios, and the like. For example, in a payment service, a refund service, a transfer service and the like in a financial scene, a user can analyze service data by using a report form. In the related art, once report generation, complex coding development needs to be performed on a data interface used for generating a report, and after the coding development of the data interface is completed, a series of processing such as receiving, calculating, summarizing and the like needs to be performed on data in the data interface to generate a complete report. However, because the data volume of the service is large, a large number of different reports need to be generated for different services or different types of data, and usually one report needs to correspond to one data interface, a large number of data interface code development works and data processing works need to be completed, and the process of generating the report is tedious, long in time and low in efficiency. Some embodiments of the present specification provide a method and a system for automatically generating a report according to report configuration, where the method does not need to code and develop a data interface, and generates a report by means of configuration design and report configuration loading, so as to simplify a report generation process and improve report generation efficiency.
FIG. 1 is an exemplary diagram illustrating an application scenario of a system for automatically generating reports from a reporting configuration according to some embodiments of the present description.
The system 100 for automatically generating reports from a reporting configuration can generate reports from a configured reporting configuration by implementing the methods and/or processes disclosed herein. The data used for generating the report can be obtained according to the report configuration set in the system, the data can be processed, the data can be used for generating the report, the type of the generated report can be flexibly configured, the efficiency of generating the report is improved, and the time cost of developers is saved.
As shown in fig. 1, a server 110, a user terminal 120, a storage device 130, and a network 140 may be included in an application scenario.
In some application scenarios, the server 110 may receive a report generation request from the user terminal 120, and load a report configuration associated with the report generation request after receiving the report generation request; the server 110 may determine a derivative index based on the report generation request and the report configuration; the derived index is configured with function information associated with the original index; the server 110 may determine an original index based on the derived index and the functional relationship; the server 110 may determine target reporting data for generating a report based on the derived index and the original index, and automatically generate a report based on the target reporting data. In some embodiments, the server 110 may further send the target report data to the user terminal 120, so that the user terminal 120 generates a report according to the target report data.
The server 110 may be a device with data acquisition, storage, computation, analysis, and/or transmission capabilities, for example, that may be used to process report generation requests. In some embodiments, the server 110 may receive a report generation request from the user terminal 120, load a report configuration associated with the report generation request, and determine target report data for generating a report according to the report configuration. In some embodiments, the server 110 may be a single server or a group of servers. The server farm can be centralized or distributed (e.g., the servers 110 can be distributed systems). In some embodiments, the server 110 may be local or remote. For example, server 110 may access information and/or data stored in storage device 130, user terminal 120, through network 140. As another example, server 110 may be directly connected to storage device 130, user terminal 120 to access stored information and/or data. In some embodiments, the server 110 may be implemented on a cloud platform. By way of example only, the cloud platform may include a private cloud, a public cloud, a hybrid cloud, a community cloud, a distributed cloud, between clouds, multiple clouds, the like, or any combination of the above.
In some embodiments, the server 110 may include a processing engine 112. The processing engine 112 may process data and/or information related to report generation to perform one or more of the functions described herein. For example, the processing engine 112 may, upon receiving a report generation request, load a report configuration associated with the report generation request; and determining target report data for generating a report according to the report configuration. The Processing engine 112 may include various conventional processors, such as a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), a Microprocessor Unit (MPU), an Application-Specific Integrated Circuit (ASIC), or other types of Integrated circuits.
The user terminal 120 may be one or more terminal devices or software used by the user. In some embodiments, the user terminal 120 may be one or any combination of a mobile device 120-1, a tablet computer 120-2, a laptop computer 120-3, a desktop computer 120-4, and the like having input and/or output capabilities. In some embodiments, the user terminal 120 may send a report generation request to the server 110. In some embodiments, the user terminal 120 may receive the target report data returned by the server 110 and generate a report according to the target report data.
FIG. 2 is an exemplary flow diagram illustrating a method for automatically generating reports from a report configuration according to some embodiments of the present description. In some embodiments, flow 200 may be performed by a processing device (e.g., server 110). For example, the process 200 may be stored in a storage device (e.g., an onboard storage unit of a processing device or an external storage device) in the form of a program or instructions that, when executed, may implement the process 200. The flow 200 may include the following operations.
In some embodiments, a user or business interface may send a report generation request to a processing device (e.g., server 110) through a device (e.g., user terminal 120) used by the user or business interface to obtain corresponding report data to generate a report. The report can help the user analyze the business data.
The report generation request may refer to an instruction requesting generation of a report. Report parameter information related to the report requested to be generated can be contained in the report generation request. For example, report parameters (e.g., data items of a report), etc. Turning now to FIG. 6, FIG. 6 is an exemplary diagram of a reporting configuration shown in accordance with some embodiments of the present description. Assuming that a report of the online sales amount data of the merchant is desired to be requested, report parameter information "$ indictortype", "count", and "online" may be included in the report generation request; here, "$ indicatotype" indicates that the report parameter transmitted by the front end is indeicatoreType, $ indicates that this is a parameter transmitted by the front end, "count" indicates amount data, and "online" indicates amount data on the line. The parameter information in the report generation request can be used to query the associated report configuration, for example, the "$ indicatoType" parameter can be used to query the associated report configuration.
The report configuration may refer to the definition of the processing mode of each index required for generating the report when generating the report. An index refers to a data item of a report represented in the form of a field, and one or more fields may be included in the report configuration. A field, i.e., a custom text paragraph, can be represented in any textual form. For example, each line of text in each curly brace in FIG. 6 can be understood as a field, and one or more fields form a pointer, e.g., "Count: Condition": GroupCount "in 610 is a pointer, and {" alias ": GroupCount", "expression": group (Count, extBizType) "," show ": uetr } in 620 is a pointer.
The report configuration being associated with the report generation request means that there is a correspondence between the report generation request and the report configuration. One report configuration may correspond to generating one or more types of reports, for example, in one report configuration, indexes corresponding to generating multiple types of reports may be configured, and the report generation request may include report parameter information required for requesting the generated report, and if the indexes included in the report configuration have the same index type parameter as the report parameter information, the report configuration may be considered to be associated with the report generation request. For example, following the above example of the report generation request, the report generation request includes parameter information "$ indicatotype: Condition" indicating the report indicator type, and the query is performed in the report configuration according to the parameter information, as shown in fig. 6, if "$ indicatotype: Condition" is included in the quota Condition "field in the report configuration and is the same as the indicator type parameter in the report generation request, the report configuration may be considered to be associated with the report generation request.
It should be noted that the field query mode in the report configuration is in a key-value (key value) form, and the colon between quotation marks is used as a boundary, the content before the colon is key, and the content after the colon is value. For example, in the fields "qotapondition" $ indicatoType: Condition ", qotapondition" is key and "$ indicatoType: Condition" is a value.
In some embodiments, the configured report configuration may be stored in the database or the storage device in advance, and after receiving the report generation request, the processing device (the loading module 510) may complete loading by reading the report configuration from the database or the storage device.
The derived index is a field representation of the data item after logical processing of data corresponding to the data item of the original index. Data items refer to data sets composed of some type of data, e.g., money item data, time item data, etc. The logical processing may include processing data corresponding to the data items according to a certain calculation manner and/or processing manner. The calculation mode can comprise summation, difference calculation, percentage calculation, same proportion calculation and the like; the processing means may include grouping, accumulating, renaming, and the like.
The functional relationship refers to functional information for logically processing the original data used for generating the report. And configuring a functional relation associated with the original index in the derived index. For example, in the "expression" in the "group (Amount, extbztype)" field in the derived index 620 in fig. 6, "group (Amount, extbztype)" indicates the configured functional relationship, and specifically, "group" indicates that the functional relationship is a grouping function, which indicates that the data of the Amount items are grouped by the content of the extbztype field. For more details on the functional relationship in the derived index, see other relevant parts of this specification, e.g., fig. 3 and its associated description.
The original index refers to a data item associated with the original data of the report. The raw index may be used to obtain raw data items that are logically processed according to a functional relationship in the derived index. For more details of the original index, reference may be made to the description in step 206, which is not described herein again.
In some embodiments, the processing device (the first determining module 520) may query the report configuration to obtain the derived index according to the report parameter information included in the report generation request.
Specifically, the processing device may determine a report parameter index in the report configuration based on the report generation request. The report parameter index is an index corresponding to the report parameter information in the report generation request. The report generation request may include report parameter information of the requested report generation, such as total transaction amount, transaction times, online amount data, offline amount data, and the like. The report configuration is provided with report parameter indexes which have corresponding relations with the report parameter information, and the report parameter indexes comprise fields of corresponding parameters, such as a total transaction amount field, a transaction number field and the like. The processing device can determine the report parameter index in the report configuration according to the corresponding relation between the report parameter information and the report parameter index.
For example, referring to FIG. 6, the report parameter indicator 610 in the report configuration is represented by the various fields in 610. As can be seen, a number of fields are included in the report parameter indicator, such as "requestMapping", "quottaCondition", and "quottaCondition mapping". Report parameter information corresponding to the above fields, for example, "$ indictorType: condition, online and the like, wherein the report parameter information can be queried in the report configuration, firstly, a 'quotta Condition' field is queried, and further, in the field of the report parameter index 610 of the report configuration, the 'Condition' and the 'online' are used as query conditions, and the 'Amount: Condition' is queried: "GroupAmount", "Count: Condition": "GroupCount", "Ratio: Condition": the report parameter indexes corresponding to the report generation request are determined by PerAmout, Online, Amount and ONLINE. It should be noted that the report configuration shown in fig. 6 is only an example, and the above example is not intended to limit the form of the report configuration in this specification.
Further, the processing device may determine the derived index according to the report parameter index. Because the index name of the corresponding report parameter index (i.e. the corresponding field key, such as GroupAmount, GroupCount, perammout) is between the report parameter index and the derived index in the report configuration, the derived index can be determined by searching the field of the derived index in the report configuration according to the index name in the report parameter index.
For example, still referring to fig. 6, when the index name is searched for in the derived index 620, a plurality of fields (which can also be understood as being configured with a plurality of derived indexes) are also configured in the derived index 620, and exemplarily, the fields following "derivitivequota configurations" are shown in fig. 6. As can be known from the accompanying drawings, in the uppermost curly bracket of the derived index 620, there are { "alias": GroupAmount "," expression ": group (Amount, extBizType)", "show": true }, where there is information corresponding to the report parameter index, for example, "GroupAmount", and therefore, the derived index can be determined to be the derived index corresponding to the report parameter index. Wherein alias represents an index name; the expression represents the functional relationship of the configuration; show indicates whether or not to display in the report result.
In some embodiments, when the report parameter indicator includes parameter information corresponding to the fields of "qotapondition" and "qotaponditionmap", the "show" and "true" fields may be ignored. The field following "requestMapping" is used to indicate that the data for generating the report is online data or offline data, and may be directly indicated by the parameter information included in the report generation request.
Through the setting, a plurality of fields for generating the report can be set in each index in the report configuration, after the report request is received, the corresponding report parameter index is inquired from the fields of the report configuration according to the report parameter information in the report request, then the inquiry is carried out from the fields of one or more configured derived indexes according to the determined fields of the report parameter index, and the derived index corresponding to the report generation request is determined. For example, assuming that the report generation request is a report of the number of sales of the online commodity, the report parameter information in the report generation request corresponds to "$ indictortype: condition "," amount ", and" online ", then one may first: the Condition parameter determines the report configuration, and if the determined report configuration is shown in FIG. 6, the report parameter indexes of 'AMount: Condition': GroupAmount 'and' Online: AMount ': ONLINE' are further determined according to the Amount and Online parameters; further, according to the report parameter indexes of ' atmospheric: Condition ': GroupAmount ', the derivative indexes of ' alias ': GroupAmount ', ' expresson ': group (Amount, extBizType) ' and ' show ': true } are determined. By changing the parameter in the report generation request, for example, modifying "Amount" to "Count" or "Ratio", the derivation index for generating different types of reports can be determined. Therefore, the function of generating the reports of multiple types through one report configuration can be realized, the condition that each report needs report development is greatly improved, and the report generation efficiency is improved. As described above, the report configuration of fig. 6 can generate a report of sales Amount data (the report parameter includes Count), a report of sales Amount times (the report parameter includes Amount), and a report of sales Amount ring growth (the report parameter includes Ratio).
In some embodiments, the processor for performing the functional relationship associated with the original metric may be written in groovy language. The processor written in groovy language can realize dynamic loading of functional relations. Dynamic loading refers to that after the functional relation is written in a computer language, the function can be immediately released and executed. For example, after compiling is completed, by clicking a release button or refreshing a compiling interface, a function of compiling can be realized, so that the time for code development and online can be reduced, the configuration generated by the report is expanded, more types of expanded development generated by the configuration of the report can be supported, the requirements of customers can be quickly responded, and the processing logic or configuration of the report can be quickly changed and validated.
The original index refers to the index of the data item associated with the report original data. Referring to FIG. 6, the original pointer 630 may be represented by a field following "reportQuotiConfigs", and as such, multiple fields may be included in the original pointer. For the original indicators, taking the original indicators in the first curly brace as an example, it may include "alias": Amount "," source ": ReportQuota", "unit": Amount "," bizType ": LIQ _ C _ DPT _ AMT", "subBizType": "$ channelType: Amount", "extBtType": _ notNull ", and" sumSubtype ": true". Wherein, alias and field meaning in the derived index are the same, and represent the name of the index; the source represents the query address of the original index data item corresponding to the original index; unit represents the data type of the query, e.g., time, amount, currency, etc.; "bizType", "subBizType", "extBizType", "sumsputype" indicate different business dimensions, and may also be understood as different types of business data, for example, in the case of financial business, the business dimensions may include recharge, withdrawal, refund, transfer, and the like.
In some embodiments, the processing device may determine the original metric according to a configured functional relationship in the derived metric. It can be understood that the functional relationship is a representation of functional information for logically processing the original data for generating the report, and the functional relationship includes an index name corresponding to the original data, so that the original index can be determined by querying the original index configured in the report according to the index name.
For example, still referring to fig. 6, in the first parenthesized field of the derived index 620, the function relationship configured in the derived index is "group (Amount, extBizType)", and the index name "Amount" for query is included in the function relationship, then the corresponding "alias: and determining the index represented by the corresponding field under the name as the original index corresponding to the derivative index.
And 208, determining target report data for generating a report based on the derived index and the original index, and automatically generating the report based on the target report data. In some embodiments, step 208 may be performed by the third determination module 540.
The target report data refers to data that is ultimately used to generate a report.
In some embodiments, the processing device may perform a query according to a field in the original indicator to obtain an original report data item for generating a report. Further, after the original report data item is obtained, according to the functional relation in the derived index, the data of the original report data item is logically processed, and the target report data for generating the report is obtained. For more details on obtaining the original report data items for generating the report and determining the target report data, reference may be made to fig. 3 and its related description, which are not described herein again.
In the embodiment of the specification, after a report request is received, a report is generated by loading a preset report configuration from a database or a storage device, after the report configuration is loaded, original data used for generating the report can be obtained according to a corresponding relation between indexes in the report configuration, the original data is logically processed according to a functional relation in a derived index, target report data used for generating the report is obtained, and the target report data is returned to a front end sending the report request, so that the report can be generated. The method and the device can generate different types of reports by flexibly setting each index in report configuration. The report configuration is configured by developers, the report configuration scheme is designed to improve the report development efficiency, the original coding development is changed into pure configuration, the efficiency is improved to the hour level from multiple days, and the report development efficiency is effectively improved.
FIG. 3 is an exemplary flow diagram illustrating the determination of target reporting data according to some embodiments of the present description. In some embodiments, flow 300 may be performed by a processing device (e.g., server 110). For example, the process 300 may be stored in a storage device (e.g., an onboard storage unit of a processing device or an external storage device) in the form of a program or instructions that, when executed, may implement the process 300. In some embodiments, the process 300 may be performed by the third determining module 540, and the process 300 may include the following operations.
For more details of the original index, refer to the description of step 208, which is not repeated herein.
The original report data item refers to a collection of original data which is not logically processed. In some embodiments, the processing device may determine, according to an index name in a field in the original index, a data item corresponding to data required for a functional relationship in the derived index, and obtain the original report data item based on the data item. For example, referring to fig. 6 and 7, fig. 7 is an exemplary diagram of a data table for generating a report according to some embodiments of the present description. Still following the above example, after the original indicator is determined, the data may be queried according to the name of the data source to be queried in the original indicator, for example, the data queried by the query address of the data represented by "source" and "report quote" is the data table shown in fig. 7, and the data in each column in the data table may be regarded as an original report data item. Then it can be known from the functional relationship "group (extbizType)", the functional relationship needs to use data under the extbizType item in the index of the field Amount, and the corresponding field is queried from the original index according to Amount and extbizType, first "alias" can be queried, then the service dimensions "extbizType" _ notNull ", and _ notNull mean that the value of the item cannot be null, and may be any other value, for example, 1, 2, 7, etc. Further, according to the data query address in the original index 630, corresponding data is obtained, for example, data under the service dimension of extBizType obtained by querying in the data table shown in fig. 7 is 1, 2, 3, and 4.
In some embodiments, referring to fig. 6, the reporting configuration may further configure a time type corresponding to the obtained original reporting data, for example, referring to "timelness" at the top of the reporting configuration of fig. 6, which may represent a time level of the obtained data, for example, 1d represents data of a certain day, and 5m represents data within 5 minutes.
In some embodiments, the data in the raw report data items may come from various data sources, such as an online data source, an offline data source, a manual data source, an index data source, and the like. The processing device can read the data in the original report data item from the database or the storage device.
Step 304, processing the original report data item based on the function relationship configured in the derived index and associated with the original index, and determining the target report data.
In some implementations, processing the raw report data item may refer to processing all data under the data item according to a functional relationship in the derivative index.
In some embodiments, the functional relationships associated with the original metric may include at least a sum function, a difference function, a percentage function, a grouping function, a renaming function, a comparability function, and a cumulative function. For example only, the functional relationship may be represented in the report configuration in the following manner: the summation function can be expressed as add (a, b, c), which represents the summation operation performed on the indexes a, b, c; the percentage function may be expressed as "divide (a, b, c)", which means dividing the index a by the index b, and "c" represents a data type, e.g., boolean type, and respectively represents different meanings, such as a calculation percentage when the value of "c" is "true" and a non-calculation percentage when the value of "c" is "false"; the grouping function can be expressed as group (a, b), "a" is the index name to be grouped, and "b" is the type of grouping; the rename function may be denoted rename (a, b), meaning that the name of pointer a is replaced with the name of pointer b; the scale function may be represented as yoy (a, b, c), representing the calculation of the scale of index a relative to index b within the period index c; the accumulation function may be represented as acum (a, b, c), which represents that the indexes a, b, c are accumulated according to time and then are subjected to accumulation operation.
It should be noted that the above representation of the functional relationship is only for the purpose of example, and may be represented in other ways in other embodiments, which are not limited in this specification.
In this embodiment, by means of a configured report design, target report data used for generating a report may be directly obtained, a logic of intermediate conversion processing on original data used for generating a report is converted into a report configuration setting, an index may be dynamically loaded, analyzed, and executed according to parameters of a front end, and then a data result used for generating a report is generated.
FIG. 4 is an exemplary flow diagram illustrating the determination of target reporting data according to further embodiments of the present description. In some embodiments, flow 400 may be performed by a processing device (e.g., server 110). For example, the process 400 may be stored in a storage device (e.g., an onboard storage unit of a processing device or an external storage device) in the form of a program or instructions that, when executed, may implement the process 400. In some embodiments, the process 400 may be performed by the third determining module 540, and the process 400 may include the following operations.
The report data result refers to a result obtained after processing the data under the original report data item according to the processing logic of the functional relationship. Such as the result of summing, accumulating, etc., the data of the original report data items.
In some embodiments, the processing device (the third determining module 540) may calculate or process the data under the original report data item based on the functional relationship, and obtain the report data result. For more details on the functional relationship and the processing of the data items, reference may be made to the related description of fig. 3, which is not repeated here.
In some embodiments, the processing device may determine whether there is a data loss by traversing or analyzing the report data results. For example, if the report data result includes data of 1 month, 2 months, 3 months, 5 months, and 6 months of 2020, the processing device may determine that data of 4 months of 2020 is missing in the report data result by traversing each data. For another example, if the data in quarter 1, quarter 3, and quarter 4 of 2020 is included in the report data result, the processing device may determine that the data in quarter 2 of 2020 is missing from the report data result.
After determining that there is data missing, step 406 may be executed, and if it is determined that there is no data missing, the report data result may be directly used as the target report data.
And 406, generating a supplementary time point corresponding to the data missing, and adding the supplementary time point to the report data result.
In some embodiments, the report may include a graph, for example, a line graph, a bar graph, or the like, and if there is data missing in the report data used to generate the report, the graph in the finally generated report may be incomplete, for example, lines in the line graph are discontinuous. Therefore, the finally generated graph can be more complete by judging whether the report data result has data loss or not, generating a supplementary time point corresponding to the lost data under the condition of determining that the data loss exists, and adding the supplementary time point into the report data result.
The supplement time point is a supplement to the time corresponding to the missing data. For example, following the example in step 404, if the data of month 2020 4 is missing from the report data result, the corresponding time point of month 2020 4 can be added to the report data result, so that in the broken line graph of the finally obtained report, the jump from month 3 to month 5 will not occur, and the line will be continuous.
Further, in some embodiments, if the missing data is determined by other means (e.g., obtaining from other data sources or manually supplementing the predicted data, etc.), the missing data may also be supplemented, so that the finally generated report is more complete.
And step 408, determining the target report data based on the report data result after the supplementary time point is added.
In some embodiments, the processing device may directly take the report data result after adding the supplementary time point as the target report data. For more description of the target report data, reference may be made to the associated description of fig. 2 and 3.
In some embodiments, the processing device may further perform data structure simplification processing on the report data result, and use the report data result after simplification processing as the target report data.
The data structure reduction process may be to classify, combine, and/or extract the data. For example, the reporting data results include sales revenue data for a certain product from 4 different merchants from 1 month to 3 months in 2020. Since the sales income data come from different merchants, the sales income data of each merchant includes time, amount and commodity type. Illustratively, 4 different sales channels are indicated by letters A, B, C, D, respectively; s represents the sales amount. The result of the report data for merchant A is (A)11 month, S1) (ii) a The result of the report data of the merchant B is (B, 1 month, S)2) (ii) a The result of the report data of the merchant C is (C, 1 month, S)3) (ii) a The result of the report data for the merchant D is (D, 1 month, S)4). 2. The 3-month data is not shown here, and is similar to the previous description, and is not described here again. In the above data, although the observation result of the data of each merchant is clear, it is not convenient to generate a report, and the data structure is complex. Thus, data structure simplification may be performed on the data of various merchants, for example, combining different merchant extractions together as (A, B, C, D); the time is (1 month, 2 months and 3 months); the sales amount is (S)1、S2、S3、S4). It can be understood that the result of the simplified processing on the data structure is more convenient for generating the report, for example, a report graph can be generated by taking time as an abscissa and sales revenue data as an ordinate. After the data structure is simplified and processed, the data size can be smaller, the simplified and processed target report data is not only convenient to read and analyze, but also can be transmitted more quickly at the front end and the rear end, so that the aim of improving the report generation efficiency can be fulfilled in a mode of sending the target report data to a front-end generated report.
FIG. 5 is a block diagram of a system for automatically generating reports based on a report configuration, according to some embodiments of the present description. As shown in fig. 5, the system 500 may include a loading module 510, a first determining module 520, a second determining module 530, and a third determining module 540.
The loading module 510 may be configured to load the report configuration associated with the report generation request upon receiving the report generation request.
In some embodiments, the configured report configuration may be stored in a database or a storage device in advance, and after receiving the report generation request, the loading module 510 may complete loading by reading the report configuration from the database or the storage device.
The first determining module 520 may be configured to determine a derived index based on the report generation request and the report configuration; wherein, the function relation related to the original index is configured in the derived index.
In some embodiments, the first determining module 520 may further determine a report parameter index in a report configuration based on the report generation request; and determining a derivative index based on the report parameter index. The original index refers to a data item associated with the original data of the report. The raw index may be used to obtain raw data items that are logically processed according to a functional relationship in the derived index. The derived index is a field representation of the data item after logical processing of data corresponding to the data item of the original index.
The second determination module 530 may be configured to determine the original metric based on the derived metric and the functional relationship.
In some embodiments, the second determination module 530 may determine the original metric according to a configured functional relationship in the derived metric. The functional relationship is a representation of functional information for logically processing original data for generating a report, and an index name corresponding to the original data is included in the functional relationship, so that the original index can be determined by querying the original index configured in the report according to the index name.
The third determining module 540 may be configured to determine target report data for generating a report based on the derived index and the original index, and automatically generate a report based on the target report data.
In some embodiments, the third determining module 540 may perform a query according to a field in the original indicator, and obtain an original report data item for generating a report. Further, after the original report data item is obtained, according to the functional relation in the derived index, the data of the original report data item is logically processed, and the target report data for generating the report is obtained.
In some embodiments, the third determining module 540 may be further configured to obtain an original report data item based on the original index; and processing the original report data item based on the function relation which is configured in the derived indexes and is associated with the original indexes, and determining target report data. In some embodiments, the third determining module 540 may be further configured to process the original report data item based on the functional relationship, and determine a report data result; judging whether data loss exists in the report data result; if so, generating a supplementary time point corresponding to the data missing, and adding the supplementary time point to the report data result; and determining target report data based on the report data result after the supplementary time point is added. In some embodiments, the third determining module 540 may further be configured to perform data structure simplification processing on the report data result, and determine the target report data.
For more description of each module of the system shown in fig. 5, reference may be made to a flowchart portion of this specification, for example, the related description of fig. 2 to fig. 4, which is not repeated herein.
It should be understood that the system and its modules shown in FIG. 5 may be implemented in a variety of ways. For example, in some embodiments, the system and its modules may be implemented in hardware, software, or a combination of software and hardware. Wherein the hardware portion may be implemented using dedicated logic; the software portions may be stored in a memory for execution by a suitable instruction execution system, such as a microprocessor or specially designed hardware. Those skilled in the art will appreciate that the methods and systems described above may be implemented using computer executable instructions and/or embodied in processor control code, such code being provided, for example, on a carrier medium such as a diskette, CD-or DVD-ROM, a programmable memory such as read-only memory (firmware), or a data carrier such as an optical or electronic signal carrier. The system and its modules in this specification may be implemented not only by hardware circuits such as very large scale integrated circuits or gate arrays, semiconductors such as logic chips, transistors, or programmable hardware devices such as field programmable gate arrays, programmable logic devices, etc., but also by software executed by various types of processors, for example, or by a combination of the above hardware circuits and software (e.g., firmware).
It should be noted that the above description of the system 500 for automatically generating reports according to a report configuration and the modules thereof is only for convenience of description, and is not intended to limit the present disclosure within the scope of the illustrated embodiments. It will be appreciated by those skilled in the art that, given the teachings of the present system, any combination of modules or sub-system configurations may be used to connect to other modules without departing from such teachings. For example, in some embodiments, the loading module 510, the first determining module 520, the second determining module 530, and the third determining module 540 disclosed in fig. 5 may be different modules in a system, or may be a module that implements the functions of two or more modules described above. For example, the loading module 510 and the first determining module 520 may be two modules, or one module may have both the acquiring and adjusting functions. Each module in the system 500 for automatically generating a report according to report configuration may share one storage module, and each module may also have its own storage module. Such variations are within the scope of the present disclosure.
The embodiment of the specification further provides a device for automatically generating the report according to the report configuration, which comprises a processor, wherein the processor is used for executing the method for automatically generating the report according to the report configuration.
The embodiment of the specification also provides a computer readable storage medium. The storage medium stores computer instructions, and after the computer reads the computer instructions in the storage medium, the computer can execute the method for automatically generating the report according to the report configuration.
The beneficial effects that may be brought by the embodiments of the present description include, but are not limited to: different types of reports can be generated by flexibly setting each index in the report configuration, one report configuration corresponds to multiple reports, and the workload of report generation and development is reduced. The report development can be completed without code development by configuring the report configuration by the developer, so that the time cost of the developer is saved, and the efficiency of the report development is improved. It is to be noted that different embodiments may produce different advantages, and in different embodiments, any one or combination of the above advantages may be produced, or any other advantages may be obtained.
Having thus described the basic concept, it will be apparent to those skilled in the art that the foregoing detailed disclosure is to be regarded as illustrative only and not as limiting the present specification. Various modifications, improvements and adaptations to the present description may occur to those skilled in the art, although not explicitly described herein. Such modifications, improvements and adaptations are proposed in the present specification and thus fall within the spirit and scope of the exemplary embodiments of the present specification.
Also, the description uses specific words to describe embodiments of the description. Reference throughout this specification to "one embodiment," "an embodiment," and/or "some embodiments" means that a particular feature, structure, or characteristic described in connection with at least one embodiment of the specification is included. Therefore, it is emphasized and should be appreciated that two or more references to "an embodiment" or "one embodiment" or "an alternative embodiment" in various places throughout this specification are not necessarily all referring to the same embodiment. Furthermore, some features, structures, or characteristics of one or more embodiments of the specification may be combined as appropriate.
Moreover, those skilled in the art will appreciate that aspects of the present description may be illustrated and described in terms of several patentable species or situations, including any new and useful combination of processes, machines, manufacture, or materials, or any new and useful improvement thereof. Accordingly, aspects of this description may be performed entirely by hardware, entirely by software (including firmware, resident software, micro-code, etc.), or by a combination of hardware and software. The above hardware or software may be referred to as "data block," module, "" engine, "" unit, "" component, "or" system. Furthermore, aspects of the present description may be represented as a computer product, including computer readable program code, embodied in one or more computer readable media.
The computer storage medium may comprise a propagated data signal with the computer program code embodied therewith, for example, on baseband or as part of a carrier wave. The propagated signal may take any of a variety of forms, including electromagnetic, optical, etc., or any suitable combination. A computer storage medium may be any computer-readable medium that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code located on a computer storage medium may be propagated over any suitable medium, including radio, cable, fiber optic cable, RF, or the like, or any combination of the preceding.
Computer program code required for the operation of various portions of this specification may be written in any one or more programming languages, including an object oriented programming language such as Java, Scala, Smalltalk, Eiffel, JADE, Emerald, C + +, C #, VB.NET, Python, and the like, a conventional programming language such as C, VisualBasic, Fortran2003, Perl, COBOL2002, PHP, ABAP, a dynamic programming language such as Python, Ruby, and Groovy, or other programming languages, and the like. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or processing device. In the latter scenario, the remote computer may be connected to the user's computer through any network format, such as a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet), or in a cloud computing environment, or as a service, such as a software as a service (SaaS).
Additionally, the order in which the elements and sequences of the process are recited in the specification, the use of alphanumeric characters, or other designations, is not intended to limit the order in which the processes and methods of the specification occur, unless otherwise specified in the claims. While various presently contemplated embodiments of the invention have been discussed in the foregoing disclosure by way of example, it is to be understood that such detail is solely for that purpose and that the appended claims are not limited to the disclosed embodiments, but, on the contrary, are intended to cover all modifications and equivalent arrangements that are within the spirit and scope of the embodiments herein. For example, although the system components described above may be implemented by hardware devices, they may also be implemented by software-only solutions, such as installing the described system on an existing processing device or mobile device.
Similarly, it should be noted that in the preceding description of embodiments of the present specification, various features are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure aiding in the understanding of one or more of the embodiments. This method of disclosure, however, is not intended to imply that more features than are expressly recited in a claim. Indeed, the embodiments may be characterized as having less than all of the features of a single embodiment disclosed above.
Numerals describing the number of components, attributes, etc. are used in some embodiments, it being understood that such numerals used in the description of the embodiments are modified in some instances by the use of the modifier "about", "approximately" or "substantially". Unless otherwise indicated, "about", "approximately" or "substantially" indicates that the number allows a variation of ± 20%. Accordingly, in some embodiments, the numerical parameters used in the specification and claims are approximations that may vary depending upon the desired properties of the individual embodiments. In some embodiments, the numerical parameter should take into account the specified significant digits and employ a general digit preserving approach. Notwithstanding that the numerical ranges and parameters setting forth the broad scope of the range are approximations, in the specific examples, such numerical values are set forth as precisely as possible within the scope of the application.
For each patent, patent application publication, and other material, such as articles, books, specifications, publications, documents, etc., cited in this specification, the entire contents of each are hereby incorporated by reference into this specification. Except where the application history document does not conform to or conflict with the contents of the present specification, it is to be understood that the application history document, as used herein in the present specification or appended claims, is intended to define the broadest scope of the present specification (whether presently or later in the specification) rather than the broadest scope of the present specification. It is to be understood that the descriptions, definitions and/or uses of terms in the accompanying materials of this specification shall control if they are inconsistent or contrary to the descriptions and/or uses of terms in this specification.
Finally, it should be understood that the embodiments described herein are merely illustrative of the principles of the embodiments of the present disclosure. Other variations are also possible within the scope of the present description. Thus, by way of example, and not limitation, alternative configurations of the embodiments of the specification can be considered consistent with the teachings of the specification. Accordingly, the embodiments of the present description are not limited to only those embodiments explicitly described and depicted herein.
Claims (16)
1. A method for automatically generating reports from a report configuration, the method comprising:
after receiving a report generation request, loading report configuration associated with the report generation request;
determining a derivative index based on the report generation request and the report configuration; wherein, a functional relation associated with the original index is configured in the derived index;
determining an original index based on the derived index and the functional relation;
and determining target report data for generating a report based on the derived index and the original index, and automatically generating the report based on the target report data.
2. The method of claim 1, wherein determining a derivative metric based on the report generation request and the report configuration comprises:
determining report parameter indexes in the report configuration based on the report generation request;
and determining the derived index based on the report parameter index.
3. The method of claim 1, wherein determining target reporting data based on the derived metrics and the original metrics comprises:
acquiring an original report data item based on the original index;
and processing the original report data item based on the function relation configured in the derived index and associated with the original index, and determining the target report data.
4. The method of claim 3, the functional relationship associated with the original metric comprising at least one or more of the following functions:
a sum function, a difference function, a percentage function, a grouping function, a renaming function, a comparability function, and an accumulation function.
5. The method of claim 1, further comprising:
and the processor for executing the functional relation associated with the original index is written in groovy language.
6. The method of claim 3, wherein the processing the original reporting data item based on the functional relationship associated with the original index configured in the derived index to determine the target reporting data comprises:
processing the original report data item based on the functional relation to determine a report data result;
judging whether the report data result has data loss or not;
if so, generating a supplementary time point corresponding to the data missing, and adding the supplementary time point to the report data result;
and determining the target report data based on the report data result after the supplementary time point is added.
7. The method of claim 6, further comprising:
and carrying out data structure simplification processing on the report data result, and determining the target report data.
8. A system for automatically generating reports from a report configuration, the system comprising:
the loading module is used for loading the report configuration associated with the report generation request after receiving the report generation request;
the first determination module is used for determining a derivative index based on the report generation request and the report configuration; wherein, a functional relation associated with the original index is configured in the derived index;
a second determination module, configured to determine an original indicator based on the derived indicator and the functional relationship;
and the third determination module is used for determining target report data used for generating a report based on the derived index and the original index, and automatically generating the report based on the target report data.
9. The system of claim 8, the first determination module further to:
determining report parameter indexes in the report configuration based on the report generation request;
and determining the derived index based on the report parameter index.
10. The system of claim 8, the third determination module further to:
acquiring an original report data item based on the original index;
and processing the original report data item based on the function relation configured in the derived index and associated with the original index, and determining the target report data.
11. The system of claim 10, the functional relationship associated with the original metric comprising at least one or more of the following functions:
a sum function, a difference function, a percentage function, a grouping function, a renaming function, a comparability function, and an accumulation function.
12. The system of claim 8, the third determination module further to:
and the processor executing the functional relation associated with the original index is written in groovy language.
13. The system of claim 10, the third determination module further to:
processing the original report data item based on the functional relation to determine a report data result;
judging whether the report data result has data loss or not;
if so, generating a supplementary time point corresponding to the data missing, and adding the supplementary time point to the report data result;
and determining the target report data based on the report data result after the supplementary time point is added.
14. The system of claim 13, the third determination module further to:
and carrying out data structure simplification processing on the report data result, and determining the target report data.
15. An apparatus for automatically generating reports from a report configuration, comprising a processor configured to perform the method of any of claims 1-7.
16. A computer-readable storage medium storing computer instructions which, when read by a computer, cause the computer to perform the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011181311.4A CN112199930A (en) | 2020-10-29 | 2020-10-29 | Method and system for automatically generating report according to report configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011181311.4A CN112199930A (en) | 2020-10-29 | 2020-10-29 | Method and system for automatically generating report according to report configuration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112199930A true CN112199930A (en) | 2021-01-08 |
Family
ID=74011121
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011181311.4A Pending CN112199930A (en) | 2020-10-29 | 2020-10-29 | Method and system for automatically generating report according to report configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112199930A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113255307A (en) * | 2021-06-15 | 2021-08-13 | 国能信控互联技术有限公司 | Intelligent reporting method and system for power system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190034247A1 (en) * | 2017-07-31 | 2019-01-31 | Splunk Inc. | Creating alerts associated with a data storage system based on natural language requests |
| CN109344374A (en) * | 2018-08-22 | 2019-02-15 | 中国平安人寿保险股份有限公司 | Report generation method and device, electronic equipment based on big data, storage medium |
| CN110246018A (en) * | 2019-05-17 | 2019-09-17 | 阿里巴巴集团控股有限公司 | Report generation device, method and equipment |
| CN111177231A (en) * | 2019-12-20 | 2020-05-19 | 中国建设银行股份有限公司 | Report generation method and report generation device |
| CN111626028A (en) * | 2020-05-29 | 2020-09-04 | 深圳前海微众银行股份有限公司 | Report generation method, device and equipment based on function analysis and computer medium |
-
2020
- 2020-10-29 CN CN202011181311.4A patent/CN112199930A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190034247A1 (en) * | 2017-07-31 | 2019-01-31 | Splunk Inc. | Creating alerts associated with a data storage system based on natural language requests |
| CN109344374A (en) * | 2018-08-22 | 2019-02-15 | 中国平安人寿保险股份有限公司 | Report generation method and device, electronic equipment based on big data, storage medium |
| CN110246018A (en) * | 2019-05-17 | 2019-09-17 | 阿里巴巴集团控股有限公司 | Report generation device, method and equipment |
| CN111177231A (en) * | 2019-12-20 | 2020-05-19 | 中国建设银行股份有限公司 | Report generation method and report generation device |
| CN111626028A (en) * | 2020-05-29 | 2020-09-04 | 深圳前海微众银行股份有限公司 | Report generation method, device and equipment based on function analysis and computer medium |
Non-Patent Citations (1)
| Title |
|---|
| 姚永锋;: "火灾大数据统计分析系统的设计与研究", 中国新通信, no. 18, 20 September 2020 (2020-09-20) * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113255307A (en) * | 2021-06-15 | 2021-08-13 | 国能信控互联技术有限公司 | Intelligent reporting method and system for power system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200218737A1 (en) | Method, system and program product for matching of transaction records | |
| US9355160B2 (en) | Automated data analysis | |
| US10963144B2 (en) | Graphically organizing content in a user interface to a software application | |
| US20070239742A1 (en) | Determining data elements in heterogeneous schema definitions for possible mapping | |
| US10636086B2 (en) | XBRL comparative reporting | |
| US20230360145A1 (en) | Method and system for processing transactions based on transaction archetypes | |
| CN112559524A (en) | Index database establishing method and device and storage medium | |
| CN111104426A (en) | Data query method and system | |
| CN114416891B (en) | Method, system, apparatus and medium for data processing in a knowledge graph | |
| CN110489418B (en) | Data aggregation method and system | |
| CN113515544B (en) | Data attribute query method and data attribute query device | |
| CN114741392A (en) | Data query method and device, electronic equipment and storage medium | |
| US8688499B1 (en) | System and method for generating business process models from mapped time sequenced operational and transaction data | |
| CN112199930A (en) | Method and system for automatically generating report according to report configuration | |
| CN112597168A (en) | Processing method, device and platform of multi-source customer data and storage medium | |
| CN114995877B (en) | Variable configuration method and device | |
| US20200013075A1 (en) | System and method for correlating and enhancing data obtained from distributed sources in a network of distributed computer systems | |
| CN112905677A (en) | Data processing method and device, service processing system and computer equipment | |
| CN111260384A (en) | Service order processing method and device, electronic equipment and storage medium | |
| CN114997109A (en) | Receipt conversion method and device, computer equipment and storage medium | |
| US11144520B2 (en) | Information system with versioning descending node snapshot | |
| US9489438B2 (en) | Systems and methods for visualizing master data services information | |
| CN114265856A (en) | Method and device for providing data service and electronic equipment | |
| CN113947334A (en) | Configurable power transaction risk monitoring method and device and computer equipment | |
| CN116361270A (en) | Data comparison method, terminal equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 40044671 Country of ref document: HK |
|
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20240226 Address after: Room 1408, No. 447 Nanquan North Road, China (Shanghai) Pilot Free Trade Zone, Pudong New Area, Shanghai, 200120 Applicant after: Shanghai Ant Chuangjiang Information Technology Co.,Ltd. Country or region after: China Address before: 310000 801-11 section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province Applicant before: Alipay (Hangzhou) Information Technology Co.,Ltd. Country or region before: China |