CN114004208B - Method for constructing report template of flexibly customized electric power marketing system - Google Patents
Method for constructing report template of flexibly customized electric power marketing system Download PDFInfo
- Publication number
- CN114004208B CN114004208B CN202111214773.6A CN202111214773A CN114004208B CN 114004208 B CN114004208 B CN 114004208B CN 202111214773 A CN202111214773 A CN 202111214773A CN 114004208 B CN114004208 B CN 114004208B
- Authority
- CN
- China
- Prior art keywords
- dimension
- data
- template
- spreadsheet
- constructing
- 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
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000011161 development Methods 0.000 claims abstract description 5
- 238000004590 computer program Methods 0.000 claims description 12
- 230000005611 electricity Effects 0.000 claims 2
- 238000010276 construction Methods 0.000 claims 1
- 238000007405 data analysis Methods 0.000 abstract description 3
- 239000000047 product Substances 0.000 description 21
- 238000007726 management method Methods 0.000 description 10
- 238000004458 analytical method Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 239000006227 byproduct Substances 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 239000000126 substance Substances 0.000 description 2
- 239000003513 alkali Substances 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013524 data verification Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Primary Health Care (AREA)
- Entrepreneurship & Innovation (AREA)
- Water Supply & Treatment (AREA)
- Game Theory and Decision Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Public Health (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for constructing a report template of a flexibly customized electric power marketing system, which comprises the following steps: determining the number of dimension columns; integrating the involved dimension data into a spreadsheet; the method comprises the steps of grouping dimensions in an electronic form, and dividing the dimensions into different templates; assigning a unique code to each dimension template; adding a management unit column into the spreadsheet, and uniformly assigning value data to the column; building a table in a database by contrasting rows and columns of the spreadsheet; importing the integrated dimension data source into a development tool through a spreadsheet; constructing a template table in a database through Cartesian product, and determining that each management unit can acquire data of all dimensions; the template table is used as a main table association index data table to form a target table and is applied to reports and other products. The invention solves the problems of dimension loss and dimension data confusion in the product display process, and provides important guarantee and support for data analysis and decision making of the headquarters of the national network and business personnel.
Description
Technical Field
The invention relates to computer science, in particular to a method for constructing a report template of a flexibly customized electric power marketing system.
Background
The data center station is a main department for data processing, summarizing, statistics and analysis of the national network, and provides data support for the national network in the aspects of decision analysis, operation management and the like mainly through products such as reports, signboards, monitoring subjects and the like.
After marketing 2.0 is on line, in order to respond to the requirement of the national network headquarters, the data center develops a set of fixed reports for checking various data and analyzing the current situation of the national network and a big report for performing business logic check and data comparison on the 1.0 report. When two sets of reports are displayed, dimension data are found to be disordered, the hierarchy and logic relation between the dimensions cannot be guaranteed, and therefore the report data cannot be used for statistical analysis and the reports cannot be reported. Similar problems are found in the development and verification processes of other products, and due to the fact that the dimension relation is disordered, statistical data are deviated and cannot be used as effective data for statistical analysis. Meanwhile, it is found that when data corresponding to a certain dimension in the bottom layer data is empty, the dimension is lost when the data is displayed on the interface, so that the conditions that the dimension cannot correspond to the data, the interface display is disordered and the like occur.
In the report reporting process, the hierarchy and logic relationship of the dimensionality cannot be guaranteed, so that the hierarchy relationship is disordered when the report is displayed, the position of the dimensionality of the first-level industry is exchanged with the position of the subordinate industry, and the first-level industry which is supposed to be located above the second-level industry is displayed below the second-level industry, as shown in fig. 2.
In addition, when the billboard product is displayed in an application mode, the fact that when data corresponding to a certain dimension in bottom-layer data is empty, the dimension can be lost when the data is displayed on an interface is found, and therefore the situation that the dimension cannot correspond to the data and the interface display is disordered occurs.
Disclosure of Invention
The purpose of the invention is as follows: the invention aims to provide a method for constructing a report template of a power marketing system, which can be flexibly customized, so that the problems of dimension loss and dimension data confusion in the product display process are solved.
The technical scheme is as follows: in order to solve the problems that dimension data are disordered and disordered, the hierarchical relation is disordered, dimension loss occurs when dimension corresponding indexes have no data and the like during product display of reports, signboards and the like in a data center, and the national network service analysis and decision making are influenced, the invention creates a template table association method which can meet the requirements of different products in a marketing system and constructs a plurality of dimension-based tables. The template table is used for solving a plurality of problems of dimensionality, and effective and accurate support is provided for data analysis and verification of the national network.
The templates can be divided into several types (such as industry templates, user classification templates and the like) according to the front-end interface and different product requirements, and each template is assigned with a unique identifier for distinguishing different template data. Meanwhile, in order that all the common dimensions may correspond to each dimension data, each template must be cartesian-product with the common dimensions of the product (product to which the template table is applied). To this end, a complete template table has been formed. The template table is used as a main table and then is associated with other data tables, so that the problems that no hierarchical relation exists among dimensions during display and dimension data columns cannot be guaranteed not to be lost can be solved.
The existing report forms and billboard products of the data center all use template tables to ensure the format and accuracy of the data, only the dimension data used by the two template tables are different, the report form template ensures the accuracy of the industry dimension format, and the data in the template table is the all-industry dimension data. The billboard template table is used for ensuring that the data of the management unit is displayed normally and not lost, and the data in the template table is the data of the management unit. The method is characterized in that the method comprises the steps of storing needed different dimension data into a table through correlation, and then using the table as a main table to disassociate an index data table, so that the effect of a template table is realized, and the format and the accuracy of the dimension data are ensured.
The invention provides a method for constructing a report template of a flexibly customized electric power marketing system, which comprises the following steps:
(1) determining the number of dimension columns according to the dimensions of the product to be displayed and the hierarchical relationship among the dimensions;
(2) integrating the related dimension data into the electronic table according to the display dimension classification;
(3) the method comprises the steps that dimension data are grouped into different templates in an electronic form according to styles required to be displayed by products;
(4) assigning a unique code to each dimension template to ensure that dimension data cannot be repeated when being taken;
(5) adding a management unit column into the spreadsheet, uniformly assigning value data to the column, and generating Cartesian product with the management unit data;
(6) building a table in a database by contrasting rows and columns of the spreadsheet;
(7) importing the integrated dimension data source into a development tool through a spreadsheet;
(8) constructing a template table in a database through Cartesian product, and determining that each management unit can acquire data of all dimensions;
(9) the template table is used as a main table association index data table to form a target table and is applied to reports and other products.
A computer storage medium, on which a computer program is stored, wherein the computer program, when executed by a processor, implements the above method for constructing a flexibly customized report template of a power marketing system.
A computer device comprises a storage, a processor and a computer program which is stored on the storage and can be operated on the reprocessor, and when the processor executes the computer program, the method for constructing the report template of the flexibly customized electric power marketing system is realized.
Has the beneficial effects that: compared with the prior art, the invention has the following advantages: 1. the problems of dimension loss and dimension data confusion in the product display process are successfully solved; 2. the report of the fixed report form and the big report form and the normal display of the billboard product are ensured, and important guarantee and support are provided for the data analysis and decision making of the national network headquarters and business personnel.
Drawings
FIG. 1 is a flow chart of steps;
FIG. 2 is a display of the secondary industry chlor-alkali and primary chemical feedstock and chemical manufacturing industry interface;
FIG. 3 is dimensional data presented at the front end;
FIG. 4 is a template table structure;
FIG. 5 is a dimensional data source before import, with the table structure consistent with the table build statement;
FIG. 6 is a method of associating usage of a template table: the unique property is ensured by associating template table numbers, management unit codes and dimension column codes;
FIG. 7 shows the effect achieved through the template table, with no loss of dimension and guaranteed dimension hierarchy.
Detailed Description
The technical scheme of the invention is further explained by combining the attached drawings.
As shown in fig. 1, the method for constructing a report template of a flexibly customized power marketing system according to the present invention includes the following steps:
(1) determining the number of dimension columns according to the dimensions to be displayed of the product and the hierarchical relationship among the dimensions, for example: the industry dimension is divided into 4 corresponding dimension columns, and the dimension columns are divided into 4 columns;
(2) integrating the related dimension data into the spreadsheet according to the display dimension classification, as shown in FIG. 3;
(3) the method comprises the steps that dimension data are grouped into different templates in an electronic form according to styles required to be displayed by products;
(4) assigning a unique code to each dimension template to ensure that dimension data can not be repeated when being taken;
(5) adding a management unit column into the spreadsheet, uniformly assigning value data to the column, and generating Cartesian product with the management unit data;
(6) tabulating against the rows and columns of the spreadsheet in the database, as shown in FIG. 4;
(7) importing the integrated dimension data source into a development tool through a spreadsheet, as shown in FIG. 5;
(8) constructing a template table in a database through Cartesian product, and determining that each management unit can acquire data of all dimensions;
(9) the template table is used as a main table association index data table to form a target table, and is applied to reports and other products, and the association method is shown in fig. 6.
The technical implementation effect diagram of the invention is shown in FIG. 7.
A computer storage medium, on which a computer program is stored, wherein the computer program, when executed by a processor, implements the above method for constructing a flexibly customized report template of a power marketing system.
A computer device comprises a storage, a processor and a computer program which is stored on the storage and can run on the processor, and the processor executes the computer program to realize the method for constructing the report template of the flexibly customized electric power marketing system.
Claims (4)
1. A method for constructing a report template of a flexibly customized electric power marketing system is characterized by comprising the following steps:
(1) determining the number of dimension columns according to the dimensions to be displayed of the product and the hierarchical relationship among the dimensions;
(2) integrating the related dimension data into the electronic table according to the display dimension classification;
(3) the method comprises the steps that dimensionality data are grouped into different templates in an electronic form according to a style required to be displayed by a product;
(4) assigning a unique code to each dimension template to ensure that dimension data can not be repeated when being taken;
(5) adding a management unit column into the spreadsheet, uniformly assigning value data to the column, and generating Cartesian product with the management unit data;
(6) building a table in a database by contrasting rows and columns of the spreadsheet;
(7) importing the integrated dimension data source into a development tool through a spreadsheet;
(8) constructing a template table in a database through Cartesian product, and determining that each management unit can acquire data of all dimensions;
(9) the template table is used as a main table association index data table to form a target table and is applied to reports and other products.
2. The method for constructing report template of electric power marketing system according to claim 1, wherein the number of dimension columns in step (1) is the same as the number of dimension hierarchy levels.
3. A computer storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements a flexible customized electricity marketing system report template building method according to any one of claims 1-2.
4. A computer device comprising a memory, a processor, and a computer program stored on the memory and executable on the reprocessor, wherein the processor when executing the computer program implements a flexible customized electricity marketing system report template construction method according to any of claims 1-2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111214773.6A CN114004208B (en) | 2021-10-19 | 2021-10-19 | Method for constructing report template of flexibly customized electric power marketing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111214773.6A CN114004208B (en) | 2021-10-19 | 2021-10-19 | Method for constructing report template of flexibly customized electric power marketing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114004208A CN114004208A (en) | 2022-02-01 |
| CN114004208B true CN114004208B (en) | 2022-09-09 |
Family
ID=79923252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111214773.6A Active CN114004208B (en) | 2021-10-19 | 2021-10-19 | Method for constructing report template of flexibly customized electric power marketing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114004208B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN104391948A (en) * | 2014-12-01 | 2015-03-04 | 广东电网有限责任公司清远供电局 | Data standardization construction method and system of data warehouse |
| CN105183917A (en) * | 2015-10-15 | 2015-12-23 | 国家电网公司 | Multi-dimensional analysis method for multi-level storage data |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN111427626A (en) * | 2020-03-26 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Method and system for rapidly generating report based on dimensional data warehouse |
| CN111444177A (en) * | 2020-03-02 | 2020-07-24 | 北京深演智能科技股份有限公司 | Method and device for configuring report |
| CN112527812A (en) * | 2020-12-04 | 2021-03-19 | 北京顺达同行科技有限公司 | Data permission processing method and device based on multiple dimensions and computer equipment |
| CN112966482A (en) * | 2021-02-10 | 2021-06-15 | 中国工商银行股份有限公司 | Report generation method, device and equipment |
-
2021
- 2021-10-19 CN CN202111214773.6A patent/CN114004208B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN104391948A (en) * | 2014-12-01 | 2015-03-04 | 广东电网有限责任公司清远供电局 | Data standardization construction method and system of data warehouse |
| CN105183917A (en) * | 2015-10-15 | 2015-12-23 | 国家电网公司 | Multi-dimensional analysis method for multi-level storage data |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN111444177A (en) * | 2020-03-02 | 2020-07-24 | 北京深演智能科技股份有限公司 | Method and device for configuring report |
| CN111427626A (en) * | 2020-03-26 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Method and system for rapidly generating report based on dimensional data warehouse |
| CN112527812A (en) * | 2020-12-04 | 2021-03-19 | 北京顺达同行科技有限公司 | Data permission processing method and device based on multiple dimensions and computer equipment |
| CN112966482A (en) * | 2021-02-10 | 2021-06-15 | 中国工商银行股份有限公司 | Report generation method, device and equipment |
Non-Patent Citations (3)
| Title |
|---|
| 基于 O LAP数据库的电力营销统计报表生成新方法;陈秀寓等;《电力系统及其自动化学报》;20030630;第15卷(第3期);83-87 * |
| 基于Doc模板的监测成果数据报表的自动生成方法研究;李超等;《现代测绘》;20201130;第43卷(第6期);37-40 * |
| 电力企业信息化系统主要报表展示;Leo.yuan;《https://blog.csdn.net/yuanziok/article/details/50316523》;20151215;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114004208A (en) | 2022-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9195952B2 (en) | Systems and methods for contextual mapping utilized in business process controls | |
| US10303705B2 (en) | Organization categorization system and method | |
| CN106202240A (en) | Materiel code data processing method and device | |
| US20130185309A1 (en) | Data quality analysis | |
| US11321356B2 (en) | Linking discrete dimensions to enhance dimensional analysis | |
| CN106909604B (en) | Automatic checking method and system for EXCEL form and ACCESS database based on rules | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| Wainer et al. | How productivity and impact differ across computer science subareas | |
| CN114637811A (en) | Data table entity relation graph generation method, device, equipment and storage medium | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN113342692A (en) | Test case automatic generation method and device, electronic equipment and storage medium | |
| CN114004208B (en) | Method for constructing report template of flexibly customized electric power marketing system | |
| Chan | Quality management | |
| CN113706019A (en) | Service capability analysis method, device, equipment and medium based on multidimensional data | |
| CN113760681A (en) | Unified SQL (structured query language) -based multi-source heterogeneous data quality verification method and system | |
| CN107193868B (en) | Data quality problem reporting system | |
| US20230080572A1 (en) | System and method to engineer user experience | |
| CN116303342B (en) | Reverse model construction method and system | |
| Jadraque | A phenomenological approach to predicting tuberculosis cases with an assessment of measurement errors | |
| Jangl | A comparison of the market orientation model in Czech and German high-tech companies | |
| CN115470865A (en) | Failure analysis standard process adjusting method and system | |
| CN117763002A (en) | Data table generation method and device, electronic equipment and storage medium | |
| CN114371869A (en) | Method and system for obtaining code accurate change information | |
| CN116166643A (en) | Data quality management method |
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 | ||
| CP03 | Change of name, title or address |
Address after: No. 19 Chengxin Avenue, Moling Street, Jiangning District, Nanjing City, Jiangsu Province, 211106 Patentee after: Nanjing Nanrui Ruizhong Data Co.,Ltd. Country or region after: China Patentee after: NARI Group Corp. Address before: No.180 software Avenue, Yuhuatai District, Nanjing City, Jiangsu Province, 210012 Patentee before: CHINA REALTIME DATABASE Co.,Ltd. Country or region before: China Patentee before: NARI Group Corp. |
|
| CP03 | Change of name, title or address |