Multi-dimensional form generation method, device, system, equipment and medium

Abstract

The present invention discloses a multi-dimensional form generation method, system, device and storage medium. In response to a form generation operation, a dimension setting interface is displayed, and the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; in response to a dimension adding operation in any dimension adding area, a dimension adding interface is displayed, and based on the detected dimension selection operation, at least one dimension corresponding to the current area is determined; in response to a dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value entered on each dimension is determined; based on the dimensions on each area and the dimension values ​​on each dimension, a multi-dimensional report is generated, and the multi-dimensional report is visualized. This solves the problem that existing report design tools only support two-dimensional report design, and the flexibility and visualization of the table structure are poor. This realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

Description

Technical Field

[0001] The present invention relates to the field of form generation technology, and in particular to a multi-dimensional form generation method, system, device and storage medium. Background Art

[0002] With the current refinement of financial management and the need for further integration of business and finance, report design based on report design tools is usually required.

[0003] Existing report design tools only support the display of two-dimensional data structures and cannot flexibly hide or display report data. Therefore, it is necessary to improve existing report design tools. Summary of the Invention

[0004] The present invention provides a multi-dimensional form generation method, system, device and storage medium to achieve the generation and visual display of multi-dimensional forms, improve the flexibility of forms, and meet the personalized needs of users.

[0005] According to one aspect of the present invention, a method for generating a multidimensional form is provided, the method comprising:

[0006] In response to the form generation operation, a dimension setting interface is displayed, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form;

[0007] In response to a dimension adding operation in any dimension adding area, displaying a dimension adding interface, and determining at least one dimension corresponding to the current area based on the detected dimension selection operation;

[0008] In response to a dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value entered for each dimension is determined;

[0009] Based on the dimensions of each region and the dimension values ​​of each dimension, a multi-dimensional report is generated, and the multi-dimensional report is visualized.

[0010] According to another aspect of the present invention, a multi-dimensional form generating device is provided, the device comprising:

[0011] A dimension display module, configured to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to various areas of the form;

[0012] A dimension adding module is configured to respond to a dimension adding operation in any dimension adding area, display a dimension adding interface, and determine at least one corresponding dimension in the current area based on the detected dimension selection operation;

[0013] A dimension value setting module, configured to display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered for each dimension;

[0014] The report generation module is used to generate a multi-dimensional report based on the dimensions of each area and the dimension values ​​of each dimension, and to visualize the multi-dimensional report.

[0015] According to another aspect of the present invention, a multi-dimensional form generation system is provided, the system comprising:

[0016] A dimension management component, configured to display a corresponding dimension management interface in response to a trigger operation, and to determine at least one dimension corresponding to each region in response to an edit operation on any dimension management interface;

[0017] A dimension value management component is used to display the dimension value management interface and, in response to dimension value editing operations, determine the dimension value corresponding to each dimension; and, in response to dimension value editing operations, edit the input dimension value;

[0018] The report generation component is used to generate multi-dimensional reports based on the dimensions of each region and the dimension values ​​of each dimension.

[0019] According to another aspect of the present invention, an electronic device is provided, comprising:

[0020] at least one processor; and

[0021] a memory communicatively connected to the at least one processor; wherein,

[0022] The memory stores a computer program that can be executed by the at least one processor. The computer program is executed by the at least one processor so that the at least one processor can execute the multi-dimensional form generating method described in any embodiment of the present invention.

[0023] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the multi-dimensional form generation method described in any embodiment of the present invention when executed.

[0024] The technical solution of the embodiment of the present invention is to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; display a dimension adding interface in response to a dimension adding operation in any dimension adding area, and determine at least one dimension corresponding to the current area based on the detected dimension selection operation; display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered on each dimension; generate a multi-dimensional report based on the dimensions on each area and the dimension values ​​on each dimension, and visualize the multi-dimensional report. This solves the problem that existing report design tools only support two-dimensional report design and have poor flexibility and visualization of the table structure. It realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

[0025] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present invention, nor is it intended to limit the scope of the present invention. Other features of the present invention will become readily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0027] Figure 1 This is a flowchart of a multi-dimensional form generation method provided by the first embodiment of the present invention;

[0028] Figure 2 This is a flowchart of a multi-dimensional form generation method provided by the second embodiment of the present invention;

[0029] Figure 3 This is a schematic diagram of the structure of a multi-dimensional form generation device provided by the third embodiment of the present invention;

[0030] Figure 4 This is a structural diagram of a multi-dimensional report generation system provided by an embodiment of the present invention;

[0031] Figure 5 This is a flowchart of a multi-dimensional report generation method implemented by a multi-dimensional report generation system provided by the fourth embodiment of the present invention;

[0032] Figure 6 It is a structural diagram of an electronic device for implementing the multi-dimensional report generation method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0033] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts should fall within the scope of protection of the present invention.

[0034] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that the numbers used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0035] Example 1

[0036] Figure 1 This is a flowchart of a multi-dimensional form generation method provided by the first embodiment of the present invention. This embodiment is applicable to situations where multi-dimensional forms need to be generated. The method can be executed by a multi-dimensional form generation device. The multi-dimensional form generation device can be implemented in the form of hardware and / or software. The multi-dimensional form generation device can be configured in a multi-dimensional report designer. The multi-dimensional report designer can be integrated into electronic devices such as computers and mobile phones. Figure 1 As shown, the method includes:

[0037] S110 . In response to the form generation operation, a dimension setting interface is displayed, where the dimension setting interface includes dimension adding areas corresponding to various areas of the form.

[0038] The form generation operation can be understood as a click operation on the form management page of the multi-dimensional report designer. For example, it can be clicking the Create Form control on the form management page. The dimension display interface can be a display interface of the multi-dimensional report generation system. The various areas of the form can be understood as the row area, column area, filter area, view area, etc. The dimension addition area can be understood as a display area on the dimension settings page, where the dimension addition control can be displayed.

[0039] Specifically, to generate a multidimensional form, the user can click a control in the Multidimensional Report Designer interface that triggers form generation. This click triggers the form generation operation. Upon detecting this click on the form generation control, the Dimension Settings interface is displayed. Upon detecting the form generation operation, the Multidimensional Report Designer controls the displayed page to jump to the Dimension Settings interface, which displays the various areas within the form where dimensions can be added. Since the form architecture is divided into four areas: rows, columns, filters, and perspectives, the rows, columns, filters, and perspectives areas are all areas where dimensions can be added. Therefore, the names of these areas are displayed on the Dimension Settings page, and the area following the area names, known as the Dimension Addition area, contains an "Add Dimension" control for adding dimensions to a particular area. It should be understood that each area name has a corresponding Dimension Addition area: the row area name has a row dimension addition area, and the column area name has a column dimension addition area. Using these different addition areas, dimensions can be added to the rows, columns, filters, and perspectives areas of a form.

[0040] S120 . In response to a dimension adding operation in any dimension adding area, display a dimension adding interface, and determine at least one corresponding dimension in the current area based on the detected dimension selection operation.

[0041] The dimension addition operation can be understood as clicking the "Add Dimension Control" in the Add Dimension area of ​​the Dimension Settings page. The Add Dimension page is another display page in the report designer where you can add dimensions to various areas. For example, you can add dimensions to the row area on this page. Specifically, for any area in a form where you need to add a dimension, you can click the Add Dimension control next to the area name to jump to the Add Dimension page for that area to add the dimension. For example, to add a dimension to a column area in a form, you can click the Add Dimension control in the Add Dimension area corresponding to that column area. When the form designer detects that the Add Dimension control has been triggered, it indicates that a dimension needs to be added to the current area. At this point, the display page jumps from the Dimension Settings page to a specific Add Dimension page. The Add Dimension page displays different selectable dimensions, and you can select one or more dimensions corresponding to the current area by selecting them. In some embodiments, a select control may be provided before or after each selectable dimension on the Add Dimension page. Clicking a select control indicates that the corresponding selectable dimension has been selected. For example, when a select control is clicked, a mark such as a "√" or a dot may be displayed to distinguish it from unselected dimensions.

[0042] In some embodiments, the dimension adding interface includes an information shuttle box, and the information shuttle box includes a first information box and a second information box; the determining of at least one dimension corresponding to the current area based on the detected dimension selection operation includes: when it is detected that one or more dimension information in the first information box is selected, the selected dimension is displayed in the second information box, and the dimension in the second information box is determined as the at least one dimension corresponding to the current area.

[0043] The first information box displays the selectable dimensions, while the second information box displays the selected dimension. For example, dimensions can be organization, project, version, year, scenario, etc. The specific content of the dimension can be set according to the application scenario of the report and is not limited to this.

[0044] It can be understood that in the dimension adding page, an information shuttle box is displayed. The first information box of the information shuttle box displays the selectable dimensions, that is, the selectable dimensions in the current area. If you enter the dimension adding page of the row area, the dimensions that can be added to the row area are displayed. If you enter the dimension adding page of the column area, the dimensions that can be added to the column area are displayed.

[0045] Specifically, if one or more dimensions are selected in the first information box, the selected dimensions will appear in the second information box. In this case, the dimensions in the second information box are the dimensions corresponding to a region in the current form. Optionally, an information shuttle control is provided between the first information box and the second information box for adding the dimensions selected in the first information box to the second information box.

[0046] S130 . In response to a dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value inputted for each dimension is determined.

[0047] Among them, the dimension value can be understood as the numerical value corresponding to a certain dimension. The dimension value setting page is a page used to set the values ​​corresponding to each dimension. The content form of the dimension value is not limited here, for example, it can be a number, text or string, etc.

[0048] Specifically, you can click the Add Dimension Value control under any dimension on the display page to jump to the Add Dimension Value page, where you can add a value for that dimension. Furthermore, you can add values ​​for each dimension by importing the corresponding data file on this page or using other methods.

[0049] On the basis of the above technical solution, the determination of at least one dimension value input on each dimension includes: for the current dimension, calling the dimension value information tree based on the dimension code, the dimension value information tree includes multi-level dimension value information, displaying the upper dimension value in the dimension value information tree in the dimension selection box, and based on the selection operation of any dimension value in the upper dimension value, displaying the next dimension value of the selected dimension value, until the last dimension value.

[0050] Dimension codes can be understood as codes representing different dimensions. For example, dimension codes can be numbers, letters, or symbols. For example, the dimension code corresponding to the scene dimension is 1, and the dimension code corresponding to the year dimension is 2. The dimension value information tree can be understood as a structure tree representing the dimension value structure and data. The dimension value information tree corresponds one-to-one with the dimension codes.

[0051] Specifically, for the current dimension, you can search the corresponding dimension value information tree in the report designer based on the dimension code of the current dimension and display the upper-level dimension values ​​in the dimension value information tree. Clicking any upper-level dimension value will display the corresponding lower-level dimension values. This continues until the last dimension value is selected, at which point the dimension value is successfully added.

[0052] For example, the current dimension is version, and the corresponding dimension code is 3. Based on this dimension code, the upper-level dimension values ​​in the dimension value information tree are A, B, and C. The C dimension value corresponds to the lower-level dimension values ​​c1, c2, and c3. Based on this, when the upper-level dimension value is selected as C, the lower-level dimension values ​​c1 and c2 are selected as the dimension values ​​of the version dimension. By displaying the corresponding lower-level dimension value based on the selected upper-level dimension value, the loading and rendering of dimension values ​​are more targeted.

[0053] In some embodiments, determining at least one dimension value input on each dimension includes: receiving batch dimension values ​​imported from the outside, and identifying the target dimension value in the batch dimension value information. By inputting batch dimension values, the input efficiency of dimension values ​​is improved, and the automatic recognition technology batch inserts data in multiple formats to achieve batch pasting of dimension values. Each dimension value in the batch dimension value is separated by a comma, or space, or line break. For example: A01, A02, A03, or A01 A02 A03, or A01, A02, A03, or A01 line break A02 line break A03, or directly copying the horizontal and vertical batch paste data of the Excel document to the automatic recognition area to automatically recognize and generate a dimension value list. It can also support the automatic recognition of batch setting of dimension values ​​by copying the offline report document horizontally or vertically.

[0054] In some embodiments, determining at least one dimension value entered for each dimension includes: for any dimension, upon detecting a variable setting operation, displaying a variable setting box, wherein the variable setting box includes a variable name and a corresponding dimension value; and querying the dimension value corresponding to the variable to determine the corresponding dimension value of the dimension. For a particular dimension, a variable setting control corresponding to the dimension can be clicked to display a variable setting box, wherein the variable setting box includes a variable name and a corresponding dimension value; and querying the dimension value corresponding to the variable to determine the corresponding dimension value of the dimension. That is, based on the variable query, the corresponding basic data can be updated to update the corresponding position of the dimension.

[0055] On the basis of the above technical solution, the dimension value list of each dimension is edited in response to one or more of the following editing operations, and the editing operations include: adding dimension values, copying dimension values, modifying display content, deleting or batch deleting selected dimensions or dimension values, modifying the dimension value sorting based on dragging operations, and modifying the dimension value sorting based on modification serial numbers.

[0056] Specifically, you can design codes for multidimensional reports. By deleting a code in a row or region, you can delete the dimension value in that row, while copying the corresponding code will copy the dimension value. You can also display a row of configured dimension ranges as header information by default, and edit each row and column to store dimension values ​​and add new positions. You can also modify the order of dimension values ​​by dragging and dropping, or by modifying the order by sequence number.

[0057] For example, a row of configured dimension range is displayed as header information by default, and each row and column is edited to store dimension values; the order of the entire row of data is changed by designing the parameters of the multi-dimensional report template code, row line, and area position; the copy operation quickly copies the current entire row of data to the next row by designing the code, row line, and area position of the multi-dimensional report template, so that only the dimension values ​​different from the copied row are changed; the deletion operation deletes all data in the current row by designing the code, row line, and area position of the multi-dimensional report template; adding a new row displays the selected dimension content by default.

[0058] S140: Generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, and visualize the multi-dimensional report.

[0059] Specifically, based on the dimensional information of each region and the corresponding dimensional values, a data combination algorithm can be used to generate multidimensional data, which is then displayed on the report designer's display interface in the corresponding data format and display format. This meets the needs of more flexible, personalized, and diversified analytical caliber management and statistical analysis reports.

[0060] In this embodiment, in the process of constructing a multi-dimensional report, the combination of dimensions and positions can be achieved by setting the dimensions on each area and the dimension values ​​on each dimension. There is no need to set each combination of dimension and dimension value separately, which simplifies the process of constructing a multi-dimensional report.

[0061] The technical solution of the embodiment of the present invention is to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; display a dimension adding interface in response to a dimension adding operation in any dimension adding area, and determine at least one dimension corresponding to the current area based on the detected dimension selection operation; display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered on each dimension; generate a multi-dimensional report based on the dimensions on each area and the dimension values ​​on each dimension, and visualize the multi-dimensional report. This solves the problem that existing report design tools only support two-dimensional report design and have poor flexibility and visualization of the table structure. It realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

[0062] Example 2

[0063] Figure 2 This is a flowchart of a multidimensional form generation method provided in Example 2 of the present invention. This example describes how, before generating a multidimensional form, you can set the visualization function and / or display style of each region or cell in the report to achieve flexible presentation of the multidimensional form. For detailed implementation details, please refer to the technical solution of this example. Technical terms that are identical or corresponding to those in the above examples are not repeated here.

[0064] like Figure 2 As shown, the method includes:

[0065] S210 . In response to the form generation operation, a dimension setting interface is displayed, where the dimension setting interface includes dimension adding areas corresponding to various areas of the form.

[0066] S220 . In response to a dimension adding operation in any dimension adding area, display a dimension adding interface, and determine at least one corresponding dimension in the current area based on the detected dimension selection operation.

[0067] S230 . In response to a dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value inputted for each dimension is determined.

[0068] S240. Set the visualization function and / or display style of each area or cell in the report.

[0069] Specifically, you can set the visualization function for each area or cell in the report. This means you can set the display method for each area and cell, such as hiding the data in a certain area or setting the display style of a certain row of data to red. Based on this, you can achieve flexibility and convenience in data visualization, making the data display clearer.

[0070] Based on the above technical solution, the visualization function of each area or cell in the report is set, including at least one of the following: setting the hiding or display of each dimension under the perspective area; setting the dimension value data displayed in the drop-down box of the filter area; setting the read-only permission or editable permission of the row / column area; setting the association between each area and the dimension value selection interface of the corresponding area; setting whether the measurement unit of the row area is displayed; setting whether the indicator explanation of the row area is displayed; setting the floating layer display information when the mouse moves into the row area.

[0071] Specifically, you can set the dimensions in the perspective area to be hidden or displayed. For example, if you set the scenario dimension in the perspective area to be hidden, the generated multidimensional form will not display content related to the scenario dimension. Only when the user sets the scenario dimension to be displayed through operation will the content data corresponding to the dimension be displayed. You can set the dimension value data displayed in the drop-down box in the filter area; you can also use buttons to set read-only or editable permissions. If the data information corresponding to a certain row is particularly important, you can set it to read-only, meaning that other users can only preview it but cannot modify the data content. You can also set whether the unit of measurement in the row area is displayed; you can also click the checkbox to display indicator explanations in the row area, so that the explanation information of the data indicator in the row is displayed at the same time as the data. At the same time, you can also set it to display all relevant information in a floating layer when the mouse moves into the row area, including dimension code, dimension value code, whether it is a variable, whether it is hidden, and whether it is read-only, so that business personnel can obtain detailed information.

[0072] Based on the above technical solution, setting the display style of each area or cell in the report includes at least one of the following: setting the background color, font color, and font format of the cells corresponding to each area; setting the data format and data format determination rules of the cells corresponding to the rows / columns; setting the content determination rules, determination threshold, prompt color, and prompt content of the cells corresponding to the rows / columns.

[0073] Specifically, according to individual needs, you can set the display style of each area or cell in the report. You can use the corresponding style controls to set the background color, font color, font format, such as bold, italic, underline, font size, left alignment, and right alignment for the cell. You can also set the data format and format determination rules. For example, if the data format of the current cell is set to a numeric value, different business rules are combined to determine the data type of each cell. You can also set the cell content determination rules, thresholds, prompt colors, and prompt content. For example, the judgment rule is to determine whether the data in the current table is greater than 1, that is, >1, and the threshold is 1. The prompt color is red and the prompt content is warning. At this time, if the data in the current table is 2, the data is judged based on the judgment rule to determine whether it is greater than 1. Obviously, it is greater than 1, so it is displayed in red and the prompt content "Warning" is displayed.

[0074] S250: Generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, and visualize the multi-dimensional report.

[0075] The technical solution of the embodiment of the present invention is to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; display a dimension adding interface in response to a dimension adding operation in any dimension adding area, and determine at least one dimension corresponding to the current area based on the detected dimension selection operation; display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered on each dimension; generate a multi-dimensional report based on the dimensions on each area and the dimension values ​​on each dimension, and visualize the multi-dimensional report. This solves the problem that existing report design tools only support two-dimensional report design and have poor flexibility and visualization of the table structure. It realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

[0076] Example 3

[0077] Figure 3 This is a schematic diagram of the structure of a multi-dimensional form generation device provided by Embodiment 3 of the present invention. The multi-dimensional form generation method provided by any embodiment of the present disclosure can be executed, and has the corresponding functional modules and beneficial effects of the execution method.

[0078] like Figure 3 As shown, the device includes:

[0079] A dimension display module 310 is configured to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to various areas of the form;

[0080] A dimension adding module 320 is configured to respond to a dimension adding operation in any dimension adding area by displaying a dimension adding interface and determining at least one dimension corresponding to the current area based on the detected dimension selection operation;

[0081] A dimension value setting module 330 is configured to display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered for each dimension;

[0082] The report generation module 340 is used to generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, and to visualize the multi-dimensional report.

[0083] Based on the above technical solution, the dimension adding interface includes an information shuttle box, which includes a first information box and a second information box; wherein the first information box is used to display selectable dimensions, and the second information box is used to display the selected dimension;

[0084] The dimension adding module 320 includes:

[0085] The dimension selection module is used to display the selected dimensions in the second information frame when detecting that one or more dimension information in the first information frame is selected, and determine the dimensions in the second information frame as at least one dimension corresponding to the current area.

[0086] Based on the above technical solution, the dimension adding module 320 further includes:

[0087] A dimension value information tree module is used to call a dimension value information tree for the current dimension based on the dimension code. The dimension value information tree includes multiple levels of dimension value information. The upper-level dimension value in the dimension value information tree is displayed in the dimension selection box. Based on the selection operation of any dimension value in the upper-level dimension value, the next-level dimension value of the selected dimension value is displayed until the last level of dimension value.

[0088] A batch import module is used to receive batch dimension values ​​imported from the outside and identify target dimension values ​​in the batch dimension value information;

[0089] The variable setting module is used to display a variable setting box for any dimension when a variable setting operation is detected, wherein the variable setting box includes the variable name and the corresponding dimension value; query the dimension value corresponding to the variable to determine the corresponding dimension value of the dimension.

[0090] On the basis of the above technical solution, the multi-dimensional form generating device further includes:

[0091] The dimension value editing module is used to edit the dimension value list of each dimension in response to one or more of the following editing operations, including: adding new dimension values, copying dimension values, modifying displayed content, deleting or batch deleting selected dimensions or dimension values, modifying the dimension value sorting based on dragging operations, and modifying the dimension value sorting based on modification sequence numbers.

[0092] On the basis of the above technical solution, the multi-dimensional form generating device further includes:

[0093] The function style setting module is used to set the visualization function and / or display style of each area or cell in the report.

[0094] Based on the above technical solution, the visualization function of each area or cell in the report is set, including at least one of the following: setting the hiding or display of each dimension under the perspective area; setting the dimension value data displayed in the drop-down box of the filter area; setting the read-only permission or editable permission of the row / column area; setting the association between each area and the dimension value selection interface of the corresponding area; setting whether the measurement unit of the row area is displayed; setting whether the indicator explanation of the row area is displayed; setting the floating layer display information when the mouse moves into the row area.

[0095] Based on the above technical solution, setting the display style of each area or cell in the report includes at least one of the following: setting the background color, font color, and font format of the cells corresponding to each area; setting the data format and data format determination rules of the cells corresponding to the rows / columns; setting the content determination rules, determination threshold, prompt color, and prompt content of the cells corresponding to the rows / columns.

[0096] The technical solution of the embodiment of the present invention is to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; display a dimension adding interface in response to a dimension adding operation in any dimension adding area, and determine at least one dimension corresponding to the current area based on the detected dimension selection operation; display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered on each dimension; generate a multi-dimensional report based on the dimensions on each area and the dimension values ​​on each dimension, and visualize the multi-dimensional report. This solves the problem that existing report design tools only support two-dimensional report design and have poor flexibility and visualization of the table structure. It realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

[0097] The multi-dimensional form generation device provided in the embodiment of the present invention can execute the multi-dimensional form generation method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0098] Example 4

[0099] See also Figure 4 , Figure 4 This is a structural diagram of a multi-dimensional form generation system provided by an embodiment of the present invention. In some embodiments, the multi-dimensional form generation system can be a multi-dimensional report designer. Its specific implementation method can refer to the technical solution of this embodiment. Among them, the technical terms that are the same as or corresponding to the above embodiments are not repeated here. Figure 4 The multi-dimensional form generation system includes:

[0100] Dimension management component 410, for displaying a corresponding dimension management interface in response to a trigger operation, and determining at least one dimension corresponding to each region in response to an edit operation on any dimension management interface;

[0101] Dimension value management component 420, for displaying a dimension value management interface and, in response to a dimension value editing operation, determining the dimension value corresponding to each dimension; and, in response to a dimension value editing operation, editing an input dimension value;

[0102] The report generation component 430 is used to generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension.

[0103] The system further comprises: a visualization component for setting a visualization function of each region or cell in the report in response to a visualization setting operation;

[0104] The style management component is used to set the display style of each area or cell in the report in response to the style setting operation.

[0105] The dimension management component includes region modules A1 and A2; the dimension value management component includes a dimension value list component and a dimension value selection component. The dimension value selection component includes a dimension value selection module A4, a variable selection module A5, and an automatic identification and batch insertion module A6. The visualization component includes a visualization module A7, and the style management component includes a personalization module A8.

[0106] 1. Dimension Management Component

[0107] 1. Regional Module A1:

[0108] (A101) Insert dimension management component into the interface, based on the key-value pair data of the regional schema map object: you can configure the name and code of each region in the dimension component

[0109] (A102) In addition to displaying regional dimension operation information, the component uses slots to make the dimension component more flexible and customizable with extended content.

[0110] 2. Dimension Module A2

[0111] (A201) Through the shuttle box, the left column shows all configurable dimension sources, and the dimensions defined in other areas are grayed out. The right column shows the selected dimension range target. Use the buttons in the two columns to quickly move elements to complete single or multiple dimension selection operations;

[0112] (A202) Based on the LocalStorage persistent storage method, selected dimensions in other regions cannot be defined repeatedly.

[0113] 2. Dimension Value List Component

[0114] (A301) By default, a row of configured dimension ranges is displayed as the table header information, and each row and column can be edited to store dimension values;

[0115] (A302) Move up / down rows to change the order of the entire row of data through the parameters of the multi-dimensional report template code, line line, and area position;

[0116] (A303) The copy operation quickly copies the entire row of data to the next row by designing the code, line, and area position of the multi-dimensional report template. This allows business personnel to only change the dimension values ​​that are different from the copied row.

[0117] (A304) The delete operation deletes all data in the current row by designing the code, line, and area position of the multi-dimensional report template;

[0118] (A305) Add a new row to display the selected dimension content by default.

[0119] 3. Dimension Value Selection Component

[0120] 1. Dimension value selection module A4

[0121] (A401) Asynchronously loading tree-structured dimension value basic data through dimension coding and dimension value coding;

[0122] (A402) Dimension value basic data includes: member, child, child contains, descendant, descendant contains buttons to obtain asynchronously loaded data lists through hierarchical selection. It also supports the level field to obtain data lists of different levels of dimensions (second level, third level), such as dimensions such as organizations.

[0123] 2. Variable selection module A5

[0124] (A501) Use variable design architecture to synchronize and automatically update reports. When designing a report, you can select variables for certain dimensions (D). When the value of a report dimension (D) changes, you only need to modify the variable value of the underlying data to update the report template, eliminating the need to recreate identical report templates.

[0125] 3. Automatic identification of batch insertion module A6

[0126] (A601) By developing automatic recognition technology, batch inserting data in various formats allows batch pasting of dimension values ​​separated by commas, spaces, or line breaks. For example: A01, A02, A03, or A01A02A03, or A01, A02, A03, or A01 line break, A02 line break, A03. Alternatively, you can directly batch paste data horizontally or vertically from an Excel document into the automatic recognition area to automatically generate a dimension value list. This also supports batch dimension value setting by automatically recognizing and copying offline report documents horizontally or vertically.

[0127] 4. Visual Preview and Personalized Customization Components

[0128] 1. Visualization module A7

[0129] (A701) After all region data is adapted, each region renders each component through lazy loading. A placeholder image is provided where content needs to be loaded.

[0130] (A702) The viewing area can control each dimension to hide or show;

[0131] (A703) The drop-down box in the filter area displays multiple dimension value data;

[0132] (A704) The row / column area quickly splices N*N multidimensional data by studying the N-dimensional superposition data combination algorithm. For example, A1, A2...An and B1, B2...Bn and C1, C2...Cn are combined to generate: A1B1C1, A1B1C2, ....A1B1Cn, A1B2C1, A1B2C2, ....A1B2Cn, A2B1C1....n columns or n rows of header combination data;

[0133] (A705) Row / column areas can be set to read-only or editable via buttons;

[0134] (A706) Row Area Display a row of measurement unit information by clicking the checkbox in the row area;

[0135] (A707) Row Area Display the model explanation by clicking the checkbox row area;

[0136] (A708) When you move the mouse into a row area, a bubble pop-up window displays all relevant information. This includes the dimension code, dimension value code, whether it is a variable, whether it is hidden, and whether it is read-only, allowing business personnel to obtain detailed information.

[0137] (A709) The width and height of the row and column area table are customized according to the amount of data generated by the combination.

[0138] (A710) Save viewing area and filter area;

[0139] (A711) Saving a multidimensional report template involves transferring all information related to the associated cells and rule logic to the backend using the x- and y-axis coordinates of each cell as the key and the value as the object model. Each cell contains (x- and y-axis dimensions and values, area position, x- and y-axis coordinate information, whether it is a variable, whether it is a header, whether it is a data area, cell content, hierarchy information, display or hide, and style information). The backend uses the data information transferred from the frontend to store the data in different areas in different database tables, and also stores the dimension value information corresponding to each cell in a flat format in the database table.

[0140] (A712) Generate organization variables. The backend extracts data based on the selected organization dimension values ​​and stores them separately in the database for easy use in report queries.

[0141] (A713) After successful storage, the report interface can view and fill in the electronic document generated by the multi-dimensional report template design.

[0142] The above technical solutions effectively solve the pain point of the existing tools being inflexible.

[0143] 2. Personalization module A8

[0144] (A801) Supports styling by setting personalized object data in rows, columns, and cells based on personalized needs. Personalized object data is stored in row, line, and cell coordinates, and personalized data is combined when the table data is looped and rendered, and personalized data is added to each x-y coordinate. For example: background color, font color, bold, italic, underline, font size, left alignment, right alignment, read-only, hidden, and unit settings (ten thousand, thousandth, decimal point, etc.) for the entire row, column, or cell.

[0145] (A802) Initializes cell data types and write permissions. Determine the data type (value, text, percentage, etc.) of each cell through a combination of different business rules, and determine whether each cell is writable through the permission system.

[0146] (A803) Each cell can be set with >, <, =, >=, <=, !=, data value, prompt color, prompt text, and validation rules for each cell, row, or column.

[0147] The above technical solutions effectively solve the pain point of the existing tools being inflexible.

[0148] Figure 5This is a flowchart of a multidimensional report generation system implementing a multidimensional report generation method, provided in Example 4 of the present invention. The components in the multidimensional report generation system are called sequentially and, in response to input editing operations, implement the settings of dimensions and dimension values ​​in the multidimensional report, as well as the settings of visualization functions and personalized styles for the multidimensional report, thereby obtaining a multidimensional report that meets visualization and sample requirements.

[0149] The technical solution of the embodiment of the present invention is to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; display a dimension adding interface in response to a dimension adding operation in any dimension adding area, and determine at least one dimension corresponding to the current area based on the detected dimension selection operation; display a dimension value setting interface in response to a dimension value adding operation for any dimension, and determine at least one dimension value entered on each dimension; generate a multi-dimensional report based on the dimensions on each area and the dimension values ​​on each dimension, and visualize the multi-dimensional report. This solves the problem that existing report design tools only support two-dimensional report design and have poor flexibility and visualization of the table structure. It realizes the generation and visual display of multi-dimensional forms, improves the flexibility of forms, and meets the personalized needs of users.

[0150] Example 5

[0151] Figure 6 : is a structural diagram of an electronic device provided in Embodiment 4 of the present invention. The electronic device 50 is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0152] like Figure 6As shown, the electronic device 50 includes at least one processor 51 and a memory, such as a read-only memory (ROM) 52, a random access memory (RAM) 53, etc., which is communicatively connected to the at least one processor 51. The memory stores a computer program that can be executed by the at least one processor. The processor 51 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 52 or the computer program loaded from the storage unit 58 into the random access memory (RAM) 53. Various programs and data required for the operation of the electronic device 50 can also be stored in the RAM 53. The processor 51, ROM 52, and RAM 53 are connected to each other via a bus 54. An input / output (I / O) interface 55 is also connected to the bus 54.

[0153] Multiple components in the electronic device 50 are connected to the I / O interface 55, including an input unit 56, such as a keyboard, a mouse, etc.; an output unit 57, such as various types of displays, speakers, etc.; a storage unit 58, such as a magnetic disk, an optical disk, etc.; and a communication unit 59, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 59 allows the electronic device 50 to exchange information / data with other devices via a computer network such as the Internet and / or various telecommunication networks.

[0154] The processor 51 can be a variety of general-purpose and / or specialized processing components with processing and computing capabilities. Some examples of the processor 51 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 51 executes the various methods and processes described above, such as the XX method.

[0155] In some embodiments, the multidimensional form generation method can be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 58. In some embodiments, part or all of the computer program can be loaded and / or installed on electronic device 50 via ROM 52 and / or communication unit 59. When the computer program is loaded into RAM 53 and executed by processor 51, one or more steps of the multidimensional form generation method described above can be performed. Alternatively, in other embodiments, processor 51 can be configured to execute the multidimensional form generation method via any other suitable means (e.g., via firmware).

[0156] Various embodiments of the systems and techniques described herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), system-on-chip systems (SOCs), programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include being implemented in one or more computer programs that are executable and / or interpreted on a programmable system that includes at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0157] Computer programs for implementing the multi-dimensional form generation method of the present invention can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that, when executed by the processor, the computer programs implement the functions / operations specified in the flowcharts and / or block diagrams. The computer programs can be executed entirely on the machine, partially on the machine, as a standalone software package, partially on the machine and partially on a remote machine, or entirely on a remote machine or server.

[0158] Example 6

[0159] Embodiment 6 of the present invention further provides a computer-readable storage medium storing computer instructions, the computer instructions being used to cause a processor to execute a method for generating a multi-dimensional form, the method comprising:

[0160] In response to the form generation operation, a dimension setting interface is displayed, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form;

[0161] In response to a dimension adding operation in any dimension adding area, a dimension adding interface is displayed, and at least one corresponding dimension in the current area is confirmed based on the detected dimension selection operation;

[0162] In response to a dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value entered for each dimension is determined;

[0163] Based on the dimensions of each region and the dimension values ​​of each dimension, a multi-dimensional report is generated, and the multi-dimensional report is visualized.

[0164] In the context of the present invention, computer-readable storage media can be tangible media that can contain or store a computer program for use with an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. Computer-readable storage media can include but are not limited to electronic, magnetic, optical, electromagnetic, infrared or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, computer-readable storage media can be machine-readable signal media. More specific examples of machine-readable storage media can include electrical connections based on one or more lines, portable computer disks, hard disks, random access memories (RAM), read-only memories (ROM), erasable programmable read-only memories (EPROM or flash memory), optical fibers, portable compact disk read-only memories (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0165] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0166] The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0167] A computing system may include clients and servers. The clients and servers are typically remote from each other and typically interact via a communication network. This client-server relationship arises through computer programs running on the respective computers, creating a client-server relationship. The server may be a cloud server, also known as a cloud computing server or cloud host. This server is a hosting product within the cloud computing service ecosystem that addresses the management difficulties and limited scalability of traditional physical hosting and VPS services.

[0168] It should be understood that the various forms of the processes shown above can be used to reorder, add, or delete steps. For example, the steps described in the present invention can be performed in parallel, sequentially, or in a different order, as long as the desired results of the technical solution of the present invention can be achieved. This is not limited herein.

[0169] The above specific embodiments do not limit the scope of protection of the present invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions may be made based on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention are intended to be included within the scope of protection of the present invention.

Claims

1. A multi-dimensional form generation method, characterized in that: include: In response to the form generation operation, a dimension setting interface is displayed, wherein the dimension setting interface includes dimension adding areas corresponding to each area of ​​the form; wherein each area of ​​the form includes a row area, a column area, a filter area, and a view area; In response to a dimension adding operation in any dimension adding area, displaying a dimension adding interface, and determining at least one dimension corresponding to the current area based on the detected dimension selection operation; In response to the dimension value adding operation for any dimension, a dimension value setting interface is displayed, and at least one dimension value entered for each dimension is determined; wherein a dimension value is a numerical value corresponding to a certain dimension; Generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, and visualize the multi-dimensional report, including: based on the dimension information of each region and the dimension values ​​corresponding to each dimension, obtain multi-dimensional data through a data combination algorithm, and display the multi-dimensional data on a display interface of a report designer according to corresponding data formats and display formats; The dimension adding interface includes an information shuttle box, which includes a first information box and a second information box; wherein the first information box is used to display selectable dimensions, and the second information box is used to display the selected dimension; The determining, based on the detected dimension selection operation, at least one dimension corresponding to the current region includes: When detecting that one or more dimension information is selected in the first information box, displaying the selected dimension in the second information box, and determining the dimension in the second information box as at least one dimension corresponding to the current region; determining at least one dimension value input in each dimension includes: For the current dimension, a dimension value information tree is called based on the dimension code. The dimension value information tree includes multi-level dimension value information. The upper dimension value in the dimension value information tree is displayed in the dimension selection box. Based on the selection operation of any dimension value in the upper dimension value, the next layer of dimension values ​​of the selected dimension value is displayed until the last layer of dimension values. or, Receiving externally imported batch dimension values, and identifying target dimension values ​​in the batch dimension value information; or, For any dimension, when a variable setting operation is detected, a variable setting box is displayed, wherein the variable setting box includes the variable name and the corresponding dimension value; the dimension value corresponding to the variable is queried to determine the corresponding dimension value of the dimension.

2. The method according to claim 1, characterized in that The method further comprises: In response to one or more of the following editing operations, the dimension value list of each dimension is edited, and the editing operations include: adding new dimension values, copying dimension values, modifying display content, deleting or batch deleting selected dimensions or dimension values, modifying the dimension value sorting based on drag operations, and modifying the dimension value sorting based on modification sequence numbers.

3. The method according to claim 1, characterized in that Before generating a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, the method further includes: Set the visualization function and / or display style for each area or cell in the report.

4. The method according to claim 3, characterized in that Set the visualization function for each area or cell in the report, including at least one of the following: Set the hiding or display of each dimension in the viewing area; Set the dimension value data displayed in the drop-down box of the filter area; Set read-only or editable permissions for row / column areas; Set the association between each region and the corresponding region dimension value selection interface; Set whether the measurement unit of the row area is displayed; Set whether to display the indicator explanation in the row area; Set the floating layer display information when the mouse moves into the row area.

5. The method according to claim 3, characterized in that Setting the display style of each area or cell in the report includes at least one of the following: Set the background color, font color, and font format of the cells corresponding to each area; Set the data format and data format determination rules for the cells corresponding to the row / column; Set the content judgment rules, judgment threshold, prompt color and prompt content for the cells corresponding to the row / column.

6. A multi-dimensional form generating device, characterized in that: include: A dimension display module, configured to display a dimension setting interface in response to a form generation operation, wherein the dimension setting interface includes dimension adding areas corresponding to various areas of the form; wherein the various areas of the form include a row area, a column area, a filter area, and a view area; A dimension adding module is configured to respond to a dimension adding operation in any dimension adding area, display a dimension adding interface, and determine at least one corresponding dimension in the current area based on the detected dimension selection operation; A dimension value setting module is used to display a dimension value setting interface in response to a dimension value addition operation for any dimension, and determine at least one dimension value entered for each dimension; wherein a dimension value is a numerical value corresponding to a dimension; A report generation module is used to generate a multi-dimensional report based on the dimensions of each region and the dimension values ​​of each dimension, and to visually display the multi-dimensional report, including: obtaining multi-dimensional data through a data combination algorithm based on the dimension information of each region and the dimension values ​​corresponding to each dimension, and displaying the multi-dimensional data on the display interface of the report designer in a corresponding data format and display format; The dimension adding interface includes an information shuttle box, which includes a first information box and a second information box; wherein the first information box is used to display selectable dimensions, and the second information box is used to display the selected dimension; The dimension adding module includes: A dimension selection module is configured to, upon detecting that one or more dimension information in the first information frame is selected, display the selected dimension in the second information frame, and determine the dimension in the second information frame as at least one dimension corresponding to the current region; The dimension adding module also includes: A dimension value information tree module is used to call a dimension value information tree for the current dimension based on the dimension code. The dimension value information tree includes multiple levels of dimension value information. The upper-level dimension value in the dimension value information tree is displayed in the dimension selection box. Based on the selection operation of any dimension value in the upper-level dimension value, the next-level dimension value of the selected dimension value is displayed until the last level of dimension value. A batch import module is used to receive batch dimension values ​​imported from the outside and identify target dimension values ​​in the batch dimension value information; The variable setting module is used to display a variable setting box for any dimension when a variable setting operation is detected, wherein the variable setting box includes the variable name and the corresponding dimension value; query the dimension value corresponding to the variable to determine the corresponding dimension value of the dimension.

7. A multi-dimensional form generation system, characterized in that: include: A dimension management component, configured to display a corresponding dimension management interface in response to a trigger operation, and to determine at least one dimension corresponding to each area in response to an edit operation on any dimension management interface; wherein each area of ​​a form includes a row area, a column area, a filter area, and a view area; The dimension value management component is used to display the dimension value management interface and, in response to dimension value editing operations, determine the dimension value corresponding to each dimension; and, in response to dimension value editing operations, edit the input dimension value; wherein the dimension value is the numerical value corresponding to a dimension; The report generation component is used to generate multi-dimensional reports based on the dimensions of each area and the dimension values ​​of each dimension, including: obtaining multi-dimensional data through data combination algorithms based on the dimension information of each area and the dimension values ​​corresponding to each dimension, and displaying the multi-dimensional data on the display interface of the report designer in accordance with the corresponding data format and display format.

8. The system according to claim 7, characterized in that The system further comprises: A visualization component is used to set the visualization function of each area or cell in the report in response to the visualization setting operation; The style management component is used to set the display style of each area or cell in the report in response to the style setting operation.

Images