CN112765159A

CN112765159A - Report generation method, system, computer equipment and storage medium

Info

Publication number: CN112765159A
Application number: CN202011607893.8A
Authority: CN
Inventors: 宋悦; 杨俊颖; 郭青; 王善为
Original assignee: Yidu Cloud Beijing Technology Co Ltd
Current assignee: Yidu Cloud Beijing Technology Co Ltd
Priority date: 2020-12-30
Filing date: 2020-12-30
Publication date: 2021-05-07

Abstract

The disclosure relates to the technical field of data analysis, and provides a report generation method, a report generation system, computer equipment and a storage medium. The report generation method comprises the following steps: obtaining an initial header having an index region and a dimension region; in response to the configuration operation of the index area, combining the category cells of the target index according to the configured index classification structure to generate a composite index; performing overlapping check on the dimensionality associated with the target index to generate a dimensionality set commonly associated with the composite index; generating a target dimension in response to a configuration operation of the dimension region based on the set of dimensions; and generating an initial report with a composite header according to the composite index and the target dimension. The method supports flexible configuration of indexes/dimensions, can automatically generate the composite header according to user requirements, meets the data export requirements of users on multi-index/multi-dimension combination, can simultaneously carry out data validity verification based on the index and dimension combination, and improves report generation efficiency.

Description

Report generation method, system, computer equipment and storage medium

Technical Field

The present disclosure relates to the field of data analysis technologies, and in particular, to a report generation method, a report generation system, a computer device, and a storage medium.

Background

In the field of data analysis, data content of certain indexes based on certain dimensions is often required to be exported to generate a report so as to facilitate subsequent further analysis and processing. Wherein the dimensions represent the way the data is classified and the index represents the value of the data in a particular dimension.

At present, a relatively common report exporting method generally exports data based on fixed indexes and fixed dimensions in a fixed form, and has the following problems:

firstly, the header of the fixed form cannot be flexibly configured, and the data export requirement of a user based on multi-index/multi-dimension combination cannot be met; if a user needs a composite header report with different index dimension combinations, the customized development is carried out by writing SQL sentences, which wastes labor cost;

secondly, effective combination of indexes and dimensions cannot be realized, a user cannot check the data effectiveness of different index dimension combinations in the customized development process, and an invalid report with a lot of redundant data or a lot of vacant data is generated instead after complicated writing.

It is noted that the information disclosed in the background section above is only for enhancement of understanding of the background of the present disclosure, and therefore, may include information that does not constitute prior art that is known to those of ordinary skill in the art.

Disclosure of Invention

In view of this, the present disclosure provides a report generation method, a report generation system, a computer device, and a storage medium, which support flexible configuration of indexes/dimensions in a header, can automatically generate a composite header according to user requirements, meet data export requirements of a user on a multi-index/multi-dimension combination, and simultaneously can perform data validity check based on the indexes and the dimension combination, ensure generation of a report with valid data, and improve report generation efficiency.

One aspect of the present disclosure provides a report generation method, including: obtaining an initial header having an index region and a dimension region; in response to the configuration operation of the index area, combining the category cells of the target index according to the configured index classification structure to generate a composite index; performing overlapping check on the dimensionality associated with the target index to generate a dimensionality set commonly associated with the composite index; generating a target dimension in response to a configuration operation of the dimension region based on the set of dimensions; and generating an initial report with a composite header according to the composite index and the target dimension.

In some embodiments, after the generating the set of dimensions commonly associated with the composite metric, the method further includes: receiving a first filtering condition configured for a current dimension associated with a current target index; acquiring data content of the current target index based on the first filtering condition of the current dimension; and previewing the data content in real time in a visual chart mode.

In some embodiments, the merging category cells of the target metric according to the configured metric classification structure includes: obtaining an index set and a configured index classification structure, wherein the index classification structure indicates class labels of corresponding indexes in the index set, and the index classification structure is a tree-shaped cluster structure; obtaining target indexes determined from the index set according to index configuration operation, wherein each target index has a category cell corresponding to a category label of the target index; and combining the category cells of the target indexes with the same category label based on text matching according to the index classification structure.

In some embodiments, the metric configuration operation comprises: clicking an index cell in the index area through a clicking control, and selecting clicking operation of an index according to the index set displayed by the popup window; and/or selecting one index in the index set through a dragging control, and dragging to a dragging operation of one index cell in the index area.

In some embodiments, after merging category cells of the target metrics having the same category label based on the text matching, the method further includes: receiving a calculation condition configured for a plurality of target indexes with the same class label, and generating a calculation index, wherein the calculation index is any item of a summation index, a mean value index and a maximum value index.

In some embodiments, the generating the target dimension comprises: responding to click operation on dimension cells in the dimension area and/or drag operation on dimensions in the dimension set, and generating target dimensions corresponding to the dimension cells in the dimension area; and when the dimension set has a preset classification structure, merging the category cells of the target dimension according to the preset classification structure to generate a composite dimension.

In some embodiments, the generating the target dimension further comprises: receiving a second filtering condition configured for a current target dimension; and displaying the dimension value of the current target dimension based on the second filtering condition in the dimension cell corresponding to the current target dimension.

In some embodiments, after generating the target dimension corresponding to each dimension cell in the dimension area, the method further includes: verifying whether each target index has valid data based on each target dimension; if not, obtaining a target index and target dimension combination without effective data, and generating modification prompt information based on the target index and target dimension combination.

In some embodiments, after the generating the initial report with the composite header, the method further includes: and acquiring the data content of each data cell in the initial report according to the data time period range, and generating a target report.

In some embodiments, obtaining the data content of a current data cell according to the position relationship between the current data cell and the composite header includes: determining a current target index and a current target dimension corresponding to the current data cell along an orthogonal direction based on the current data cell; generating an index channel pointing to the current target index from the current data cell, and obtaining a category label of the top-level category unit corresponding to the current target index along the index channel index; and obtaining the data content of the current target index based on the current target dimension from the data pool of the category label based on the current target dimension obtained from the index.

Another aspect of the present disclosure provides a report generation system, including: an initial acquisition module configured to acquire an initial header having an index region and a dimension region; the index configuration module is configured to respond to configuration operation of the index area, merge the category cells of the target index according to the configured index classification structure and generate a composite index; the data checking module is configured to perform overlapping checking on the dimensionality associated with the target index to generate a dimensionality set commonly associated with the composite index; a dimension configuration module configured to generate a target dimension in response to a configuration operation of the dimension region based on the set of dimensions; and the report generation module is configured to generate an initial report with a composite header according to the composite index and the target dimension.

Yet another aspect of the present disclosure is a computer device, comprising: a memory storing executable instructions; and a processor configured to implement the report generation method according to any of the above embodiments by executing the executable instructions.

Yet another aspect of the present disclosure is a computer-readable storage medium storing a computer program, which when executed, implements the report generating method according to any of the above embodiments.

Compared with the prior art, the beneficial effects of this disclosure include at least:

the method supports flexible configuration of an index area and a dimension area in the header, automatically identifies and classifies target indexes according to an index classification structure configured by a user, generates a composite header with composite indexes and target dimensions, meets the data export requirement of the user on multi-index/multi-dimension combination, and can obtain a data report with the composite header only by simple configuration;

according to a target index configured by a user, through carrying out overlapping verification on the associated dimensionality, the dimensionality with valid data of a target index combination is reserved, the user is enabled to configure the dimensionality based on an automatically filtered dimensionality set, the situation that the index and the dimensionality combination in a generated report have valid data is ensured, repeated editing and generation of the report due to data errors/deletions are avoided, and therefore the report generation efficiency is improved;

furthermore, the method and the device can also support that the filtering condition is set for a specific dimensionality after the indexes are configured, data is previewed in real time in a visual chart mode, and a user is guided to adjust the indexes, the dimensionalities and the filtering conditions in time in a mode that the report previewing data is preposed and refined to be a single index, a single dimensionality and a single filtering condition, so that the report is prevented from being invalid or wrong due to the fact that the data cannot be previewed in the report configuring process, and finally generated reports are guaranteed to be valid and reliable.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is apparent that the drawings described below are only some embodiments of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without inventive effort.

FIG. 1 is a schematic diagram illustrating steps of a report generation method according to an embodiment of the present disclosure;

FIG. 2 illustrates a schematic structural diagram of a composite header in an embodiment of the present disclosure;

FIG. 3 is a diagram illustrating a merging process of category cells of a target index in an embodiment of the present disclosure;

FIG. 4 is a schematic diagram illustrating a configuration page of an index classification structure according to an embodiment of the disclosure;

FIG. 5 is a schematic diagram illustrating a configuration page of a target metric in an embodiment of the disclosure;

FIG. 6 is a schematic diagram illustrating a configuration process of a first filtering condition in an embodiment of the present disclosure;

FIG. 7 is a schematic diagram illustrating a configuration page of a first filter term in an embodiment of the disclosure;

FIG. 8 illustrates a configuration page diagram of a target dimension in an embodiment of the disclosure;

FIG. 9 is a schematic diagram illustrating a data content preview process for a data cell in an embodiment of the present disclosure;

FIG. 10 is a schematic diagram illustrating a data content preview page of a data cell in an embodiment of the present disclosure;

FIG. 11 is a block diagram illustrating a report generation system in accordance with an embodiment of the present disclosure;

FIG. 12 shows a schematic structural diagram of a computer device in an embodiment of the disclosure;

fig. 13 shows a schematic structural diagram of a computer-readable storage medium in an embodiment of the present disclosure.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art.

Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.

The step numbers in the following embodiments are merely used to indicate different execution contents, and the execution order between the steps is not strictly limited. The use of "first," "second," and similar terms in the detailed description is not intended to imply any order, quantity, or importance, but rather is used to distinguish one element from another. It should be noted that features of the embodiments of the disclosure and of the different embodiments may be combined with each other without conflict.

Fig. 1 shows main steps of a report generation method in the embodiment, and referring to fig. 1, the report generation method in the embodiment includes: in step S110, an initial header having an index area and a dimension area is obtained; in step S120, in response to the configuration operation of the index area, merging the category cells of the target index according to the configured index classification structure to generate a composite index; in step S130, performing overlap check on the dimensions associated with the target index to generate a dimension set commonly associated with the composite index; in step S140, generating a target dimension in response to a dimension set-based configuration operation of the dimension area; and in step S150, generating an initial report with a composite header according to the composite index and the target dimension.

The report generation method of the embodiment supports flexible configuration of the index area and the dimension area in the header, can automatically identify and classify the target index according to the index classification structure configured by the user, generates the composite header with the composite index and the target dimension, meets the data export requirement of the user on multi-index/multi-dimension combination, and enables the user to obtain the data report with the composite header only through simple configuration; moreover, the related dimensionality can be subjected to overlapping verification according to the target index configured by the user, a dimensionality set with valid data combined with the target index is reserved, the user can configure the dimensionality based on the automatically filtered dimensionality set, the index and the dimensionality combination in the generated report have the valid data, repeated editing and report generation caused by data errors/deletions are avoided, and therefore report generation efficiency is improved.

Fig. 2 shows a main structure of a composite header in the embodiment, and referring to fig. 2, by using the report generating method of the above embodiment, a composite index is configured and generated in an index area 300, where the composite index includes a plurality of target indexes arranged hierarchically according to a configured index classification structure, for example, fig. 2 shows that the index classification structure includes three levels of classifications; the dimension area 400 is configured to generate target dimensions, which may be hierarchically arranged according to a dimension tree structure built into the system, for example, fig. 2 shows that the dimension tree structure includes two levels of classification. The composite index and target dimensions are combined to generate a composite header 200.

The indicator area 300 and the dimension area 400 shown in fig. 2 correspond to a column area and a row area of the report, respectively, and in other embodiments, the positions of the indicator area and the dimension area may be interchanged.

Each step of the report generation method is described in detail below with reference to specific examples.

In step S110, the initial header is a simple preset header structure, and the index area and the dimension area of the initial header support configuration, so that a user can generate a composite header having a composite index and a target dimension based on a data export requirement of a multi-index/multi-dimension combination.

In step S120, a composite index is generated according to the user' S arrangement of the index area. Referring to fig. 3, a process of merging category cells of a target indicator according to a configured indicator classification structure specifically includes: step S120-2, acquiring an index set and a configured index classification structure, wherein the index classification structure indicates class labels of corresponding indexes in the index set, and the index classification structure is a tree cluster structure; step S120-4, obtaining target indexes determined from the index set according to index configuration operation, wherein each target index is provided with a category cell corresponding to a category label of the target index; and step S120-6, merging the category cells of the target indexes with the same category labels based on text matching according to the index classification structure.

Before configuring the target index, the index classification structure is configured first. Fig. 4 shows a configuration page of the index classification structure in the embodiment, and referring to fig. 4, in the configuration page 310 of the index classification structure, a classification level of the index classification structure may be set, for example, fig. 4 shows that the index classification structure includes three levels of classifications, each level of classification is classified into three levels of classifications, and a tree-shaped cluster structure is formed by a plurality of sets of classifications (fig. 4 shows four sets of classifications 320 a-320 d). In other embodiments, the user may set other classification levels according to actual needs, for example, the index classification structure is set to two-level classification, five-level classification, and the like. In some embodiments, if the user does not configure the index classification structure, the target indexes may be merged according to the index classification structure built in the system when the composite index is subsequently generated.

When each group of classes is set, filling specific class classification names from the first class classification to the third class classification step by step, namely indicating class labels to which the indexes belong, and if the first class classification is empty, simultaneously filling the second class classification and the third class classification which belong to the first class classification into empty. In the index classification structure shown in fig. 4, the first group of classifications 320a is configured with the names of the primary classification, the secondary classification, and the tertiary classification; the second group 320b of classifications is configured with the names of the first class classification and the second class classification, and the third class classification is empty; the third group 320c is configured with the name of the first class, and the second class and the third class are null; the first through third classes of the fourth class 320d are all empty.

Further, when the index classification structure is configured, indexes are selected from an index pool produced by the system under each group of classifications, and single selection and multiple selection are supported when the indexes are selected, so that an index set corresponding to each group of classifications is formed. And each index can also be configured with an index display name finally displayed in the composite header, each index in an index pool produced by the system has a preset index name, and if a certain index is configured with the index display name, the index in the generated composite header is displayed by the configured index display name. And if the index display name can be null, displaying the finally generated composite header by taking the preset index name.

And after the index classification structure is configured, configuring the target index. The user may select an index from a set of indices, i.e., a pool of indices produced by the system. According to a target index selected by a user, if the target index is configured with a category label, the category cell corresponding to the specific category label is carried, and when the category label of the target index comprises multi-level categories, the category cell of the target index is displayed according to a tree structure; if the target index is not configured with the category label, the category cell is empty. According to the category cells of the target indexes, the category cells with the same category labels, namely the category cells of the target indexes with the same category classification of the belonging levels, can be merged from bottom to top according to text matching, and the composite indexes are automatically generated.

Specifically, when each target index is configured, the target index can be selected in the popup window by clicking the control, and the target index can be directly dragged to the corresponding position in a dragging mode. Fig. 5 illustrates a configuration page of a target index in an embodiment, referring to fig. 5, in a configuration page 330 of the target index, a click control is arranged in an index area 300 ', any index cell in the index area 300' is clicked, for example, the index cell 340 indicated in fig. 5 is clicked, and the index cell 340 displays an index set in a pop-up window manner; clicking any index in the index set displayed in the popup completes the configuration of the target index corresponding to the index cell 340. In addition, in the configuration page 330 of the target indicator, the indicator set area 350 is configured with a drag control, and any indicator in the indicator set is selected, for example, the indicator 350 'indicated in fig. 5 is selected and dragged to one indicator cell in the indicator area 300', for example, to the indicator cell 340, that is, the target indicator corresponding to the indicator cell 340 is configured. The target index supports addition, modification, deletion and reselection, so that the user can flexibly configure according to the requirement.

After the target indexes are configured and the system automatically combines the category cells of the target indexes based on text matching, the method further comprises the following steps: and receiving a calculation condition configured for a plurality of target indexes with the same class label, and generating a calculation index, wherein the calculation index is any item of a summation index, a mean value index and a maximum value index. For example, the calculation index configuration area 360 shown in fig. 5 may be used to configure the calculation index for the configured target index, and the calculation index supports adding calculation formulas such as summation, mean, maximum, minimum, and the like, so as to facilitate the user to count data from multiple aspects.

Through the configuration operation of the index areas in the embodiments, the composite index meeting the user requirement is generated. In the real-time configuration process, the configuration result is previewed in real time through a what-you-see-is-what-you-get report generation mode based on a big data visualization technology, and is provided for a user to observe.

In step S130, after the selection of the index/index group is completed, dimension verification that the support of the expansion between the indexes is performed in the system, the dimension that the composite index supports the expansion is filtered and displayed through the verification of the selected index overlapping dimension, so that when a user subsequently configures the dimension, the dimension is selected from the dimension set filtered by the system, it is ensured that the index dimension combination of the report to be generated can generate valid data, and it is avoided that valid report data cannot be generated due to the selection of invalid index and dimension combination in the report generation process. In step S130, the dimensions associated with the target index are subjected to overlap check, and a dimension set associated with the composite index is filtered out, so that validity check of the pre-data is realized, effective data can be generated by combining the index and the dimensions, repeated editing of a report is avoided, and report generation efficiency is improved.

Furthermore, after configuring the target index and automatically filtering out the dimension set, the user can set a filtering condition for the target index according to the actual data statistics requirement and preview data in real time.

Fig. 6 illustrates a configuration process of a first filter condition in the embodiment, and referring to fig. 6, after generating a dimension set commonly associated with a composite index in the embodiment, the method further includes: step S130-4, receiving a first filtering condition configured for a current dimension associated with a current target index; step S130-6, acquiring data content of a first filtering condition of a current target index based on a current dimension; and step S130-8, previewing the data content in a visual chart mode in real time.

Specifically, in conjunction with the configuration page 370 of the first filtering condition shown in fig. 7, for each configured target indicator, independent addition of the first filtering condition is supported. For example, if the user selects the current target indicator 350 'that requires the addition of a filter term, the left area 380 of the configuration page 370 for the first filter term displays the dimension that the current target indicator 350' supports unrolling. The user may select a dimension from the left area 380, for example, select the current dimension 380 ', and configure the first filter criteria for the selected current dimension 380' in a particular configuration area 390. After the user configures the first filtering condition for the current dimension 380 'of the current target indicator 350', the system automatically obtains the data content of the current target indicator 350 'based on the first filtering condition of the current dimension 380, and previews the data content in the preview area 390' in real time through the visual chart.

The addition of the first filtering condition responds to the configuration operation of the user in a WYSIWYG mode by adopting a Kylin-based ad hoc query technology. And displaying the data content of the current target index under the first filtering condition of the current dimension in real time after the user adds one first filtering condition. The mode of preposing the report preview data and thinning the granularity to a single index, a single dimension and a single filtering condition effectively ensures the effectiveness and reliability of the generation of the composite header.

Specifically, in the process of configuring a report, the existing report generation system cannot preview the data influence generated by modifying the header configuration item, which finally results in invalid or wrong report data generation. The mode that the report form preview data is preposed and the granularity is detailed to a single index, a single dimension and a single filtering condition belongs to the preview in the configuration process (namely in fact), and is different from the preview after the report form configuration is finished (namely in fact). The method has the advantages that a single index is obtained based on a small amount of data under given dimensionality and filtering conditions, the previewing data obtaining speed is higher than that of the overall report previewing speed and can reach second-level previewing, the difference between actual previewing data and expected report data can be found in time, a user is guided to adjust the index, the dimensionality and the filtering conditions in time, early finding and early adjustment are conducted, and finally effective and reliable report data generation is guaranteed.

Further, the preview data supports multiple large data visualization chart modes, including but not limited to indicator cards, bar charts, ring charts, rose charts, line charts, bubble chart radar charts, area charts, thermodynamic diagrams and the like, and can be subjected to preliminary data preview and analysis before data is exported.

In step 140, generating a target dimension in response to a configuration operation of a user on the dimension area, specifically including: responding to click operation on the dimension cells in the dimension area and/or drag operation on the dimensions in the dimension set, and generating target dimensions of the dimension cells in the corresponding dimension area; and when the dimension set has a preset classification structure, combining the category cells of the target dimension according to the preset classification structure to generate a composite dimension.

Fig. 8 shows a configuration page 410 of a target dimension in the embodiment, and referring to fig. 8, similar to the configuration operation of a target index, in the process of configuring the target dimension, a specific target dimension may be selected in a pop-up window through a click control set in a dimension area 420, or the specific target dimension may be dragged to a corresponding dimension cell through a drag control in a dimension set area 430. The control tool which can be flexibly dragged through modularization increases configuration flexibility and convenience. In the configuration process of the target dimension, if a dimension tree structure is built in the system, namely a preset classification structure about the dimension, for example, one dimension data supports the expansion according to provinces, and the dimension data of each province can be expanded according to county and city regions in the jurisdiction of the province; and combining the category cells of the target dimension according to a preset classification structure, so that the target dimension is automatically aggregated according to the attribute structure of the target dimension, and generating a composite dimension similar to the composite index. And in the configuration process of the target dimension, the dimension configuration result is previewed in real time in a WYSIWYG (what you see is what you get) mode.

Further, the target dimension also supports adding filter terms. The user can configure a second filtering condition for a current target dimension in the process of configuring the target dimension, the system removes the dimension value which is not concerned after receiving the second filtering condition configured for the current target dimension, and the filtered dimension value is displayed in the dimension cell corresponding to the current target dimension, namely the dimension value of the current target dimension based on the second filtering condition is displayed. The adding of the second filtering condition is to set secondary filtering of effective unfolding dimensionality after automatic filtering based on correlation dimensionality overlapping check, select an enumeration value in a dimensionality item by selecting the dimensionality item, and finally determine the unfolding range of the target dimensionality.

After generating the target dimension of each dimension cell in the corresponding dimension area, the method further includes: verifying whether each target index has valid data based on each target dimension; if not, the target index and target dimension combination without effective data is obtained, and modification prompt information based on the target index and target dimension combination is generated.

After the composite index is generated, the data validity is pre-checked through the related dimension overlapping check; and after the filtering condition is configured and the target dimension is generated, further combining the target index and the target dimension, and verifying the data validity again to ensure that the combination of each target index and each target dimension can generate valid data in the finally generated report.

Further, the attribute fields of the configuration report can be customized, for example, in the configuration pages shown in fig. 5 and 8, the fields of the configuration time range, the tab person, the tab time and the like can be defined. The time range is used as an optional field of the report, is displayed at the upper left of the report after being selected, and limits the time range of report data when the report is specifically generated. The tab is selected and then displayed at the bottom of the report, for example, as the name of the user configuring the report. And displaying the selected report at the bottom of the report, and specifically taking the system timestamp to be accurate to the second when the report is generated.

After configuring the header and the attribute field of the report in the above embodiment, step S150 generates an initial report with a composite header. And subsequently, according to the data time period range, the data content of each data cell in the initial report is obtained, and a final target report is generated.

In one embodiment, after the initial report with the composite header is generated, the initial report may be stored in the system database as a template. The template supports configuration and modification of the template name. The template can also be provided with a title for the template header display. When a specific target report needs to be generated, the target report can be generated only by selecting a template on a template list page displayed by the system and importing data. And displaying all template lists on a template list page, wherein the display fields comprise: the method comprises the steps of template name, template title, template configuration index, template configuration dimension and template updating time, wherein each report template supports preview, editing and deleting operations.

Therefore, in the actual report editing process, the report generation is mainly divided into four steps: selecting/configuring a template, selecting a report data time range, previewing a report and exporting the report. The template selection refers to selecting a template needing to generate a report form from a template list, and the template list supports template name searching. The selected report data time range includes a selection of a start time and an end time of the data. The report previewing is to acquire report data for previewing and can be triggered by report previewing operation; for example, a preview button can be set on a report page, and when a user clicks the preview button, the report data preview can be triggered. When the report data volume is small, all report data can be acquired at one time for previewing, and when the report data volume is large, the data acquisition and previewing are performed in a batch loading mode for improving user experience. And after the report data is previewed and confirmed to be correct, saving and downloading operations can be carried out, the report data is exported in an excel form, an export progress prompt and an expected export completion time prompt can be given in the export process, the export excel header is named as a template name, a time range, a charter and a charter time, and finally a target report required by a user is generated.

In one embodiment, before generating the target report, if the user only needs to view the data content of some data cells, for example, the user double-clicks a certain data cell, the data content corresponding to the data cell is directly obtained for the user to preview.

Fig. 9 illustrates a data content preview process of a data cell in an embodiment, and referring to fig. 9, the data content of a current data cell is obtained according to a position relationship between the current data cell and a composite header, including: step S160-2, based on the current data cell, determining a current target index and a current target dimension corresponding to the current data cell along an orthogonal direction; step S160-4, generating an index channel pointing to the current target index from the current data cell, and obtaining a category label of the top-level category unit corresponding to the current target index along the index channel index; and step S160-6, obtaining the data content of the current target index based on the current target dimension from the data pool of the category label based on the current target dimension obtained from the index.

Specifically, with reference to the data content preview page 500 of the data cell shown in fig. 10, after the user selects a current data cell 510 to be previewed for the data content, the current target index 520 and the current target dimension 530 are determined in the orthogonal direction, that is, the row-column direction of the report; then, along the index path P where the current data cell 510 points to the current target indicator 520, the index gets the category label of the top-level category cell 540. In this embodiment, after generating the composite header and determining the time range of the report data, the data contents corresponding to the index dimension combinations in the composite header are aggregated into a total data pool, where the data contents corresponding to each target index and each target dimension combination, that is, the data contents corresponding to each data cell, are aggregated according to the index classification structure and the dimension tree structure (if any). Therefore, the category label of the top-level category cell 540 is obtained through the index of the index channel P, and the search range of the data content corresponding to the current data cell 510 can be preliminarily reduced from the total data pool to a group of sub-data pools corresponding to the categories in the index classification structure, so as to improve the speed of obtaining the data content corresponding to the current data cell 510 and ensure the accuracy of the obtained data content. Next, in the sub-data pool whose category label of the top category cell 540 is based on the current target dimension 530, the data content of the current target index 520 based on the current target dimension 530 is obtained, that is, the data content corresponding to the current data cell 510 is obtained.

In summary, the what-you-get report generation method described in the above embodiments employs a big data visualization technology to preview a report template, i.e., a header configuration result, in real time, and previews report data in real time during the configuration process through an ad hoc query module based on a Kylin technology. By providing a flexible template configuration tool, flexible configuration of indexes and flexible configuration of dimensionality are realized simultaneously, classification and attribution of the indexes and the dimensionality are intelligently identified according to the indexes and the dimensionality configured by a user, a composite header is automatically generated, a preview effect is generated in real time through a visualization technology in the configuration process, and the requirement that the user can generate a required complex report form only through simple configuration is met. In the dimension configuration process, dimension sets which can be expanded are automatically filtered according to the relevant dimension superposition of the indexes/index groups selected by the user, and effective data are ensured when reports are generated. And filtering conditions can be added to the indexes and the dimensions respectively, report data of each index and dimension combination node based on the filtering conditions can be quickly previewed in an ad hoc query visualization mode, and after the filtering conditions of all the nodes are set, the system automatically aggregates the index classification structure and the dimension tree structure to generate composite header report data.

Therefore, the report generation method can effectively improve the flexibility and the interaction friendliness of report generation, the usability of a report tool and the effectiveness of report data, reduce the configuration difficulty of the report template and improve the generation efficiency of the report.

The embodiment of the present disclosure further provides a report generation system, which is used to implement the report generation method described in any of the above embodiments. Fig. 11 shows main modules of the report generation system in the embodiment, and referring to fig. 11, the report generation system 600 in the embodiment includes: an initial acquisition module 610 configured to obtain an initial header having an index region and a dimension region; an index configuration module 620 configured to, in response to a configuration operation of an index area, merge category cells of a target index according to a configured index classification structure to generate a composite index; the data checking module 630 is configured to perform overlapping checking on the dimensionality associated with the target index, and generate a dimensionality set jointly associated with the composite index; a dimension configuration module 640 configured to generate a target dimension in response to a dimension set-based configuration operation of a dimension region; and a report generation module 650 configured to generate an initial report with a composite header according to the composite index and the target dimension.

Further, the report generation system 600 may further include modules for implementing other process steps of the above report generation method embodiments, and specific principles of each module may refer to the description of each report generation method embodiment, and are not repeated here.

As described above, the report generation system of the present disclosure provides a flexible template configuration tool, and simultaneously implements flexible configuration of indexes and flexible configuration of dimensions, and intelligently identifies the classification and attribution according to the indexes and dimensions configured by the user, and automatically generates a composite header, and the configuration process generates a preview effect in real time through a visualization technology, thereby satisfying the requirement that the user can generate a desired complex report by only simply configuring the report. In the dimension configuration process, dimension sets which can be expanded are automatically filtered according to the relevant dimension superposition of the indexes/index groups selected by the user, and effective data are ensured when reports are generated. And moreover, index and dimension addition filtering conditions are supported, report data of each index and dimension combination node based on the filtering conditions are quickly previewed through the ad hoc query visualization module, and after the filtering conditions of all nodes are set, the system automatically aggregates the index classification structure and the dimension tree structure to generate composite header report data. Therefore, the report generation system can effectively improve the flexibility and the interaction friendliness of report generation, the usability of a report tool and the effectiveness of report data, reduce the configuration difficulty of the report template and improve the generation efficiency of the report.

The embodiment of the present disclosure further provides a computer device, which includes a processor and a memory, where the memory stores executable instructions, and when the executable instructions are executed by the processor, the report generating method described in any of the above embodiments is implemented.

As described above, the computer device of the present disclosure can effectively improve the flexibility of report generation, the interaction friendliness, the ease of use of a report tool, and the effectiveness of report data, reduce the difficulty of report template configuration, and improve the generation efficiency of reports.

Fig. 12 is a schematic structural diagram of a computer device in the embodiment of the present disclosure, and it should be understood that fig. 12 only schematically illustrates various modules, which may be virtual software modules or actual hardware modules, and the combination, the splitting and the addition of the rest of the modules are within the scope of the present disclosure.

As shown in fig. 12, the computer device 700 is in the form of a general purpose computing device. Components of the computer device 700 include, but are not limited to: at least one processing unit 710, at least one memory unit 720, a bus 730 connecting the different platform components (including memory unit 720 and processing unit 710), a display unit 740, etc.

Wherein the storage unit stores program codes, which can be executed by the processing unit 710, so that the processing unit 710 executes the steps of the report generating method described in any of the above embodiments. For example, the processing unit 710 may perform the steps as shown in fig. 1, 3, 6 and 9.

The storage unit 720 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)7201 and/or a cache memory unit 7202, and may further include a read only memory unit (ROM) 7203.

The memory unit 720 may also include programs/utilities 7204 having one or more program modules 7205, such program modules 7205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.

Bus 730 may be any representation of one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

The computer device 700 may also communicate with one or more external devices 800, and the external devices 800 may be one or more of a keyboard, a pointing device, a bluetooth device, etc. These external devices 800 enable a user to interactively communicate with the computer device 700. The computer device 700 can also communicate with one or more other computing devices, including routers, modems. Such communication may occur via an input/output (I/O) interface 750. Moreover, computer device 700 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network such as the Internet) via network adapter 760. Network adapter 760 may communicate with the other modules of computer device 700 via bus 730. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the computer device 700, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage platforms, to name a few.

The embodiment of the present disclosure further provides a computer-readable storage medium for storing a program, and when the program is executed, the report generating method described in any of the above embodiments is implemented. In some possible embodiments, various aspects of the disclosure may also be implemented in the form of a program product including program code for causing a terminal device to perform the report generation method described in any of the above embodiments when the program product is run on the terminal device.

As described above, the computer-readable storage medium of the present disclosure can effectively improve the flexibility of report generation, the interactive friendliness, the ease of use of report tools, and the effectiveness of report data, reduce the difficulty of report template configuration, and improve the report generation efficiency.

Fig. 13 is a schematic structural diagram of a computer-readable storage medium of the present disclosure. Referring to fig. 13, a program product 900 for implementing the above method according to an embodiment of the present disclosure is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present disclosure is not limited thereto, and in this document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of readable storage media include, but are not limited to: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

A computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Program code for carrying out operations for the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device, such as through the internet using an internet service provider.

The foregoing is a more detailed description of the present disclosure in connection with specific preferred embodiments, and it is not intended that the specific embodiments of the present disclosure be limited to these descriptions. For those skilled in the art to which the disclosure pertains, several simple deductions or substitutions may be made without departing from the concept of the disclosure, which should be considered as falling within the protection scope of the disclosure.

Claims

1. A report generation method is characterized by comprising the following steps:

obtaining an initial header having an index region and a dimension region;

in response to the configuration operation of the index area, combining the category cells of the target index according to the configured index classification structure to generate a composite index;

performing overlapping check on the dimensionality associated with the target index to generate a dimensionality set commonly associated with the composite index;

generating a target dimension in response to a configuration operation of the dimension region based on the set of dimensions; and

and generating an initial report with a composite header according to the composite index and the target dimension.

2. The report generation method according to claim 1, further comprising, after generating the set of dimensions commonly associated with the composite index:

receiving a first filtering condition configured for a current dimension associated with a current target index;

acquiring data content of the current target index based on the first filtering condition of the current dimension; and

and previewing the data content in real time in a visual chart mode.

3. A report generation method according to claim 1, wherein said merging category cells of target indicators according to the configured indicator classification structure comprises:

obtaining an index set and a configured index classification structure, wherein the index classification structure indicates class labels of corresponding indexes in the index set, and the index classification structure is a tree-shaped cluster structure;

obtaining target indexes determined from the index set according to index configuration operation, wherein each target index has a category cell corresponding to a category label of the target index; and

and combining the category cells of the target indexes with the same category label based on text matching according to the index classification structure.

4. A report generation method according to claim 3, characterized in that said indicator configuration operation comprises:

clicking an index cell in the index area through a clicking control, and selecting clicking operation of an index according to the index set displayed by the popup window; and/or

And selecting an index in the index set through a dragging control, and dragging to the dragging operation of an index cell in the index area.

5. A report generation method according to claim 3, characterized in that after merging category cells of target indexes having the same category label based on text matching, further comprising:

receiving a calculation condition configured for a plurality of target indexes with the same class label, and generating a calculation index, wherein the calculation index is any item of a summation index, a mean value index and a maximum value index.

6. The report generation method of claim 1, wherein the generating a target dimension comprises:

responding to click operation on dimension cells in the dimension area and/or drag operation on dimensions in the dimension set, and generating target dimensions corresponding to the dimension cells in the dimension area;

and when the dimension set has a preset classification structure, merging the category cells of the target dimension according to the preset classification structure to generate a composite dimension.

7. The report generation method of claim 6, wherein the generating a target dimension further comprises:

receiving a second filtering condition configured for a current target dimension;

and displaying the dimension value of the current target dimension based on the second filtering condition in the dimension cell corresponding to the current target dimension.

8. The report generation method according to claim 6, further comprising, after generating the target dimension corresponding to each dimension cell in the dimension area:

verifying whether each target index has valid data based on each target dimension;

if not, obtaining a target index and target dimension combination without effective data, and generating modification prompt information based on the target index and target dimension combination.

9. The report generation method of claim 1, after generating the initial report having the composite header, further comprising:

and acquiring the data content of each data cell in the initial report according to the data time period range, and generating a target report.

10. The report generation method according to claim 9, wherein the obtaining of the data content of a current data cell according to the positional relationship between the current data cell and the composite header comprises:

determining a current target index and a current target dimension corresponding to the current data cell along an orthogonal direction based on the current data cell;

generating an index channel pointing to the current target index from the current data cell, and obtaining a category label of the top-level category unit corresponding to the current target index along the index channel index; and

and obtaining the data content of the current target index based on the current target dimension from the data pool of the category label based on the current target dimension obtained from the index.

11. A report generation system, comprising:

an initial acquisition module configured to acquire an initial header having an index region and a dimension region;

the index configuration module is configured to respond to configuration operation of the index area, merge the category cells of the target index according to the configured index classification structure and generate a composite index;

the data checking module is configured to perform overlapping checking on the dimensionality associated with the target index to generate a dimensionality set commonly associated with the composite index;

a dimension configuration module configured to generate a target dimension in response to a configuration operation of the dimension region based on the set of dimensions; and

and the report generation module is configured to generate an initial report with a composite header according to the composite index and the target dimension.

12. A computer device, comprising:

a memory storing executable instructions; and

a processor configured to implement the report generation method according to any of claims 1 to 10 via execution of the executable instructions.

13. A computer-readable storage medium storing a computer program, wherein the computer program, when executed, implements the report generating method according to any one of claims 1 to 10.