CN107766308B - Report processing method and device - Google Patents
Report processing method and device Download PDFInfo
- Publication number
- CN107766308B CN107766308B CN201610701677.7A CN201610701677A CN107766308B CN 107766308 B CN107766308 B CN 107766308B CN 201610701677 A CN201610701677 A CN 201610701677A CN 107766308 B CN107766308 B CN 107766308B
- Authority
- CN
- China
- Prior art keywords
- data
- time
- report
- dimension
- real
- 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.)
- Active
Links
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
- 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/10—Office automation; Time management
Abstract
The invention relates to a method and a device for processing a report, wherein the method for processing the report comprises the following steps: dividing a data source of the report analysis system into a plurality of data sources, wherein each data source is connected with at least one preset database, and the plurality of data sources comprise at least one data source of historical data and at least one data source of real-time data; after a generation instruction of a data dimension report with a data time range is received, determining the data dimension of the data dimension report, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range comprises real-time according to a preset analysis rule; and if the data time range comprises real-time, extracting data in the data time range from the searched data source of the real-time data, and generating a data dimension report according to the extracted data. The invention can check and process real-time data, and can realize the check and processing of the report with multiple data dimensions by generating the data dimension report with different data dimensions.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a device for processing a report.
Background
At present, the report displayed by the Cognos system is a report based on a uniform metadata model, the uniform metadata model can provide a uniform and consistent view for applications, a user can define the report in a browser by himself, the report is flexible in format and rich in elements, and timely open Query can be performed through Query Studio. However, most of the existing Cognos systems create CUBE refresh by using FM packets as data sources, and are suitable for viewing and processing reports of historical data, and for data of the same day or in real time, it is difficult to view and process reports of multiple data dimensions.
Disclosure of Invention
The invention aims to provide a report processing method and a report processing device.
The technical scheme for solving the technical problems is as follows: a report processing method comprises the following steps:
s1, dividing a data source of a report analysis system into a plurality of data sources, wherein each data source is connected with at least one preset database in a butt joint mode, corresponds to at least one preset data dimension, corresponds to a data dimension report, and comprises at least one data source of historical data and at least one data source of real-time data;
s2, after receiving a generation instruction of a data dimension report with a data time range, determining the data dimension of the data dimension report, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range comprises real-time according to a preset analysis rule;
and S3, if the data time range comprises real-time, extracting the data in the data time range from the searched data source of the real-time data, and generating the data dimension report according to the extracted data.
Preferably, the data source of the real-time data corresponding to the determined data dimension is searched, and the data source of the historical data corresponding to the determined data dimension is also searched;
after the step S2, the method further includes:
and S4, if the data time range does not include real-time, extracting the data in the data time range from the searched data source of the historical data, and generating the data dimension report according to the extracted data.
Preferably, the step S1 includes:
s11, after receiving the setting instruction, generating a cognos management page corresponding to the report analysis system;
s12, receiving configuration information corresponding to the plurality of data sources set by a user based on the cognos management page, and dividing the data sources of the report analysis system into a plurality of data sources respectively based on the configuration information corresponding to the plurality of data sources.
Preferably, the step of analyzing whether the data time range includes real-time according to a preset analysis rule includes:
determining the latest time of the data time range, and analyzing whether the time interval between the latest time and the current time is greater than a preset threshold value;
if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time; and if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time.
The technical scheme for solving the technical problems is as follows: a processing apparatus of a report, the processing apparatus of the report comprising:
the report analysis system comprises a dividing module, a generating module and a processing module, wherein the dividing module is used for dividing a data source of the report analysis system into a plurality of data sources, each data source is in butt joint with at least one preset database, each data source corresponds to at least one preset data dimension, each data dimension corresponds to a data dimension report, and the plurality of data sources comprise at least one data source of historical data and at least one data source of real-time data;
the searching module is used for determining the data dimension of the data dimension report after receiving a generating instruction of the data dimension report with the data time range, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range comprises real-time according to a preset analysis rule;
and the first generation module is used for extracting the data in the data time range from the searched data source of the real-time data and generating the data dimension report according to the extracted data if the data time range comprises real-time.
Preferably, the searching module is further configured to search a data source of real-time data corresponding to the determined data dimension and also search a data source of historical data corresponding to the determined data dimension;
the processing device of the report further comprises: and the second generation module is used for extracting the data in the data time range from the searched data source of the historical data if the data time range does not include real-time, and generating the data dimension report according to the extracted data.
Preferably, the dividing into modules comprises:
the generating unit is used for generating a cognos management page corresponding to the report analysis system after receiving a setting instruction;
and the dividing unit is used for receiving configuration information corresponding to the plurality of data sources set by a user based on the cognos management page, and dividing the data sources of the report analysis system into the plurality of data sources respectively based on the configuration information corresponding to the plurality of data sources.
Preferably, the searching module is specifically configured to determine a latest time of the data time range, and analyze whether a time interval between the latest time and a current time is greater than a preset threshold; if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time; and if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time.
The invention has the beneficial effects that: the invention divides the data source into a plurality of data sources, the plurality of data sources comprise at least one data source of historical data and at least one data source of real-time data, each data source corresponds to at least one data dimension, in viewing real-time data, instructions for generating a data dimension report including real-time can be sent to obtain the data dimension report, and in particular, after the data dimension of the data dimension report is determined, searching a data source of the real-time data corresponding to the data dimension, extracting data in a data time range through the data source of the real-time data, thereby generating a data dimension report corresponding to the real-time data, facilitating the checking and processing of the real-time data, because each data dimension corresponds to one data dimension report, the checking and processing of the reports with multiple data dimensions can be realized by generating the data dimension reports with different data dimensions.
Drawings
FIG. 1 is a flowchart illustrating a report processing method according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of step S1 shown in FIG. 1;
FIG. 3 is a schematic structural diagram of a report processing apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural view of the module shown in fig. 3.
Detailed Description
The principles and features of this invention are described below in conjunction with the following drawings, which are set forth by way of illustration only and are not intended to limit the scope of the invention.
As shown in fig. 1, fig. 1 is a schematic flow chart of an embodiment of a report processing method of the present invention, and the report processing method includes the following steps:
step S1, dividing a data source of a report analysis system into a plurality of data sources, wherein each data source is connected with at least one preset database in a butt joint mode, each data source corresponds to at least one preset data dimension, each data dimension corresponds to a data dimension report, and the plurality of data sources comprise at least one data source of historical data and at least one data source of real-time data;
the data source is a path connected to the actual database, the data source does not have real data, only records which database is connected to and how the data source is connected, namely the data source is only the connection name of the database, and one database can have a plurality of data sources connected.
The embodiment is applied to the Cognos server, and the report analysis system runs in the Cognos server. The data source of the report analysis system is first divided into a plurality of data sources, for example, into 2 or more than 2 data sources. The cognos server can be logged in a webpage at the terminal, and an instruction is sent to the cognos server through the terminal, so that a data source of the report analysis system is divided into a plurality of data sources. Then, each data source is connected with at least one preset database, so that report data can be obtained from one or more corresponding databases through the data source; each data source corresponds to at least one preset data dimension, each data dimension corresponds to a data dimension report, and therefore report data corresponding to one or more data dimensions can be obtained from the database through the data sources.
For the data dimension, for example, there is a database storing sales reports of mobile phones across the country, and the fields are: the field product type, the area, the province, the city and the sales quarter are data dimensions (the sales condition of the mobile phone in the whole country can be analyzed through the reports corresponding to the data dimensions) except for the product number and the sales, and each data dimension corresponds to one data dimension report.
In addition, among the divided data sources, at least one of the divided data sources is a historical data source for obtaining reports of historical data, and at least one of the divided data sources is a real-time data source for obtaining reports of real-time data including the current day or more real-time data.
Step S2, after receiving a generation instruction of a data dimension report with a data time range, determining the data dimension of the data dimension report, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range includes real-time according to a preset analysis rule;
in this embodiment, after receiving the generation instruction of the data dimension report with the data time range, the report analysis system, for example, inputs the data time range "2016.1.1-2016.1.30" on the terminal, and sends the generation instruction of the data dimension report with the data time range to the report analysis system. After receiving the generation instruction, the report analysis system analyzes the generation instruction to determine a data dimension of the data dimension report, for example, a data dimension specified by a user or a system default data dimension is the data dimension of the data dimension report.
After the data dimension of the data dimension report is determined, searching a data source of the real-time data corresponding to the determined data dimension according to the corresponding relation between the data source and the data dimension, wherein in the determined data dimension, the determined data dimension may correspond to one data source of the real-time data, and the determined data dimension may also correspond to two or more data sources of the real-time data.
For example, for a sales report of a mobile phone nationwide, a data source of real-time data corresponding to data dimensions such as product types, regions, provinces, cities or sales quarters is searched. It should be noted that the database stores the received real-time data, and the report analysis system simultaneously corresponds the real-time data to the data source of the real-time data. And analyzing whether the data time range includes real-time or not according to a preset analysis rule while searching for a data source of the real-time data, wherein the data time range includes, for example, the time of the past 24 hours with the current time as an end point, and the data time range can be considered to include the real-time.
Step S3, if the data time range includes real-time, extracting data in the data time range from the searched data source of the real-time data, and generating the data dimension report according to the extracted data.
In this embodiment, if the data time range in the generation instruction includes real-time, the data in the data time range is extracted from the searched data source of the real-time data, for example, the current time is 2016.1.30, and if the received data time range is "2016.1.1-2016.1.30", the data time range includes real-time, the data in the data time range is extracted from the data source of the real-time data, and then, the data dimension report of the determined data dimension is generated according to the extracted data.
Compared with the prior art, the embodiment divides the data source into a plurality of data sources, wherein the plurality of data sources comprise at least one data source of historical data and at least one data source of real-time data, each data source corresponds to at least one data dimension, in viewing real-time data, instructions for generating a data dimension report including real-time can be sent to obtain the data dimension report, and in particular, after the data dimension of the data dimension report is determined, searching a data source of the real-time data corresponding to the data dimension, extracting data in a data time range through the data source of the real-time data, thereby generating a data dimension report corresponding to the real-time data, facilitating the checking and processing of the real-time data, because each data dimension corresponds to one data dimension report, the checking and processing of the reports with multiple data dimensions can be realized by generating the data dimension reports with different data dimensions.
In a preferred embodiment, on the basis of the embodiment of fig. 1, in the step S2, a data source of real-time data corresponding to the determined data dimension is searched, and a data source of historical data corresponding to the determined data dimension is also searched at the same time, after the step S2, the method further includes: and if the data time range does not include real-time, extracting the data in the data time range from the searched data source of the historical data, and generating the data dimension report according to the extracted data.
In this embodiment, after the data dimension of the data dimension report is determined, the data source of the real-time data corresponding to the determined data dimension is searched according to the corresponding relationship between the data source and the data dimension, and the data source of the historical data corresponding to the determined data dimension is searched at the same time, where, in the determined data dimension, the determined data dimension may correspond to one data source of the historical data, and the determined data dimension may also correspond to two or more data sources of the historical data.
In this embodiment, if the data time range does not include real-time, for example, the current time is "2016.2.10", and the received data time range is "2016.1.1-2016.1.30", because the time interval between the two is large, the data time range does not include real-time, and a data dimension report corresponding to real-time data does not need to be generated, at this time, after determining a data dimension corresponding to the data dimension report to be generated, a data source of historical data corresponding to the data dimension is searched, data in the data time range is extracted from the data source of the historical data, and the data dimension report is generated according to the extracted data.
In this embodiment, if the data time range in the received generation instruction includes real-time, data in the data time range is preferentially extracted from the data source of the real-time data to generate a data dimension report, and if the data time range does not include the real-time, data in the data time range is extracted from the data source of the historical data to generate a data dimension report, so as to perform viewing and processing.
In a preferred embodiment, as shown in fig. 2, on the basis of the embodiment of fig. 1, the step S1 includes:
s11, after receiving the setting instruction, generating a cognos management page corresponding to the report analysis system;
s12, receiving configuration information corresponding to the plurality of data sources set by a user based on the cognos management page, and dividing the data sources of the report analysis system into a plurality of data sources respectively based on the configuration information corresponding to the plurality of data sources.
In this embodiment, a setting instruction may be sent to the report analysis system by operating on the terminal, after receiving the setting instruction, the report analysis system generates a cognos management page, returns the generated cognos management page to the terminal and displays the cognos management page on the terminal, and a user operates the cognos management page displayed on the terminal and sets configuration information corresponding to a plurality of data sources, where the configuration information includes data source names, types and names of databases selected to be docked by each data source, and data dimensions corresponding to each data source. In addition, at least one data source of historical data is configured, and at least one data source of real-time data is configured. After receiving the configuration information sent by the terminal, the report analysis system divides the data source into a plurality of data sources according to the configuration information.
In a preferred embodiment, on the basis of the embodiment of fig. 1, the step of analyzing whether the data time range includes real-time according to a preset analysis rule in step S2 includes:
determining the latest time of the data time range, and analyzing whether the time interval between the latest time and the current time is greater than a preset threshold value;
if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time;
and if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time.
In this embodiment, when analyzing whether the data time range includes real-time according to a preset analysis rule, first determining the latest time of the data time range, for example, the latest time corresponding to the data time range "1/2016 to 1/30/2016" is "1/2016 to 30/2016", then acquiring the current time of the system, analyzing whether a time interval between the latest time and the current time is greater than a preset threshold, for example, the preset threshold is 24 hours, and if the time interval between the latest time and the current time is less than or equal to the preset threshold, the data time range includes real-time, for example, the current time is "1/2016 to 30", and then the data time range includes real-time. If the time interval between the latest time and the current time is greater than a preset threshold, for example, the current time is "2016, 2, and 10 days", then the data time range does not include the real-time.
In this embodiment, the time when the time interval between the latest time and the current time is less than or equal to the preset threshold is regarded as the real-time, so that the user can view or process the data of the current day or more in real time by generating the data dimension report corresponding to the real-time.
As shown in fig. 3, fig. 3 is a schematic structural diagram of an embodiment of a report processing device according to the present invention, where the report processing device includes:
a dividing module 101, configured to divide a data source of a report analysis system into multiple data sources, where each data source is docked with at least one predetermined database, each data source corresponds to at least one predetermined data dimension, each data dimension corresponds to a data dimension report, and the multiple data sources include at least one data source of historical data and at least one data source of real-time data;
the data source is a path connected to the actual database, the data source does not have real data, only records which database is connected to and how the data source is connected, namely the data source is only the connection name of the database, and one database can have a plurality of data sources connected.
The processing device of the report of the embodiment is integrated in the Cognos server, and the report analysis system runs in the processing device of the report. The data source of the report analysis system is first divided into a plurality of data sources, for example, into 2 or more than 2 data sources. The cognos server can be logged in a webpage at the terminal, and an instruction is sent to the cognos server through the terminal, so that a data source of the report analysis system is divided into a plurality of data sources. Then, each data source is connected with at least one preset database, so that report data can be obtained from one or more corresponding databases through the data source; each data source corresponds to at least one preset data dimension, each data dimension corresponds to a data dimension report, and therefore report data corresponding to one or more data dimensions can be obtained from the database through the data sources.
For the data dimension, for example, there is a database storing sales reports of mobile phones across the country, and the fields are: the field product type, the area, the province, the city and the sales quarter are data dimensions (the sales condition of the mobile phone in the whole country can be analyzed through the reports corresponding to the data dimensions) except for the product number and the sales, and each data dimension corresponds to one data dimension report.
In addition, among the divided data sources, at least one of the divided data sources is a historical data source and is used for acquiring reports of historical data, and at least one of the divided data sources is a real-time data source and is used for acquiring reports of real-time data.
The searching module 102 is configured to determine a data dimension of the data dimension report after receiving a generation instruction of the data dimension report with a data time range, search a data source of real-time data corresponding to the determined data dimension, and analyze whether the data time range includes real-time according to a preset analysis rule;
in this embodiment, after receiving the generation instruction of the data dimension report with the data time range, the report analysis system, for example, inputs the data time range "2016.1.1-2016.1.30" on the terminal, and sends the generation instruction of the data dimension report with the data time range to the report analysis system. After receiving the generation instruction, the report analysis system analyzes the generation instruction to determine a data dimension of the data dimension report, for example, a data dimension specified by a user or a system default data dimension is the data dimension of the data dimension report.
After the data dimension of the data dimension report is determined, searching a data source of the real-time data corresponding to the determined data dimension according to the corresponding relation between the data source and the data dimension, wherein in the determined data dimension, the determined data dimension may correspond to one data source of the real-time data, and the determined data dimension may also correspond to two or more data sources of the real-time data.
For example, for a sales report of a mobile phone nationwide, a data source of real-time data corresponding to data dimensions such as product types, regions, provinces, cities or sales quarters is searched. It should be noted that the database stores the received real-time data, and the report analysis system simultaneously corresponds the real-time data to the data source of the real-time data. And analyzing whether the data time range includes real-time or not according to a preset analysis rule while searching for a data source of the real-time data, wherein the data time range includes, for example, the time of the past 24 hours with the current time as an end point, and the data time range can be considered to include the real-time.
The first generating module 103 is configured to, if the data time range includes real-time, extract data in the data time range from the found data source of the real-time data, and generate the data dimension report according to the extracted data.
In this embodiment, if the data time range in the generation instruction includes real-time, the data in the data time range is extracted from the searched data source of the real-time data, for example, the current time is 2016.1.30, and if the received data time range is "2016.1.1-2016.1.30", the data time range includes real-time, the data in the data time range is extracted from the data source of the real-time data, and then, the data dimension report of the determined data dimension is generated according to the extracted data.
In a preferred embodiment, on the basis of the embodiment of fig. 3, the searching module 102 is further configured to search a data source of real-time data corresponding to the determined data dimension and also search a data source of historical data corresponding to the determined data dimension; the processing device of the report further comprises: and the second generation module is used for extracting the data in the data time range from the searched data source of the historical data if the data time range does not include real-time, and generating the data dimension report according to the extracted data.
In this embodiment, after the data dimension of the data dimension report is determined, the data source of the real-time data corresponding to the determined data dimension is searched according to the corresponding relationship between the data source and the data dimension, and the data source of the historical data corresponding to the determined data dimension is searched at the same time, where, in the determined data dimension, the determined data dimension may correspond to one data source of the historical data, and the determined data dimension may also correspond to two or more data sources of the historical data.
In this embodiment, if the data time range does not include real-time, for example, the current time is "2016.2.10", and the received data time range is "2016.1.1-2016.1.30", because the time interval between the two is large, the data time range does not include real-time, and a data dimension report corresponding to real-time data does not need to be generated, at this time, after determining a data dimension corresponding to the data dimension report to be generated, a data source of historical data corresponding to the data dimension is searched, data in the data time range is extracted from the data source of the historical data, and the data dimension report is generated according to the extracted data.
In this embodiment, if the data time range in the received generation instruction includes real-time, data in the data time range is preferentially extracted from the data source of the real-time data to generate a data dimension report, and if the data time range does not include the real-time, data in the data time range is extracted from the data source of the historical data to generate a data dimension report, so as to perform viewing and processing.
In a preferred embodiment, as shown in fig. 4, on the basis of the above-mentioned embodiment of fig. 3, the dividing module 101 comprises:
the generating unit 1011 is configured to generate a cognos management page corresponding to the report analysis system after receiving the setting instruction;
a dividing unit 1012, configured to receive, based on the cognos management page, configuration information corresponding to the plurality of data sources set by the user, and divide the data sources of the report analysis system into the plurality of data sources based on the configuration information corresponding to the plurality of data sources, respectively.
In this embodiment, a setting instruction may be sent to the report analysis system by operating on the terminal, after receiving the setting instruction, the report analysis system generates a cognos management page, returns the generated cognos management page to the terminal and displays the cognos management page on the terminal, and a user operates the cognos management page displayed on the terminal and sets configuration information corresponding to a plurality of data sources, where the configuration information includes data source names, types and names of databases selected to be docked by each data source, and data dimensions corresponding to each data source. In addition, at least one data source of historical data is configured, and at least one data source of real-time data is configured. After receiving the configuration information sent by the terminal, the report analysis system divides the data source into a plurality of data sources according to the configuration information.
In a preferred embodiment, on the basis of the embodiment of fig. 3, the search module 102 is specifically configured to determine a latest time of the data time range, and analyze whether a time interval between the latest time and a current time is greater than a preset threshold; if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time; and if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time.
In this embodiment, when analyzing whether the data time range includes real-time according to a preset analysis rule, first determining the latest time of the data time range, for example, the latest time corresponding to the data time range "1/2016 to 1/30/2016" is "1/2016 to 30/2016", then acquiring the current time of the system, analyzing whether a time interval between the latest time and the current time is greater than a preset threshold, for example, the preset threshold is 24 hours, and if the time interval between the latest time and the current time is less than or equal to the preset threshold, the data time range includes real-time, for example, the current time is "1/2016 to 30", and then the data time range includes real-time. If the time interval between the latest time and the current time is greater than a preset threshold, for example, the current time is "2016, 2, and 10 days", then the data time range does not include the real-time.
In this embodiment, the time when the time interval between the latest time and the current time is less than or equal to the preset threshold is regarded as the real-time, so that the user can view or process the data of the current day or more in real time by generating the data dimension report corresponding to the real-time.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (6)
1. The report processing method is characterized by comprising the following steps:
s1, dividing the data source of the report analysis system into a plurality of data sources, wherein the data source is a path connected to the actual database; each data source is in butt joint with at least one preset database, each data source corresponds to at least one preset data dimension, each data dimension corresponds to one data dimension report, and the data sources comprise at least one historical data source and at least one real-time data source;
s2, after receiving a generation instruction of a data dimension report with a data time range, determining the data dimension of the data dimension report, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range comprises real-time according to a preset analysis rule; the step of analyzing whether the data time range includes real-time according to a preset analysis rule includes: determining the latest time of the data time range, and analyzing whether the time interval between the latest time and the current time is greater than a preset threshold value; if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time; if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time;
and S3, if the data time range comprises real-time, extracting the data in the data time range from the searched data source of the real-time data, and generating the data dimension report according to the extracted data.
2. A report processing method according to claim 1, characterized in that said method searches for a data source of real-time data corresponding to a determined data dimension and also searches for a data source of historical data corresponding to a determined data dimension;
after the step S2, the method further includes:
and S4, if the data time range does not include real-time, extracting the data in the data time range from the searched data source of the historical data, and generating the data dimension report according to the extracted data.
3. A report processing method according to claim 1 or 2, said step S1 comprising:
s11, after receiving the setting instruction, generating a cognos management page corresponding to the report analysis system;
s12, receiving configuration information corresponding to the plurality of data sources set by a user based on the cognos management page, and dividing the data sources of the report analysis system into a plurality of data sources respectively based on the configuration information corresponding to the plurality of data sources.
4. A report processing apparatus, comprising:
the dividing module is used for dividing a data source of the report analysis system into a plurality of data sources, wherein the data source is a path connected to an actual database; each data source is in butt joint with at least one preset database, each data source corresponds to at least one preset data dimension, each data dimension corresponds to one data dimension report, and the data sources comprise at least one historical data source and at least one real-time data source;
the system comprises a searching module, a data dimension generating module and a data dimension analyzing module, wherein the searching module is used for determining the data dimension of a data dimension report after receiving a generation instruction of the data dimension report with a data time range, searching a data source of real-time data corresponding to the determined data dimension, and analyzing whether the data time range comprises real-time according to a preset analysis rule; if the time interval between the latest time and the current time is less than or equal to a preset threshold value, the data time range comprises real-time; if the time interval between the latest time and the current time is greater than a preset threshold value, the data time range does not include real-time;
and the first generation module is used for extracting the data in the data time range from the searched data source of the real-time data and generating the data dimension report according to the extracted data if the data time range comprises real-time.
5. The report processing apparatus according to claim 4, wherein the search module is further configured to search a data source of the real-time data corresponding to the determined data dimension and also search a data source of the historical data corresponding to the determined data dimension;
the processing device of the report further comprises: and the second generation module is used for extracting the data in the data time range from the searched data source of the historical data if the data time range does not include real-time, and generating the data dimension report according to the extracted data.
6. A report processing apparatus according to claim 4 or 5, characterized in that said dividing module comprises:
the generating unit is used for generating a cognos management page corresponding to the report analysis system after receiving a setting instruction;
and the dividing unit is used for receiving configuration information corresponding to the plurality of data sources set by a user based on the cognos management page, and dividing the data sources of the report analysis system into the plurality of data sources respectively based on the configuration information corresponding to the plurality of data sources.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610701677.7A CN107766308B (en) | 2016-08-22 | 2016-08-22 | Report processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610701677.7A CN107766308B (en) | 2016-08-22 | 2016-08-22 | Report processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107766308A CN107766308A (en) | 2018-03-06 |
| CN107766308B true CN107766308B (en) | 2021-11-26 |
Family
ID=61263993
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610701677.7A Active CN107766308B (en) | 2016-08-22 | 2016-08-22 | Report processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107766308B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113626477B (en) * | 2021-07-19 | 2023-10-10 | 浙江中控信息产业股份有限公司 | Configurable report system and method based on water plant Internet of Things system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101957849A (en) * | 2010-09-21 | 2011-01-26 | 用友软件股份有限公司 | Static statement generation method and device |
| CN104317957A (en) * | 2014-11-11 | 2015-01-28 | 中国建设银行股份有限公司 | Open platform and system for processing reports and report processing method |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN104881352A (en) * | 2015-06-03 | 2015-09-02 | 上海新炬网络信息技术有限公司 | System resource monitoring device based on mobile terminal |
| CN105158537A (en) * | 2015-10-11 | 2015-12-16 | 移康智能科技(上海)有限公司 | Intelligent ammeter |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7650198B2 (en) * | 2005-09-30 | 2010-01-19 | Rockwell Automation Technologies, Inc. | Automation system unified data access for disparate data sources |
| US8484150B2 (en) * | 2010-02-26 | 2013-07-09 | General Electric Company | Systems and methods for asset condition monitoring in electric power substation equipment |
-
2016
- 2016-08-22 CN CN201610701677.7A patent/CN107766308B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101957849A (en) * | 2010-09-21 | 2011-01-26 | 用友软件股份有限公司 | Static statement generation method and device |
| CN104317957A (en) * | 2014-11-11 | 2015-01-28 | 中国建设银行股份有限公司 | Open platform and system for processing reports and report processing method |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN104881352A (en) * | 2015-06-03 | 2015-09-02 | 上海新炬网络信息技术有限公司 | System resource monitoring device based on mobile terminal |
| CN105158537A (en) * | 2015-10-11 | 2015-12-16 | 移康智能科技(上海)有限公司 | Intelligent ammeter |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107766308A (en) | 2018-03-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110704411B (en) | Knowledge graph building method and device suitable for art field and electronic equipment | |
| CN104281672B (en) | Method and device for processing log data | |
| CN108073625B (en) | System and method for metadata information management | |
| CN103702053B (en) | Video storage and search method and system as well as monitoring system | |
| CN111740884B (en) | Log processing method, electronic equipment, server and storage medium | |
| CN107918618B (en) | Data processing method and device | |
| CN107885873B (en) | Method and apparatus for outputting information | |
| CN105138670A (en) | Audio file label generation method and system | |
| WO2015070735A1 (en) | Traffic quality analysis method and device | |
| CN104572782A (en) | Method and system for directional information pushing based on browser search | |
| CN102789487A (en) | Data query and retrieval processing device and data query and retrieval processing method | |
| CN104123318A (en) | Method and system for displaying interest points in map | |
| MX2020012092A (en) | System and method of geographic data aggregation and analysis. | |
| KR20170073693A (en) | Extracting similar group elements | |
| CN111159135A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN107766308B (en) | Report processing method and device | |
| CN114090589A (en) | Data query method and device based on HBase and computer equipment | |
| CN111064996B (en) | Method, system and storage medium for identifying user watching video content preference | |
| CN106547827B (en) | Target searching method and system based on multi-dimensional data collision | |
| CN112463872A (en) | Visual index data acquisition method, device, system and medium | |
| CN109783728B (en) | Page crawler rule updating method and system | |
| Benkhelifa et al. | Framework for mobile devices analysis | |
| CN105354265A (en) | Method and apparatus for automatically constructing association structure of delivered keyword | |
| CN105512270A (en) | Method and device for determining related objects | |
| CN105589863B (en) | Searching method, data processing method, device and system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |