Multi-dimensional data display method and device, computer device and storage medium

Abstract

The application relates to a multi-dimensional data display method and device, computer equipment and a storage medium, and relates to the technical field of databases. The method comprises the following steps: in response to a region setting operation performed on a data display layer, obtaining region information of a data region corresponding to a table sample in the data display layer; the region information comprises a region range and data dimension information; displaying the data region in the data display layer according to the region information; expanding the data region in two dimensions according to the data dimension information to obtain a dimension member setting region; in response to a member setting operation performed in the dimension member setting region, obtaining a multi-dimensional member combination; and displaying multi-dimensional data corresponding to the multi-dimensional member combination in the data region. The method can improve efficiency.

Description

Technical Field

[0001] This application relates to the field of database technology, and in particular to a method, apparatus, computer device, and storage medium for multidimensional data display. Background Technology

[0002] In software systems, report data is typically displayed in tabular form. Before displaying report data, it is necessary to set a report template to indicate which data should be displayed.

[0003] Currently, when displaying multidimensional data in reports, the dimension member information of report cells can be set in the report template, so that the report data corresponding to the dimension members is displayed in the table when the report is displayed. However, when setting dimension members for cells in existing reports, it is necessary to switch back and forth between the report page and the dimension member setting window page, and the dimension members must be set for each cell in the report. This leads to very low efficiency, and if there are many dimension members to set, it will significantly increase the workload. Summary of the Invention

[0004] Therefore, it is necessary to provide a multidimensional data display method, apparatus, computer equipment, and storage medium that can improve efficiency in addressing the aforementioned technical problems.

[0005] Firstly, this application provides a method for multidimensional data visualization. The method includes:

[0006] In response to the region setting operation performed on the data display layer, obtain the region information of the data region corresponding to the table pattern in the data display layer; the region information includes the region range and data dimension information.

[0007] Display the data region in the data display layer based on the region information;

[0008] The data region is expanded in two dimensions based on the data dimension information to obtain the dimension member setting region;

[0009] The response to member setting operations performed in the dimension member setting area yields a multi-dimensional member combination;

[0010] The data area displays the multidimensional data corresponding to the combination of multidimensional members.

[0011] Secondly, this application also provides a multi-dimensional data display device. The device includes:

[0012] The region setting module is used to respond to region setting operations performed on the data display layer and obtain the region information of the data region corresponding to the table pattern in the data display layer; the region information includes the region range and data dimension information.

[0013] The region display module is used to display data regions in the data display layer based on region information;

[0014] The two-dimensional expansion module is used to expand the data area in two dimensions based on the data dimension information to obtain the dimension member setting area;

[0015] The member setting module is used to respond to member setting operations performed in the dimension member setting area and obtain multi-dimensional member combinations;

[0016] The data display module is used to display multidimensional data corresponding to combinations of multidimensional members in the data area.

[0017] In some embodiments, data dimension information includes the number of dimensions and the order of dimensions for each dimension item. The two-dimensional expansion module is further configured to expand the data area according to the number of dimensions to obtain a dimension member setting area; the dimension member setting area includes a dimension item display area; and each dimension item is displayed in the dimension item display area according to the dimension order.

[0018] In some embodiments, each dimension item includes row dimension items and column dimension items, and the number of dimensions includes the number of row dimension items and the number of column dimension items. The two-dimensional expansion module is further configured to determine the number of rows to be expanded to and the number of columns to be expanded to the data area based on the number of row dimension items and the number of column dimension items, respectively; starting from the beginning position of the data area, perform row expansion processing in the data area based on the number of row expansions, and perform column expansion processing in the data area based on the number of column expansions, to obtain the dimension member setting area.

[0019] In some embodiments, the dimension member setting area includes a row dimension member setting area and a column dimension member setting area. The row dimension member setting area is the row area where the row dimension items are filled into the dimension item display area, and the column dimension member setting area is the column area where the column dimension items are filled into the dimension item display area. The member setting module is also used to respond to the row dimension items and column dimension items displayed in the dimension item display area, and to input the corresponding dimension members under the row dimension items and column dimension items in each row area of ​​the row dimension member setting area and each column area of ​​the column dimension member setting area, respectively, to obtain a multi-dimensional member combination.

[0020] In some embodiments, the member setting module is further configured to respond to a batch member entry operation performed in the dimension member setting area by batch entering multiple pre-configured multi-dimensional member combinations into the dimension member setting area; the multiple pre-configured multi-dimensional member combinations are obtained by pre-setting dimension members with reference to the row area and column area where the row dimension item and column dimension item are located.

[0021] In some embodiments, the data display module is further configured to respond to multidimensional data display operations by performing two-dimensional shrinking of the dimension member setting area to restore the display data area; obtaining multidimensional data corresponding to the multidimensional member combination from the multidimensional database; and displaying the multidimensional data in the data area.

[0022] In some embodiments, the multidimensional member combination includes row dimension member groups and column dimension member groups, and the data area includes multiple cells for data display. The data display module is further configured to: determine the cells where the row dimension member groups and column dimension member groups intersect in the two-dimensional extended data area to obtain their respective corresponding reference cells; determine the target cells corresponding to each reference cell in the restored display data area; and query the multidimensional data of the row dimension member groups and column dimension member groups corresponding to each reference cell from the multidimensional database, so as to display the multidimensional data in the target cells corresponding to each reference cell.

[0023] Thirdly, this application also provides a computer device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the steps in the above-mentioned multidimensional data display method.

[0024] Fourthly, this application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps in the above-described multidimensional data display method.

[0025] Fifthly, this application also provides a computer program product, which includes a computer program that, when executed by a processor, implements the steps in the above-described multidimensional data display method.

[0026] The aforementioned multidimensional data display method, apparatus, computer equipment, storage medium, and computer program product, by responding to region setting operations performed on the data display layer, obtains region information of the data region corresponding to the table in the data display layer; the region information includes region range and data dimension information. Based on the region information, the data region is displayed in the data display layer; based on the data dimension information, the data region is expanded two-dimensionally to obtain a dimension member setting region. This allows for the setting of dimension members and the display of multidimensional data on the same page layer, avoiding the increased number of interactions caused by switching back and forth between the report page and the dimension member setting window page, thus improving efficiency and reducing workload. Responding to member setting operations performed in the dimension member setting region, a multidimensional member combination is obtained; the multidimensional data corresponding to the multidimensional member combination is displayed in the data region. By expanding the data region two-dimensionally, multidimensional combination settings exceeding two dimensions can be quickly set in a tiled manner within the two-dimensional data display layer, greatly reducing the number of interactions for dimension member settings. If there are many dimension members to be set, various batch setting functions can be used in the tiled dimension member setting region to batch set dimension members, further improving efficiency. Attached Figure Description

[0027] Figure 1 This is a schematic diagram illustrating the application environment of the multidimensional data display method in some embodiments;

[0028] Figure 2 This is a flowchart illustrating the multidimensional data display method in some embodiments;

[0029] Figure 3 This is a schematic diagram of the table settings in some embodiments;

[0030] Figure 4 This is a schematic diagram showing the data area settings in some embodiments;

[0031] Figure 5 A schematic diagram illustrating the setting of regions and data regions for dimensional members of a two-dimensional extension in some embodiments;

[0032] Figure 6 This is a schematic diagram illustrating the multidimensional data display in some embodiments;

[0033] Figure 7 Here are some structural block diagrams of the multidimensional data display device in some embodiments;

[0034] Figure 8 These are internal structural diagrams of the computer device in some embodiments;

[0035] Figure 9 This is an internal structural diagram of a computer device in some other embodiments. Detailed Implementation

[0036] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0037] The multidimensional data display method provided in this application embodiment can be applied to, for example... Figure 1 In the application environment shown, it should be noted that terminal 102 can communicate with multidimensional database 104 via a network. The data storage system can store the data that terminal 102 needs to process. The data storage system can be integrated on terminal 102 or placed in the cloud or other network servers. Terminal 102 responds to the region setting operation performed on the data display layer, obtaining region information of the data region corresponding to the table pattern in the data display layer; the region information includes the region range and data dimension information. Terminal 102 displays the data region in the data display layer according to the region information. Terminal 102 expands the data region two-dimensionally according to the data dimension information, obtaining the dimension member setting region. Terminal 102 responds to the member setting operation performed in the dimension member setting region, obtaining the multidimensional member combination. Terminal 102 retrieves the multidimensional data corresponding to the multidimensional member combination from multidimensional database 104 and displays it in the data region.

[0038] The terminal 102 may be, but is not limited to, various personal computers, laptops, smartphones, tablets, IoT devices, and portable wearable devices.

[0039] A multidimensional database (MDD) is composed of many objects similar to multidimensional arrays and is a type of database that directly stores multidimensional data. In essence, a multidimensional database stores at least one combination of multidimensional members and the corresponding multidimensional data for that combination. A multidimensional member combination is a group of dimension members defined by the multidimensional database, while the multidimensional data is the specific data value corresponding to that combination.

[0040] In some embodiments, such as Figure 2 As shown, a multi-dimensional data display method is provided, which is illustrated using a terminal as an example. It is understood that this method can be implemented by the terminal alone, or through interaction between the terminal and a server. In this embodiment, the method includes, but is not limited to, the following steps:

[0041] Step 202: Respond to the region setting operation performed on the data display layer to obtain the region information of the data region corresponding to the table pattern in the data display layer.

[0042] The data display layer refers to the layer used to display multidimensional data and to set the corresponding multidimensional member combinations. It should be noted that after the user sets the multidimensional member combinations, the terminal can query the corresponding multidimensional data from the multidimensional database to display the multidimensional data in the data display layer.

[0043] In some embodiments, a data display layer can be set in a software system. For example, a data display layer can be set in a report display system, and the corresponding data area for displaying multidimensional data can be a data report of a spreadsheet, and the multidimensional data displayed can be report data.

[0044] The area setting operation refers to the user setting the area range of the data region to be displayed in the data display layer, as well as defining the items of each dimension.

[0045] The data area's regional information includes the area's extent and data dimension information. The area's extent refers to the region occupied within the data display layer, while the data dimension information refers to the user-defined dimension items and their corresponding details.

[0046] Specifically, when a user performs a region setting operation in the data display layer, the terminal responds to the region setting operation and obtains the region range and data dimension information of the data area corresponding to the table in the data display layer.

[0047] In some embodiments, users can first set a table pattern in the data display layer. When setting the data area, they can specify its range and position information relative to the table pattern, thereby obtaining the area range of the data area. The set table pattern does not update with updates to the multidimensional data. It can be understood that the table pattern serves to interpret the multidimensional data; in some cases, the combination of multidimensional members corresponding to the multidimensional data can be directly set as the table pattern of the multidimensional data. For example... Figure 3 As shown, users can pre-set table templates in the data display layer. The set table template occupies two cells. The first cell displays the template for management expenses, and the second cell displays the template for version-currency A-budget amount-entry.

[0048] In other embodiments, users can first perform area setting operations in the data display layer. After determining the data area and the set multidimensional member combination, they can set the table style corresponding to the data area in the data display layer according to the set multidimensional member combination.

[0049] In some embodiments, such as Figure 4As shown, the terminal can pop up an interface for setting data regions. This interface displays input boxes for setting the region range and for setting the starting position of multidimensional data. Users can enter the region range and starting position in these two input boxes, such as D2:H8 and E3. The interface also allows setting hidden dimensions to specify which dimensions should be hidden, and further configuration of individual dimensions, such as subject, version, currency, data type, and clue.

[0050] Step 204: Display the data region in the data display layer based on the region information.

[0051] Specifically, the terminal determines the range of the data area based on the area information, and displays the data area in the data display layer according to the range of the data area.

[0052] Step 206: Expand the data region in two dimensions based on the data dimension information to obtain the dimension member setting region.

[0053] The dimension member setting area refers to the area obtained by expanding the data area in two dimensions, which is used to set specific combinations of dimension members.

[0054] Specifically, the terminal expands the data area in two dimensions based on the dimension information to create an area for setting specific combinations of dimension members, thus obtaining the dimension member setting area.

[0055] Step 208: Respond to the member setting operation performed in the dimension member setting area to obtain the multi-dimensional member combination.

[0056] Among them, member setting operation refers to the operation of setting the specific dimension members corresponding to each dimension item in the dimension information. Multidimensional member combination refers to the combination of the various dimension members corresponding to each dimension item.

[0057] For example, suppose each dimension includes subject, version, currency, data type, and lead. The dimension member under subject is administrative fee, the dimension member under version is undifferentiated version, the dimension member under currency is currency A, the dimension member under data type is budget amount, and the dimension member under lead is entry. Then the multi-dimensional member combination is: [administrative fee, undifferentiated version, currency A, budget amount, entry].

[0058] Specifically, the user performs member setting operations in the dimension member setting area, and the terminal responds to the member setting operation to determine the multi-dimensional member combination set by the user.

[0059] Step 210: Display the multidimensional data corresponding to the multidimensional member combination in the data area.

[0060] Specifically, the terminal can directly retrieve multidimensional data corresponding to multidimensional member combinations from a multidimensional database and display the retrieved multidimensional data in the data area. Alternatively, the terminal can first perform a two-dimensional collapse of the expanded dimension member setting area, and then display the multidimensional data corresponding to the multidimensional member combinations in the data area.

[0061] The aforementioned multidimensional data display method, by responding to region setting operations performed on the data display layer, obtains region information of the data region corresponding to the table format in the data display layer; the region information includes the region range and data dimension information. Based on the region information, the data region is displayed in the data display layer; based on the data dimension information, the data region is expanded two-dimensionally to obtain the dimension member setting area. This allows for setting dimension members and displaying multidimensional data on the same page layer, avoiding the increased interaction caused by switching back and forth between the report page and the dimension member setting window, thus improving efficiency and reducing workload. Responding to member setting operations performed in the dimension member setting area, multidimensional member combinations are obtained; the multidimensional data corresponding to the multidimensional member combinations is displayed in the data area. By expanding the data region two-dimensionally, multidimensional combination settings exceeding two dimensions can be quickly set in a tiled manner within the two-dimensional data display layer, greatly reducing the number of interactions for dimension member settings. If there are many dimension members to be set, various batch setting functions can be used in the tiled dimension member setting area to batch set dimension members, further improving efficiency.

[0062] In some embodiments, data dimension information includes the number of dimensions and the order of dimensions for each dimension item. Step 206 specifically includes, but is not limited to: expanding the data area according to the number of dimensions to obtain a dimension member setting area; and displaying each dimension item in the dimension item display area according to the order of dimensions.

[0063] The number of dimensions refers to the number of items in each dimension, while the dimension order refers to the order in which each dimension item is displayed in the data display layer when it is defined.

[0064] The dimension member settings area includes a dimension item display area, which displays the various dimension items to be set, providing users with a reference for setting dimension members.

[0065] In some embodiments, such as Figure 4 As shown, users can also set the row and column dimension items in this interface. After setting the row and column dimension items, the number of dimensions for each dimension item and the order of the dimensions can be determined. From this interface, it can be seen that the order of the column dimension items is version, currency, data type and clue.

[0066] Specifically, the terminal expands the data area according to the number of dimensions to obtain an area where specific dimension members can be set for each dimension item—the dimension member setting area. After the area is expanded, the terminal displays each dimension in the dimension item display area according to the dimension arrangement order. By obtaining the dimension member setting area through area expansion, it ensures that only one data display layer is used to achieve the effect of setting specific dimension members and displaying the corresponding multi-dimensional data, reducing the need to switch between layers and reducing data storage volume.

[0067] In some embodiments, each dimension item includes row dimension items and column dimension items, and the number of dimensions includes the number of row dimension items and the number of column dimension items. The step "expanding the data area according to the number of dimensions to obtain the dimension member setting area" specifically includes, but is not limited to, the following: determining the number of rows to be expanded to the data area and the number of columns to be expanded according to the number of row dimension items and the number of columns to be expanded respectively; starting from the beginning of the data area, performing row expansion processing in the data area according to the number of row expansions, and performing column expansion processing in the data area according to the number of column expansions, to obtain the dimension member setting area.

[0068] Here, the number of row dimension items refers to the number of each row dimension item set by the user, and the number of column dimension items refers to the number of each column dimension item set by the user. The number of row expansions refers to the number of rows that need to be expanded in the data area, and the number of column expansions refers to the number of columns that need to be expanded in the data area.

[0069] Starting position: Used to identify the starting display position of multidimensional data.

[0070] Specifically, the terminal determines the number of rows to be expanded into the data area based on the number of row dimension items, and the number of columns to be expanded into the data area based on the number of column dimension items. Starting from the beginning of the data area, the terminal expands the data area by a number of rows matching the number of row expansions, and expands the data area by a number of columns matching the number of column expansions. The expanded rows and columns constitute the dimension member setting area. After the terminal expands the dimension member setting area, it facilitates subsequent dimension member setting operations for users within this area.

[0071] In some embodiments, assuming the user-defined row dimension items are version, currency, data type, and leads, and the user-defined column dimension item is management fee, based on the above information, the row expansion quantity can be determined to be 4, and the column expansion quantity to be 1. The terminal can then insert 4 rows and 1 column starting from the beginning of the data area, thus obtaining the following result: Figure 5The gray area shown is the dimension member setting area. The terminal then fills in the corresponding rows and columns of dimension items in the dimension member setting area, for example, in the first column according to the dimension arrangement order. Users can refer to the row and column dimension items displayed in the first column and fill in the dimension member "Undifferentiated Version" under "Version" in the first row of the second column; "Currency A" under "Currency" in the second row of the second column; "Budget Amount" under "Data Type" in the third row of the second column; "Entry" under "Clues" in the fourth row of the second column; and "Management Expenses" under "Subject" in the fifth row of the second column.

[0072] In some embodiments, the dimension member setting area includes a row dimension member setting area and a column dimension member setting area. The row dimension member setting area is the row area where the row dimension items are filled into the dimension item display area, and the column dimension member setting area is the column area where the column dimension items are filled into the dimension item display area. Step 208 specifically includes, but is not limited to, responding to the row dimension items and column dimension items displayed in the reference dimension item display area, and inputting the corresponding dimension members under the row dimension items and column dimension items in each row area of ​​the row dimension member setting area and each column area of ​​the column dimension member setting area, respectively, to obtain a multi-dimensional member combination.

[0073] Specifically, referring to the row dimension items displayed in the dimension item display area, the user enters the corresponding dimension members under each row dimension item in each row area of ​​the row dimension member setting area. Referring to the column dimension items displayed in the dimension item display area, the user enters the corresponding dimension members under each column dimension item in each column area of ​​the column dimension member setting area. The terminal then responds to the above dimension member input operations to obtain the set multi-dimensional member combination. Compared to related technologies where users select and click on dimension members one by one in a pop-up interactive interface and then click "OK" again after setting each dimension member to obtain the multi-dimensional combination members, this method of entering the corresponding dimension members in the row and column dimension member setting areas requires fewer interactions.

[0074] In some embodiments, the step "in response to the row dimension items and column dimension items displayed in the reference dimension item display area, inputting the corresponding dimension members under the row dimension items and column dimension items in each row area of ​​the row dimension member setting area and in each column area of ​​the column dimension member setting area to obtain multi-dimensional member combinations" specifically includes, but is not limited to, the following: in response to the batch member input operation performed in the dimension member setting area, batch inputting multiple pre-configured multi-dimensional member combinations into the dimension member setting area.

[0075] The pre-configured multi-dimensional member combinations are obtained by setting the dimension members in advance with reference to the row and column regions where the row and column dimension items are located. It can be understood that a multi-dimensional member combination can include only the dimension members corresponding to each row dimension item, or only the dimension members corresponding to each column dimension item, or it can include the dimension members corresponding to each row dimension item and each column dimension item simultaneously.

[0076] Specifically, users can perform batch member entry operations in the dimension member settings area. The terminal then responds to this batch member entry operation by batch entering multiple pre-configured multi-dimensional member combinations into the dimension member settings area, resulting in multiple pre-configured multi-dimensional member combinations. This method of batch entering multi-dimensional member combinations further reduces the number of interactions users need to perform in dimension member settings.

[0077] For example, suppose a user needs to enter N dimension members in the dimension member settings area. Using the methods described in related technologies, this would require clicking the cell N times and then making N settings after each click, resulting in a total of 10 interactions. However, in this application, the user can directly copy and paste the pre-configured N dimension members into the dimension member settings area, requiring only 2 interactions, significantly reducing the number of interactions for dimension member settings. Furthermore, as the number of dimension members to be set increases, the number of interactions using the original method will increase accordingly, but the number of interactions using the batch member entry operation of this application will not increase, still requiring only 2 interactions.

[0078] It's important to note that batch member entry operations include not only copying and pasting, but also cell dragging and Excel formulas. For example, if a user wants to enter values ​​from an offline table into this application's system (i.e., into an online table), they can copy and paste values ​​from an entire area, such as copying multiple pre-defined dimension members and pasting them into the dimension member settings area. Alternatively, if the names or codes of certain dimension members follow a pattern, such as incrementing, then dragging cells can achieve batch increment settings, thus enabling batch dimension member entry.

[0079] In some embodiments, step 210 specifically includes, but is not limited to: responding to the multidimensional data display operation, performing two-dimensional shrinking on the dimension member setting area to restore the display data area; obtaining multidimensional data corresponding to the multidimensional member combination from the multidimensional database, and displaying the multidimensional data in the data area.

[0080] Among them, "multidimensional data display operation" refers to the operation used to trigger the display of multidimensional data in the data area. "Two-dimensional collapse" refers to hiding the dimension member setting area in the data display layer and restoring the two-dimensional expanded data area to its original position.

[0081] Specifically, when a user performs a multidimensional data display operation in the data display layer, the terminal responds by shrinking the dimension member setting area in two dimensions to hide it and restoring the displayed data area. The terminal retrieves the multidimensional data corresponding to the multidimensional member combination from the multidimensional database and displays the retrieved multidimensional data in the data area. After setting the dimension member combination in the data display layer, simply triggering the multidimensional data display operation allows for the simultaneous display of multidimensional data on the same layer, reducing the need to switch between layers.

[0082] In some embodiments, the multidimensional member combination includes row dimension member groups and column dimension member groups, and the data area includes multiple cells for data display. The step "retrieving multidimensional data corresponding to the multidimensional member combination from the multidimensional database and displaying the multidimensional data in the data area" specifically includes, but is not limited to: in the two-dimensional extended data area, determining the cells where the row dimension member groups and column dimension member groups intersect, obtaining their respective corresponding reference cells; in the restored display data area, determining the target cells corresponding to each reference cell; querying the multidimensional data of the row dimension member groups and column dimension member groups corresponding to each reference cell from the multidimensional database, so as to display the multidimensional data in the target cells corresponding to each reference cell respectively.

[0083] Specifically, after the terminal performs a two-dimensional expansion of the data area and sets the row and column dimension member groups in the resulting dimension member setting area, the cell where the row and column dimension member groups intersect can be identified as the reference cell for the multidimensional data to be displayed. The dimension member combination corresponding to the reference cell is the intersecting row and column dimension member groups. However, because the original data area will change position after the two-dimensional expansion, and will return to its original position after the dimension member setting area is shrunk, the acquired multidimensional data cannot be directly displayed in the reference cells. Instead, it is necessary to determine the target cells corresponding to each reference cell from the restored data area and query the multidimensional database for the row and column dimension member groups corresponding to each reference cell, respectively. This ensures the accuracy of the multidimensional data display.

[0084] In some embodiments, the multidimensional data display interface can be as follows: Figure 6 As shown, the multidimensional data under the corresponding table template is displayed. For example, the multidimensional data under the table template that does not distinguish between version-currency A-budget amount-entry-management expenses is 100.

[0085] In some embodiments, the multidimensional data display method of this application further includes, but is not limited to, the following steps:

[0086] (1) Respond to the region setting operation performed on the data display layer to obtain the region information of the data region corresponding to the table pattern in the data display layer.

[0087] (2) Display the data area in the data display layer according to the area information.

[0088] (3) Determine the number of rows and columns to be extended to the data area based on the number of row dimension items and the number of column dimension items, respectively.

[0089] (4) Starting from the beginning of the data area, perform row expansion processing in the data area according to the number of row expansions, and perform column expansion processing in the data area according to the number of column expansions to obtain the dimension member setting area.

[0090] (5) Display each dimension item in the dimension item display area according to the dimension arrangement order.

[0091] (6) Respond to the batch member entry operation performed in the dimension member setting area, and batch enter multiple pre-configured multi-dimensional member combinations into the dimension member setting area.

[0092] (7) Respond to multi-dimensional data display operations and perform two-dimensional shrinking of the dimension member setting area to restore the display data area.

[0093] (8) In the two-dimensional extended data area, determine the cell where the row dimension member group and the column dimension member group intersect, and obtain their respective reference cells.

[0094] (9) In the restored data area, determine the target cell corresponding to each reference cell.

[0095] (10) Query the multidimensional data of the row dimension member group and column dimension member group corresponding to each reference cell from the multidimensional database, so as to display the multidimensional data in the target cell corresponding to each reference cell respectively.

[0096] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0097] Based on the same inventive concept, this application also provides a multidimensional data display device for implementing the multidimensional data display method described above. The solution provided by this device is similar to the implementation scheme described in the above method; therefore, the specific limitations in one or more embodiments of the multidimensional data display device provided below can be found in the limitations of the multidimensional data display method described above, and will not be repeated here.

[0098] In some embodiments, such as Figure 7 As shown, a multi-dimensional data display device is provided, including: a region setting module 702, a region display module 704, a two-dimensional extension module 706, a member setting module 708, and a data display module 710, wherein:

[0099] The region setting module 702 is used to respond to the region setting operation performed on the data display layer and obtain the region information of the data region corresponding to the table pattern in the data display layer; the region information includes the region range and data dimension information.

[0100] The region display module 704 is used to display data regions in the data display layer based on region information;

[0101] The two-dimensional extension module 706 is used to extend the data area in two dimensions according to the data dimension information to obtain the dimension member setting area;

[0102] Member setting module 708 is used to respond to member setting operations performed in the dimension member setting area to obtain multi-dimensional member combinations;

[0103] The data display module 710 is used to display multidimensional data corresponding to the combination of multidimensional members in the data area.

[0104] The aforementioned multidimensional data display device, in response to region setting operations performed on the data display layer, obtains region information corresponding to the table format in the data display layer; the region information includes the region range and data dimension information. Based on the region information, the data region is displayed in the data display layer; based on the data dimension information, the data region is expanded two-dimensionally to obtain the dimension member setting area. This allows for the setting of dimension members and the display of multidimensional data on the same page layer, avoiding the increased interaction caused by switching back and forth between the report page and the dimension member setting window, thus improving efficiency and reducing workload. In response to member setting operations performed in the dimension member setting area, multidimensional member combinations are obtained; the multidimensional data corresponding to the multidimensional member combinations is displayed in the data area. By expanding the data region two-dimensionally, multidimensional combination settings exceeding two dimensions can be quickly set in a tiled manner within the two-dimensional data display layer, greatly reducing the number of interactions for dimension member settings. If there are many dimension members to be set, various batch setting functions can be used in the tiled dimension member setting area to batch set dimension members, further improving efficiency.

[0105] In some embodiments, data dimension information includes the number of dimensions and the dimension order of each dimension item. The two-dimensional expansion module 706 is further configured to expand the data area according to the number of dimensions to obtain a dimension member setting area; the dimension member setting area includes a dimension item display area; and display each dimension item in the dimension item display area according to the dimension order.

[0106] In some embodiments, each dimension item includes row dimension items and column dimension items, and the number of dimensions includes the number of row dimension items and the number of column dimension items. The two-dimensional expansion module 706 is further configured to determine the number of rows to be expanded to and the number of columns to be expanded to the data area based on the number of row dimension items and the number of column dimension items, respectively; starting from the beginning of the data area, perform row expansion processing in the data area based on the number of row expansions, and perform column expansion processing in the data area based on the number of column expansions, to obtain the dimension member setting area.

[0107] In some embodiments, the dimension member setting area includes a row dimension member setting area and a column dimension member setting area. The row dimension member setting area is the row area where the row dimension items are filled into the dimension item display area, and the column dimension member setting area is the column area where the column dimension items are filled into the dimension item display area. The member setting module 708 is also used to respond to the row dimension items and column dimension items displayed in the dimension item display area, and to input the corresponding dimension members under the row dimension items and column dimension items in each row area of ​​the row dimension member setting area and each column area of ​​the column dimension member setting area, respectively, to obtain a multi-dimensional member combination.

[0108] In some embodiments, the member setting module 708 is further configured to respond to a batch member entry operation performed in the dimension member setting area by batch entering a plurality of pre-configured multi-dimensional member combinations into the dimension member setting area; the plurality of pre-configured multi-dimensional member combinations are obtained by pre-setting dimension members by referring to the row area and column area where the row dimension item and column dimension item are located.

[0109] In some embodiments, the data display module 710 is further configured to respond to the operation of displaying multidimensional data, perform two-dimensional shrinking of the dimension member setting area to restore the display data area; obtain multidimensional data corresponding to the combination of multidimensional members from the multidimensional database, and display the multidimensional data in the data area.

[0110] In some embodiments, the multidimensional member combination includes row dimension member groups and column dimension member groups, and the data area includes multiple cells for data display. The data display module 710 is further configured to: determine the cells where the row dimension member groups and column dimension member groups intersect in the two-dimensional extended data area to obtain their respective corresponding reference cells; determine the target cells corresponding to each reference cell in the restored display data area; and query the multidimensional data of the row dimension member groups and column dimension member groups corresponding to each reference cell from the multidimensional database, so as to display the multidimensional data in the target cells corresponding to each reference cell.

[0111] Each module in the aforementioned multidimensional data display device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of a computer device in hardware form or independent of it, or stored in the memory of a computer device in software form, so that the processor can call and execute the corresponding operations of each module.

[0112] In some embodiments, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 8 As shown, the computer device includes a processor, memory, and a network interface connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores data related to multidimensional data visualization. The network interface communicates with external terminals via a network connection. When the computer program is executed by the processor, it implements a multidimensional data visualization method.

[0113] In some embodiments, a computer device is provided, which may be a terminal, and its internal structure diagram may be as follows: Figure 9As shown, the computer device includes a processor, memory, input / output interfaces, a communication interface, a display unit, and an input device. The processor, memory, and input / output interfaces are connected via a system bus, and the communication interface, display unit, and input device are also connected to the system bus via the input / output interfaces. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The input / output interfaces are used for exchanging information between the processor and external devices. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, mobile cellular networks, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a multi-dimensional data display method. The display unit is used to form a visually visible image and can be a display screen, a projection device, or a virtual reality imaging device. The display screen can be an LCD screen or an e-ink screen. The input device of the computer device can be a touch layer covering the display screen, or buttons, trackballs, or touchpads set on the casing of the computer device, or external keyboards, touchpads, or mice, etc.

[0114] Those skilled in the art will understand that Figure 8 and Figure 9 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0115] In some embodiments, a computer device is also provided, the computer device including a memory and a processor, the memory storing a computer program, the processor executing the computer program to implement the steps in the above method embodiments.

[0116] In some embodiments, a computer program product is provided, comprising a computer program that, when executed by a processor, implements the steps in the above method embodiments.

[0117] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, data stored, data displayed, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties.

[0118] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0119] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0120] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A method for displaying multidimensional data, characterized in that, The method includes: In response to a region setting operation performed on the data display layer, region information of the data region corresponding to the table pattern in the data display layer is obtained; the region information includes region range and data dimension information; the data display layer is a layer used to display multidimensional data and set the multidimensional member combination corresponding to the multidimensional data; The data region is displayed in the data display layer according to the region information; The data area is expanded in two dimensions based on the data dimension information, and the resulting dimension member setting area is displayed. In response to the member setting operation performed in the dimensional member setting area, a multidimensional member combination is obtained; The data area displays the multidimensional data corresponding to the multidimensional member combination.

2. The method according to claim 1, characterized in that, The data dimension information includes the number of dimensions and the order of dimensions for each dimension item; the step of two-dimensionally expanding the displayed data area according to the data dimension information, and displaying the dimension member setting area obtained by the expansion, includes: Based on the number of dimensions, the data area is expanded to obtain a dimension member setting area; the dimension member setting area includes a dimension item display area. The dimension items are displayed in the dimension item display area according to the order of the dimensions.

3. The method according to claim 2, characterized in that, Each dimension item includes row dimension items and column dimension items; the number of dimensions includes the number of row dimension items and the number of column dimension items; the step of expanding the data area according to the number of dimensions to obtain the dimension member setting area includes: The number of rows to be expanded and the number of columns to be expanded to the data area are determined based on the number of row dimension items and the number of column dimension items, respectively. Starting from the beginning of the data area, row expansion is performed in the data area according to the number of row expansions, and column expansion is performed in the data area according to the number of column expansions, to obtain the dimension member setting area.

4. The method according to claim 3, characterized in that, The dimension member setting area includes a row dimension member setting area and a column dimension member setting area; the row dimension member setting area is the row area where the row dimension items are filled into the dimension item display area; the column dimension member setting area is the column area where the column dimension items are filled into the dimension item display area. The response to the membership setting operation performed in the dimensional membership setting area yields a multidimensional membership combination, including: In response to the row and column dimension items displayed in the dimension item display area, the corresponding dimension members under the row and column dimension items are entered in each row area of ​​the row dimension member setting area and each column area of ​​the column dimension member setting area to obtain a multi-dimensional member combination.

5. The method according to claim 4, characterized in that, The operation of inputting the corresponding dimension members under the row dimension item and column dimension item respectively in each row area of ​​the row dimension member setting area and each column area of ​​the column dimension member setting area in response to the row dimension item and column dimension item displayed in the dimension item display area, respectively, results in a multi-dimensional member combination, including: In response to the batch member entry operation performed in the dimension member setting area, multiple pre-configured multi-dimensional member combinations are batch entered into the dimension member setting area; the multiple pre-configured multi-dimensional member combinations are obtained by setting the dimension members in advance with reference to the row area and column area where the row dimension item and the column dimension item are located.

6. The method according to any one of claims 1 to 5, characterized in that, The display of multidimensional data corresponding to the multidimensional member combination in the data area includes: In response to multi-dimensional data operations, the area set for the dimension members is shrunk in two dimensions to restore the data area for display. Retrieve the multidimensional data corresponding to the multidimensional member combination from the multidimensional database, and display the multidimensional data in the data area.

7. The method according to claim 6, characterized in that, The multidimensional member combination includes row-dimensional member groups and column-dimensional member groups; the data area includes multiple cells for data display. The step of retrieving the multidimensional data corresponding to the multidimensional member combination from the multidimensional database and displaying the multidimensional data in the data area includes: In the two-dimensional extended data area, determine the cell where the row dimension member group and the column dimension member group intersect, and obtain their respective corresponding reference cells; In the restored data area, determine the target cell corresponding to each reference cell; The multidimensional data corresponding to the row dimension member group and column dimension member group of each reference cell are retrieved from the multidimensional database, and the multidimensional data is displayed in the target cell corresponding to each reference cell.

8. A multidimensional data display device, characterized in that, The device includes: The region setting module is used to respond to the region setting operation performed on the data display layer and obtain the region information of the data region corresponding to the table pattern in the data display layer; the region information includes the region range and data dimension information; the data display layer is a layer used to display multidimensional data and set the multidimensional member combination corresponding to the multidimensional data; The region display module is used to display the data region in the data display layer according to the region information; The two-dimensional expansion module is used to expand the displayed data area in two dimensions according to the data dimension information, and to display the dimension member setting area obtained by the expansion. The member setting module is used to respond to member setting operations performed in the dimensional member setting area to obtain multi-dimensional member combinations; The data display module is used to display multidimensional data corresponding to the multidimensional member combination in the data area.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 7.

11. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 7.

Images