Novel electricity marketing system report template construction method capable of being flexibly customized

The invention discloses a novel electricity marketing system report template construction method capable of being flexibly customized. The method comprises the following steps of determining the number of dimension columns; integrating the related dimension data into a spreadsheet; grouping the dimensions in the spreadsheet, 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 according to the rows and columns of the spreadsheet; importing an integrated dimension data source into a development tool through the spreadsheet; constructing a template table in the database through a Cartesian product, and determining that each management unit can obtain the data of all dimensions. The template table serves as a main table and is associated with an index data table to form a target table, and is applied to reports and other produc