Power transaction business report generation method based on data center

Abstract

The invention discloses a power transaction business report generation method based on a data center, and belongs to the technical field of report generation. Business data are analyzed and sorted to obtain an index list, and then the index list is sorted to obtain power transaction business indexes corresponding to all the business data; when the report is generated, the report template can be obtained only by matching the corresponding power transaction business indexes according to the business requirements, and authority configuration is performed on the report according to the user information, so that the step of preprocessing a large amount of business data when the report is generated is omitted, and the problem that the report cannot be generated due to large data volume of the power business data when the report is generated is solved. The problem that report generation efficiency is low due to the fact that the workload of data processing is high is solved, the report generation rate is increased, corresponding permissions are configured for users of different posts, the permission requirements of different users are met, and the security of report information is guaranteed.

Description

Technical Field

[0001] The present invention relates to the technical field of report generation, and in particular to a method for generating a report for an electric power trading business based on a data middle station. Background Art

[0002] With the advent of the Internet era, various businesses have emerged in an endless stream, and in many cases, they need to rely on the system to generate various reports in the form of Excel or Word. Reports can be used to perform statistics, differentiation, analysis, and estimation on data. For some industries, reports play an irreplaceable role. The power trading business involves many business modules and a large amount of data, so the demand for reports is also large. When generating reports, due to the large amount of data, a large number of report templates need to be generated when generating reports. The differences between most report templates are actually not large, but they still go through the complete report generation process in the report generation, which greatly wastes computing power and leads to low report generation efficiency. In addition, power trading covers multiple businesses such as trading, compliance, and settlement. Considering the security and compliance of the system content, it is necessary to control the permissions of the reports in the system. Different business personnel correspond to different report permissions. Accordingly, in order to achieve permission control of reports, developers need to configure the permissions of reports.

[0003] The Chinese patent, publication number: CN118820327A, discloses a report generation method and a report generation system, wherein a first server obtains a report keyword according to an acquired report generation instruction; based on the report keyword, when it is determined that a corresponding report template exists, the report template is sent to a second server; when it is determined that no corresponding report template exists, a target report template is generated according to the report keyword, and a second report is determined according to the target report template; after the second server receives the report template sent by the first server, based on the report template, when it is determined that a corresponding already generated report exists, the already generated report is returned to the first server as a first report; thereafter, the first server sends the first report or the second report to the user terminal, although the report generation cycle is reduced, but when faced with a large amount of power trading data, the calculation amount of determining the report template according to the report keyword may exceed the calculation load, and it is difficult to ensure the efficiency and accuracy of report generation for a large amount of data. Summary of the invention

[0004] In order to solve the problem of low report generation efficiency caused by the large amount of power business data and high data processing workload when generating existing power trading business reports, the present invention provides a power trading business report generation method based on a data middle station. An indicator list is obtained by analyzing and sorting the business data, and then the indicator list is sorted to obtain power trading business indicators corresponding to the full business data. When generating a report, it is only necessary to match the corresponding power trading business indicators according to business needs to obtain a report template, and the report is authorized according to user information, which eliminates the pre-processing steps of a large amount of business data when generating the report, improves the report generation rate, and when facing users in different positions, configures corresponding permissions to meet the permission requirements of different users, thereby ensuring the security of report information.

[0005] In a first aspect, a technical solution provided in an embodiment of the present invention is: a method for generating a power trading business report based on a data middle station, comprising the following steps: S1. Sort out the business data based on the data type and source of the business data to obtain a list of indicators; S2. Based on the indicator construction rules installed in the data center, the indicator list is sorted out to construct power trading business indicators; S3. Based on the current business needs, the business data is subjected to report generation rules to match the corresponding power trading business indicators in the power trading business indicator catalog to obtain a report template; the corresponding report permissions are configured based on the user information in the business needs; synchronously, a data matching mechanism is generated based on the report permissions and business data; S4. The business data obtains associated information in response to the data matching mechanism, fills the associated information into the report template, and configures corresponding report permissions based on the user information in the business requirements to obtain the target report.

[0006] In this scheme, since the amount of data in the power trading business is large, but the format and content type are relatively fixed, many processing steps are repetitive during processing. Therefore, by constructing an indicator list, when obtaining the power trading business data, directly pre-processing the business data according to the indicator list can simplify the data processing steps and calculation amount of such large data, improve the data processing speed and thus improve the report generation efficiency; the indicator list is sorted out through the indicator construction rules carried by the data middle platform to construct the power trading business indicators, and the business data is matched according to the power trading business indicators and business needs, and the power trading business indicators that meet the needs are extracted to obtain the report template. When generating the report, it is only necessary to fill the business data into the data column of the corresponding indicator in turn to complete the generation of the report content, which is equivalent to pre-processing all possible business data. The subsequent business data only needs to match the corresponding indicators according to the preset processing method, and fill in the business data under the data column of the corresponding indicator, which greatly improves the report generation rate, and at the same time ensures the one-to-one correspondence between the data and the data column, and ensures the accuracy of the report content; by configuring corresponding permissions when facing different users, the permission requirements of different users are met, and the security of the report information is guaranteed.

[0007] Preferably, in S1, sorting out the business data based on the data type and source of the business data to obtain an indicator list includes the following steps: Based on the set reading frequency, the content of the power trading business file is extracted to obtain business data, the indicator name to which the business data belongs is determined based on the data content and data type of the business data, and the indicator name is arranged in character order based on the indicator ID to obtain an indicator list.

[0008] In this solution, since the amount of business data is large and there are many sources of data, it would be a huge workload to analyze the business data every time a report is generated. Therefore, for business data with such a complex amount of data, all possible types and sources are pre-analyzed to build an indicator list. When the business data is obtained, the business data is sorted according to the data column corresponding to each indicator in the indicator list, so that the huge and unnecessary business data becomes more regular, reducing the difficulty of data query for subsequent selection of corresponding business data based on business needs to generate reports, thereby reducing the difficulty of report generation and improving the generation rate.

[0009] Preferably, the contents of the indicator list include at least indicator ID, indicator name, business type, reading frequency and data source.

[0010] In this solution, each indicator name corresponds to an indicator ID. Under each indicator name, there are at least three data columns: business type, reading frequency, and data source. The indicator name can be used to make a preliminary content summary of the business data. The reading frequency can be used to classify the business data according to the time dimension of the data. The data source can be used to classify the business data according to the reason why the data was generated. The content, time dimension, and reason why the business data was generated can be used to preliminarily lock the scope of the required data. Then, according to business needs, the locked data can be screened for the second time to obtain data that meets business needs, thereby improving the accuracy of data query and thus improving the accuracy of the content in the report.

[0011] As a preferred embodiment, in S2, the indicator list is sorted out based on the indicator construction rules carried by the data center to construct an indicator catalog for power trading business, including the following steps: The data center uses market service and power trading as screening conditions to screen the indicators in the indicator list to obtain market service indicators and power trading indicators, and arranges the names of market service indicators and power trading indicators in alphabetical order to obtain a power trading business indicator catalog; The market service indicators at least correspond to market registration data and service status data; the power transaction indicators at least correspond to intra-regional transaction data, inter-regional transaction data and retail transaction data.

[0012] In this solution, the unordered indicators in the indicator list are grouped based on market service and power trading categories as screening conditions. The data corresponding to the market service indicators are market registration data and service status data, and the data corresponding to the power trading indicators are intra-regional transaction data, inter-regional transaction data and retail transaction data. This allows staff to quickly query the required power trading business indicators according to business needs when generating reports, thereby improving the user experience.

[0013] Preferably, in S3, based on current business needs, the business data is subjected to report generation rules to match the corresponding power trading business indicators in the power trading business indicator catalog to obtain a report template, including the following steps: Based on the current business needs, the corresponding business data is screened, the power trading business indicators that match the business data are set as target business indicators, and the query links and judgment characters of the corresponding data are obtained based on the content of the target business indicators; Acquire the target power transaction business file based on the query link, perform field matching on the content of the target power transaction file based on the judgment character, and judge whether the business data matches the target business indicator based on the matching result; If there is a match, select the time zone and data display unit corresponding to the displayed data based on business needs, and configure the target business indicator into the initial template to obtain the report template.

[0014] In this solution, the business data is matched according to the content corresponding to the target business indicator. For example, if there is an indicator of the number of users who have checked the capped package in the indicator list, it is determined from which one or several power trading business files the data for this indicator needs to be obtained. Then it is determined which judgment character can determine whether the user has checked the capped package, and then it is determined whether it is necessary to display the data for each month or the data up to this year, and then it is determined what unit needs to be displayed. The matching process is from shallow to deep, ensuring that there will be no errors in the target business indicators and the corresponding business data, and ensuring the accuracy of the report content.

[0015] Preferably, in S3, corresponding report permissions are configured based on user information in business requirements, including the following steps: selecting a corresponding basic permission template based on the business department in the business requirements, obtaining a user ID and a user rank based on the user information in the business requirements, selecting permissions in the basic permission template based on the user rank and associating the user ID with the selected permissions to obtain user permissions; and configuring permissions for the target report based on the user permissions.

[0016] In this solution, since some content in the power trading business data involves security and privacy, the report permissions are configured according to different users. Users with different permissions can query the report content of the corresponding permissions, which can effectively prevent data leakage and ensure the security and privacy of data. At the same time, some users with high permissions can adjust the permissions of users with low permissions, making the report permission configuration more flexible and ensuring the safe and efficient operation of the power trading system.

[0017] Preferably, the data columns in the initial template include at least power trading business indicators, data content, data source and data type.

[0018] In this solution, the power trading business indicator column is used to fill in the indicators corresponding to the imported business data, the data content column is used to fill in the content of the imported business data, the data source column is used to fill in the source of the imported business data, and the data type column is used to fill in the type of the imported business data. Through these columns, the business data can be roughly displayed clearly and intuitively, making the generated report content intuitive and clear.

[0019] Preferably, the report template is synchronously saved in the data center after being generated, and the report template saved in the data center is used as the historical report template. If the degree of similarity between the current business demand and the historical business demand corresponding to the historical report template exceeds the set threshold, the historical report template is selected as the current report template or the target business indicator in the historical report template that does not match the current business demand is modified, and the modified historical report template is used as the current report template.

[0020] In this solution, since many business requirements corresponding to the power trading business are the same or similar, the business requirements for each report generation are also roughly the same. If the report template needs to be regenerated for each requirement, human resources will be invested in simple and repetitive work, which greatly reduces the report generation efficiency. Therefore, in order to further improve the report generation rate, the report template generated each time is saved. When the subsequent business requirements are the same or similar to the historical business requirements, the corresponding historical report template is modified or directly used, which can speed up the generation rate of the report template, thereby improving the report generation efficiency while ensuring the accuracy of the report content.

[0021] Preferably, in S4, the business data obtains the associated information in response to the data matching mechanism, and fills the associated information into the report template, including the following steps: Obtain the data volume of business data corresponding to each power trading business indicator, sort the power trading business indicators based on the data volume to obtain matching priorities, and fill the associated data of the corresponding power trading business indicators into the corresponding data columns in the report template in sequence based on the matching priorities; If the matching priorities are the same, business data matching is performed based on the ratio of the permissions of the associated data to the total number of report permissions.

[0022] In this solution, in order to improve the speed and accuracy of data import during the report generation process, it is taken into consideration that some data in the report cannot be displayed to most users due to report permissions, and most of this data is important data. This type of data can only be displayed to a few users with high permissions. The data that most users can see is public data, which will be observed by a large number of users. In order to meet the needs of most users, this type of data needs to be imported into the report first, so that users can obtain the information they need at the first time. The data that only a few people can observe can have its import order postponed. Even if the import speed of some important data is slower than that of public data, it will not affect the user experience of the report for most users. In this way, the report generation speed can be greatly improved while meeting the needs of most users and the normal use of the report.

[0023] Preferably, the power trading business document includes at least power market operation rules, power trading contracts and market analysis and operation requirements.

[0024] In this solution, the power trading business data comes from the power trading business files. The power trading business depends on the power market operation rules, power trading contracts and market analysis and operation needs. Therefore, the business data can be analyzed according to the content characteristics of these files to improve data processing efficiency and increase the rate of indicator list generation.

[0025] Beneficial effects of the present invention: (1) By constructing an index list, the present invention can directly pre-process the business data according to the index list when acquiring power trading business data, thereby simplifying the data processing steps and calculation amount for such data with a large amount of data, thereby improving the data processing speed and thus improving the report generation efficiency; (2) The present invention organizes the indicator list through the indicator construction rules carried by the data middle platform to construct the power trading business indicators, and matches the business data according to the power trading business indicators and business needs, extracts the power trading business indicators that meet the needs to obtain a report template, and when generating a report, it only needs to fill the business data into the data column of the corresponding indicator in sequence to complete the generation of the report content, which is equivalent to pre-processing all possible business data. The subsequent business data only needs to match the corresponding indicator according to the preset processing method, and fill the business data in the data column of the corresponding indicator, which greatly improves the report generation rate; (3) The present invention ensures the security of report information by configuring corresponding permissions when facing users in different positions to meet the permission requirements of different users; (4) When generating a report template, the present invention analyzes the current business demand. If the current business demand is similar to the historical business demand, the historical report template corresponding to the historical business demand is directly selected as the target report template or the historical report template is modified. The more types of historical report templates are saved, the faster the subsequent report generation rate is, which further improves the report generation efficiency.

[0026] The above invention content is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Other features, objects and advantages of the present invention will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings. The drawings are only for the purpose of illustrating preferred embodiments and are not to be considered as limiting the present invention. Also, the same reference symbols are used throughout the drawings to represent the same parts.

[0028] Figure 1 This is a flow chart of a method for generating a power trading business report based on a data middle station in the present invention. DETAILED DESCRIPTION

[0029] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific implementation method described herein is only an optimal embodiment of the present invention, which is only used to explain the present invention and does not limit the scope of protection of the present invention. All other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0030] Before discussing the exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flow charts. Although the flow charts describe the operations (or steps) as sequential processes, many of the operations (or steps) therein can be implemented in parallel, concurrently, or simultaneously. In addition, the order of the operations can be rearranged. The process can be terminated when its operation is completed, but can also have additional steps not included in the drawings; the process can correspond to a method, function, procedure, subroutine, subprogram, etc.

[0031] Example: Figure 1 As shown, in order to solve the problem of low report generation efficiency caused by the large amount of power business data and high data processing workload when generating existing power trading business reports, this embodiment provides a method for generating power trading business reports based on a data middle station, including the following steps: S1: Sort the business data based on its data type and source to obtain a list of indicators.

[0032] In this embodiment, the business data is sorted out based on the data type and source of the business data to obtain an indicator list, including the following steps: Based on the set reading frequency, the content of the power trading business file is extracted to obtain business data, the indicator name to which the business data belongs is determined based on the data content and data type of the business data, and the indicator name is arranged in character order based on the indicator ID to obtain an indicator list.

[0033] In this embodiment, since the amount of business data is large and the data comes from many sources, the workload of analyzing the business data every time a report is generated is relatively large. Therefore, for business data with such a complex data volume, all possible types and sources are pre-analyzed to build an indicator list. When the business data is obtained, the business data is sorted according to the data columns corresponding to each indicator in the indicator list, so that the huge and unnecessary business data becomes more regular, and the difficulty of data query for subsequent selection of corresponding business data based on business needs to generate reports is reduced, thereby reducing the difficulty of report generation and improving the generation rate.

[0034] In this embodiment, the content in the indicator list at least includes an indicator ID, an indicator name, a business type, a reading frequency, and a data source.

[0035] In this embodiment, each indicator name corresponds to an indicator ID, and each indicator name has at least three data columns: business type, reading frequency, and data source. The indicator name can be used to make a preliminary content summary of the business data, the reading frequency can be used to classify the business data according to the time dimension of the data, and the data source can be used to classify the business data according to the reason why the data was generated. The content, time dimension, and reason why the business data was generated can be used to preliminarily lock the scope of the required data, and then the locked data can be secondary screened according to business needs to obtain data that meets the business needs, thereby improving the accuracy of data query and thus improving the accuracy of the content in the report.

[0036] S2: Based on the indicator construction rules carried by the data center, the indicator list is sorted and a catalog of power trading business indicators is constructed.

[0037] In this embodiment, the indicator list is sorted out based on the indicator construction rules carried by the data center to construct the power trading business indicator directory, including the following steps: The data center uses market service and power trading as screening conditions to screen the indicators in the indicator list to obtain market service indicators and power trading indicators, and arranges the names of market service indicators and power trading indicators in alphabetical order to obtain a power trading business indicator catalog; The market service indicators at least correspond to market registration data and service status data; the power transaction indicators at least correspond to intra-regional transaction data, inter-regional transaction data and retail transaction data.

[0038] This embodiment groups the unordered indicators in the indicator list based on market service and power trading categories as screening conditions, wherein the data corresponding to the market service indicators are market registration data and service status data, and the data corresponding to the power trading indicators are intra-regional transaction data, inter-regional transaction data and retail transaction data. This allows staff to quickly query required power trading business indicators according to business needs when generating reports, thereby improving the user experience.

[0039] S3: Based on the current business needs, the business data is subjected to report generation rules to match the corresponding power trading business indicators in the power trading business indicator catalog to obtain a report template; the corresponding report permissions are configured based on the user information in the business needs; synchronously, a data matching mechanism is generated based on the report permissions and business data.

[0040] In this embodiment, based on the current business needs, the business data is subjected to report generation rules to match the corresponding power trading business indicators in the power trading business indicator catalog to obtain a report template, including the following steps: Based on the current business needs, the corresponding business data is screened, the power trading business indicators that match the business data are set as target business indicators, and the query links and judgment characters of the corresponding data are obtained based on the content of the target business indicators; Acquire the target power transaction business file based on the query link, perform field matching on the content of the target power transaction file based on the judgment character, and judge whether the business data matches the target business indicator based on the matching result; If there is a match, select the time zone and data display unit corresponding to the displayed data based on business needs, and configure the target business indicator into the initial template to obtain the report template.

[0041] This embodiment matches the business data according to the content corresponding to the target business indicator. For example, if there is an indicator of the number of users who have checked the capped package in the indicator list, it is determined from which one or several power trading business files the data of the indicator needs to be obtained. Then it is determined which judgment character can be used to determine whether the user has checked the capped package. It is then determined whether it is necessary to display the data for each month or the data up to this year. It is then determined what unit needs to be displayed. The matching process is from shallow to deep, ensuring that there will be no errors in the target business indicators and the corresponding business data, and ensuring the accuracy of the report content.

[0042] In this embodiment, corresponding report permissions are configured based on user information in business requirements, including the following steps: selecting a corresponding basic permission template based on the business department in the business requirements, obtaining a user ID and a user rank based on the user information in the business requirements, selecting permissions in the basic permission template based on the user rank and associating the user ID with the selected permissions to obtain user permissions; and configuring permissions for the target report based on the user permissions.

[0043] In this embodiment, since part of the content in the power trading business data involves security and privacy, the report permissions are configured according to different users. Users with different permissions can query the report content of the corresponding permissions, which can effectively prevent data leakage and ensure the security and privacy of the data. At the same time, some users with high permissions can adjust the permissions of users with low permissions, so that the report permission configuration is more flexible, ensuring the safe and efficient operation of the power trading system.

[0044] In this embodiment, the data columns in the initial template at least include power trading business indicators, data content, data source and data type.

[0045] In this embodiment, the power trading business indicator column is used to fill in the indicators corresponding to the imported business data, the data content column is used to fill in the content of the imported business data, the data source column is used to fill in the source of the imported business data, and the data type column is used to fill in the type of the imported business data. Through these columns, the business data can be roughly displayed clearly and intuitively, making the generated report content intuitive and clear.

[0046] In this embodiment, the report template is saved synchronously in the data center after being generated, and the report template saved in the data center is used as the historical report template. If the degree of similarity between the current business demand and the historical business demand corresponding to the historical report template exceeds the set threshold, the historical report template is selected as the current report template or the target business indicator in the historical report template that does not match the current business demand is modified, and the modified historical report template is used as the current report template.

[0047] In this embodiment, since many business requirements corresponding to the power trading business are the same or similar, the business requirements for each report generation are also roughly the same. If the report template needs to be regenerated for each requirement, human resources will be invested in simple and repetitive work, which greatly reduces the report generation efficiency. Therefore, in order to further improve the report generation rate, the report template generated each time is saved. When the subsequent business requirements are the same or similar to the historical business requirements, the corresponding historical report template is modified or directly used, which can speed up the generation rate of the report template, thereby improving the report generation efficiency while ensuring the accuracy of the report content.

[0048] S4: The business data obtains associated information in response to the data matching mechanism, and fills the associated information into the report template to obtain the target report.

[0049] In this embodiment, the business data obtains the associated information in response to the data matching mechanism, and fills the associated information into the report template, including the following steps: Obtain the data volume of business data corresponding to each power trading business indicator, sort the power trading business indicators based on the data volume to obtain matching priorities, and fill the associated data of the corresponding power trading business indicators into the corresponding data columns in the report template in sequence based on the matching priorities; If the matching priorities are the same, business data matching is performed based on the ratio of the permissions of the associated data to the total number of report permissions.

[0050] In order to improve the speed and accuracy of data import during the report generation process, this embodiment takes into account that some data in the report cannot be displayed to most users due to report permissions, and most of this data is important data, which can only be displayed to a few users with high permissions. The data that most users can see is public data, which will be observed by a large number of users. In order to meet the needs of most users, this data needs to be imported into the report first, so that users can obtain the information they need at the first time. The data that only a few people can observe can have its import order postponed. Even if the import speed of some important data is slower than that of public data, it will not affect the report experience for most users. In this way, the report generation speed can be greatly improved while meeting the needs of most users and the normal use of the report.

[0051] In this embodiment, the power trading business file at least includes power market operation rules, power trading contracts and market analysis and operation requirements.

[0052] In this embodiment, the power trading business data comes from the power trading business files. The power trading business depends on the power market operating rules, power trading contracts and market analysis and operation needs. Therefore, the business data can be analyzed according to the content characteristics of these files to improve data processing efficiency and increase the index list generation rate.

[0053] In this embodiment, since the amount of data in the power trading business is large, but the format and content type are relatively fixed, many processing steps are relatively repetitive during processing. Therefore, by constructing an indicator list, when obtaining power trading business data, directly pre-processing the business data according to the indicator list can simplify the data processing steps and calculation amount of such large data, improve the data processing speed and thus improve the report generation efficiency; the indicator list is sorted out by the indicator construction rules carried by the data middle platform to construct power trading business indicators, and the business data is matched according to the power trading business indicators and business needs, and the power trading business indicators that meet the needs are extracted to obtain a report template. When generating a report, it is only necessary to fill the business data into the data column of the corresponding indicator in turn to complete the generation of the report content, which is equivalent to pre-processing all possible business data. The subsequent business data only needs to match the corresponding indicator according to the preset processing method, and fill the business data in the data column of the corresponding indicator, which greatly improves the report generation rate, and at the same time ensures the one-to-one correspondence between data and data columns, and ensures the accuracy of the report content; by configuring corresponding permissions when facing different users, the permission requirements of different users are met, and the security of report information is guaranteed.

[0054] It can be seen from the above embodiments that at least the following substantial effects are achieved: (1) The present invention constructs an index list. When acquiring power trading business data, the business data can be directly pre-processed according to the index list, which can simplify the data processing steps and calculation amount for such data with a large amount of data, thereby improving the data processing speed and thus improving the report generation efficiency; (2) The present invention organizes the indicator list through the indicator construction rules carried by the data middle platform to construct the power trading business indicators, and matches the business data according to the power trading business indicators and business needs, extracts the power trading business indicators that meet the needs to obtain a report template, and when generating a report, it only needs to fill the business data into the data column of the corresponding indicator in sequence to complete the generation of the report content, which is equivalent to pre-processing all possible business data. The subsequent business data only needs to match the corresponding indicator according to the preset processing method, and fill the business data in the data column of the corresponding indicator, which greatly improves the report generation rate; (3) The present invention ensures the security of report information by configuring corresponding permissions when facing users in different positions to meet the permission requirements of different users; (4) When generating a report template, the present invention analyzes the current business demand. If the current business demand is similar to the historical business demand, the historical report template corresponding to the historical business demand is directly selected as the target report template or the historical report template is modified. The more types of historical report templates are saved, the faster the subsequent report generation rate is, which further improves the report generation efficiency.

[0055] The specific implementation described above is a preferred implementation of a method for generating power trading business reports based on a data middle station in the present invention. It is not intended to limit the specific implementation scope of the present invention. The scope of the present invention includes but is not limited to this specific implementation. All equivalent changes made in accordance with the shape and structure of the present invention are within the protection scope of the present invention.

Claims

1. A method for generating a power trading business report based on a data middle station, characterized in that: The following steps are involved: S1. Sort out the business data based on the data type and source of the business data to obtain a list of indicators; S2. Based on the indicator construction rules installed in the data center, the indicator list is sorted out to build a power trading business indicator catalog; S3. Based on current business needs, the report generation rules are used to match the corresponding power trading business indicators in the power trading business indicator catalog to obtain a report template; Configure corresponding report permissions based on user information in business requirements; Synchronously, a data matching mechanism is generated based on report permissions and business data; S4. The business data obtains associated information in response to the data matching mechanism, and fills the associated information into the report template to obtain the target report.

2. According to claim 1, a method for generating a power trading business report based on a data middle station is characterized in that: In S1, the business data is sorted out based on the data type and source of the business data to obtain an indicator list, including the following steps: extracting the content of the power trading business file based on the set reading frequency to obtain the business data, judging the indicator name to which the business data belongs based on the data content and data type of the business data, and arranging the indicator names based on the character order of the indicator ID to obtain an indicator list.

3. According to claim 2, a method for generating a power trading business report based on a data middle station is characterized in that: The content of the indicator list includes at least indicator ID, indicator name, business type, reading frequency and data source.

4. According to claim 1, a method for generating a power trading business report based on a data middle station is characterized in that: In S2, the indicator list is sorted out based on the indicator construction rules carried by the data center to construct the power trading business indicator catalog, including the following steps: The data center uses market service and power trading as screening conditions to screen the indicators in the indicator list to obtain market service indicators and power trading indicators, and arranges the names of market service indicators and power trading indicators in alphabetical order to obtain a power trading business indicator catalog; The market service indicators at least correspond to market registration data and service status data; the power transaction indicators at least correspond to intra-regional transaction data, inter-regional transaction data and retail transaction data.

5. According to claim 1, a method for generating a power trading business report based on a data middle station is characterized in that: In S3, based on the current business needs, the business data is matched with the corresponding power trading business indicators using the report generation rules to obtain the report template, including the following steps: Based on the current business needs, the corresponding business data is screened, the power trading business indicators that match the business data are set as target business indicators, and the query links and judgment characters of the corresponding data are obtained based on the content of the target business indicators; Acquire the target power transaction business file based on the query link, perform field matching on the content of the target power transaction file based on the judgment character, and judge whether the business data matches the target business indicator based on the matching result; If there is a match, select the time zone and data display unit corresponding to the displayed data based on business needs, and configure the target business indicator into the initial template to obtain the report template.

6. According to claim 1, a method for generating a power trading business report based on a data middle station is characterized in that: In S3, configure the corresponding report permissions based on the user information in the business requirements, including the following steps: Select the corresponding basic permission template based on the business department in the business requirements, obtain the user ID and user rank based on the user information in the business requirements, select the permissions in the basic permission template based on the user rank and associate the user ID with the selected permissions to obtain the user permissions; configure permissions for the target report based on the user permissions.

7. According to claim 4, a method for generating a power trading business report based on a data middle station is characterized in that: The data columns in the initial template include at least power trading business indicators, data content, data source and data type.

8. According to claim 4, a method for generating a power trading business report based on a data middle station is characterized in that: After the report template is generated, it is synchronously saved in the data center. The report template saved in the data center is used as the historical report template. If the degree of similarity between the current business demand and the historical business demand corresponding to the historical report template exceeds the set threshold, the historical report template is selected as the current report template or the target business indicator in the historical report template that does not match the current business demand is modified, and the modified historical report template is used as the current report template.

9. The method for generating a power trading business report based on a data middle station according to claim 1 is characterized in that: In S4, the business data obtains the associated information in response to the data matching mechanism, and fills the associated information into the report template, including the following steps: Obtain the data volume of business data corresponding to each power trading business indicator, sort the power trading business indicators based on the data volume to obtain matching priorities, and fill the associated data of the corresponding power trading business indicators into the corresponding data columns in the report template in sequence based on the matching priorities; If the matching priorities are the same, business data matching is performed based on the ratio of the permissions of the associated data to the total number of report permissions.

10. A method for generating a power trading business report based on a data middle station according to claim 2 or 5, characterized in that: The power trading business documents at least include power market operation rules, power trading contracts and market analysis and operation requirements.

Images