A table generation method and device
By combining target dimensions and indicator identification, data is obtained and recorded in cells, the problem of low table generation efficiency in the existing technology is solved, and fast and efficient table generation and flexible data display are achieved.
Patent Information
- Application Number
- CN202111637911.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-29
- Publication Date
- 2024-11-12
- Estimated Expiration
- 2041-12-29
AI Technical Summary
In the prior art, table generation efficiency is low, and table generation is required manually, which cannot meet the rapid and efficient requirements of data analysis.
By obtaining the identification of the target dimension and indicator, obtaining the corresponding data, and determining the cell to record the corresponding content in the preset database to generate the final table.
It significantly improves the efficiency of table generation, reduces manual intervention, and can flexibly and variably meet the needs of different dimensions and indicators.
Smart Images

Figure CN114564927B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to the field of data analysis technology. Background Art
[0002] With the continuous development of science and technology, the amount of data generated is increasing, and the aggregation and analysis of data has gradually become the focus of attention in the field of computer technology. In order to quickly analyze the data, a table containing the data to be analyzed is usually generated, and further data analysis is performed based on the table. However, in the prior art, the table is manually generated by the staff, resulting in low efficiency in table generation. Summary of the invention
[0003] The purpose of the embodiment of the present invention is to provide a table generation method and device to improve the efficiency of table generation. The specific technical solution is as follows:
[0004] In a first aspect, an embodiment of the present invention provides a table generation method, the method comprising:
[0005] Obtaining the dimension identifiers included in each target dimension and the indicator identifier of each target indicator;
[0006] Combining the dimension identifier and each indicator identifier included in each target dimension to obtain a target combination including the dimension identifier and the indicator identifier;
[0007] Obtain data corresponding to each target combination from a preset database;
[0008] Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, determine a first cell corresponding to each first target identifier and a second cell corresponding to the data corresponding to each target combination, wherein the first target identifier is: a dimension identifier or an indicator identifier;
[0009] The corresponding first target identifier is recorded in the first cell, and the corresponding data is recorded in the second cell, and the table including the cells recording the first target identifier and the data is determined as the finally generated table.
[0010] In one embodiment of the present invention, the dimension identifier and each indicator identifier included in each target dimension are combined to obtain a target combination including the dimension identifier and the indicator identifier, including:
[0011] Combining the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension;
[0012] Combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier;
[0013] The obtained second combination is determined as the target combination.
[0014] In one embodiment of the present invention, after combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier, the method further includes:
[0015] Combining each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including a dimension identifier and a data summary identifier;
[0016] The step of determining the obtained second combination as the target combination comprises:
[0017] The obtained second combination and third combination are determined as target combinations.
[0018] In one embodiment of the present invention, the step of obtaining data corresponding to each target combination from a preset database includes:
[0019] For each second combination, obtaining a first value corresponding to the second combination from a preset database as first data corresponding to the second combination;
[0020] For each third combination, obtaining from the database a second value of the target dimension under the target indicator identified by the indicator in the third combination, and calculating a sum of the second values as the second data corresponding to the third combination;
[0021] The determining, based on the number of target dimensions, the number of dimension identifiers included in each target dimension, and the number of target indicators, a first cell corresponding to each target identifier and a second cell corresponding to data corresponding to each target combination includes:
[0022] Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators, and the number of data summary identifiers, determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination, wherein the second target identifier is one of the following three identifiers: a dimension identifier, an indicator identifier, and a data summary identifier;
[0023] The first target identifier corresponding to the first cell is recorded, including:
[0024] The corresponding second target identifier is recorded in the third cell.
[0025] In one embodiment of the present invention, the target dimension includes: a dimension having a hierarchical relationship.
[0026] In one embodiment of the present invention, the method further comprises:
[0027] In response to a request to generate a fine-grained dimension table, determining whether a dimension identifier included in a target dimension having a hierarchical relationship in a generated table has a dimension identifier of a next level;
[0028] If yes, obtain the dimension identifier of the next level dimension, update the obtained dimension identifier to the dimension identifier included in the target dimension, and return to the step of combining the dimension identifier and each indicator identifier included in each target dimension to obtain the target combination including the dimension identifier and the indicator identifier, and generate a fine-grained dimension table.
[0029] In a second aspect, an embodiment of the present invention provides a table generating device, the device comprising:
[0030] An identification acquisition module, used to obtain the identification of each dimension included in each target dimension and the indicator identification of each target indicator;
[0031] A combination determination module, used to combine the dimension identifier and each indicator identifier included in each target dimension to obtain a target combination including the dimension identifier and the indicator identifier;
[0032] A data acquisition module, used to acquire data corresponding to each target combination from a preset database;
[0033] A cell determination module, used to determine a first cell corresponding to each first target identifier and a second cell corresponding to data corresponding to each target combination based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, wherein the first target identifier is: a dimension identifier or an indicator identifier;
[0034] The table generation module is used to record the corresponding first target identifier in a first cell and the corresponding data in a second cell, and determine the table containing the cells recording the first target identifier and the data as the finally generated table.
[0035] In one embodiment of the present invention, the combination determination module includes:
[0036] A first combination determination submodule, used to combine the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension;
[0037] A second combination determination submodule, used for combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier;
[0038] The third combination determination submodule is used to determine the obtained second combination as a target combination.
[0039] In one embodiment of the present invention, the combination determination module includes:
[0040] a fourth combination determination submodule, configured to combine each first combination with each indicator identifier in the second combination determination submodule to obtain a second combination including the first combination and the indicator identifier, and then combine each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including the dimension identifier and the data summary identifier;
[0041] The third combination determination submodule is specifically used to determine the obtained second combination and third combination as the target combination.
[0042] In one embodiment of the present invention, the data acquisition module includes:
[0043] A first data acquisition submodule is used to acquire, for each second combination, a first value corresponding to the second combination from a preset database as first data corresponding to the second combination;
[0044] A second data acquisition submodule is used to acquire, for each third combination, from the database a second value of the target dimension under the target indicator identified by the indicator in the third combination, and calculate a sum of the second values as the second data corresponding to the third combination;
[0045] The cell determination module is specifically used to determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators and the number of data summary identifiers, wherein the second target identifier is one of the following three identifiers: a dimension identifier, an indicator identifier, and a data summary identifier;
[0046] The table generation module is specifically used to record the corresponding second target identifier in the third cell.
[0047] In one embodiment of the present invention, the target dimension includes: a dimension having a hierarchical relationship.
[0048] In one embodiment of the present invention, the above device further includes:
[0049] An information judgment module, for responding to a request for generating a fine-grained dimension table, judging whether the dimension identifier contained in the target dimension with a hierarchical relationship in the generated table has a dimension identifier of a next level; if yes, triggering an identifier update module;
[0050] The identification updating module is used to obtain the dimension identification of the next level dimension, update the obtained dimension identification to the dimension identification included in the target dimension, and trigger the combination determination module to generate a fine-grained dimension table.
[0051] In a third aspect, an embodiment of the present invention provides an electronic device, including a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;
[0052] Memory, used to store computer programs;
[0053] The processor is used to implement the method steps described in the first aspect when executing the program stored in the memory.
[0054] In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method steps described in the second aspect are implemented.
[0055] It can be seen from the above that when the solution provided by the embodiment of the present invention is applied to generate a table, the client combines the dimension identifiers and the indicator identifiers to obtain a target combination, obtains the data corresponding to each target combination, and determines the cell for recording each dimension identifier or indicator identifier, as well as the cell for recording the data corresponding to each target combination, and records the corresponding content in the determined cells. Compared with the prior art, there is no need for staff to manually generate tables, which significantly improves the efficiency of table generation.
[0056] Of course, it is not necessary to achieve all of the advantages described above at the same time to implement any product or method of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS
[0057] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other embodiments can also be obtained based on these drawings.
[0058] Figure 1a A schematic diagram of a flow chart of a first table generation method provided in an embodiment of the present invention;
[0059] Figure 1b A regional dimension diagram provided for an embodiment of the present invention;
[0060] Figure 1c A first table schematic diagram provided for an embodiment of the present invention;
[0061] Figure 1d A second table schematic diagram provided for an embodiment of the present invention;
[0062] Figure 1e A third table schematic diagram provided for an embodiment of the present invention;
[0063] Figure 2 A schematic diagram of a flow chart of a second table generation method provided in an embodiment of the present invention;
[0064] Figure 3a A schematic diagram of a lazy loading method provided by an embodiment of the present invention;
[0065] Figure 3b A fourth table schematic diagram provided for an embodiment of the present invention;
[0066] Figure 3c A fifth table schematic diagram provided for an embodiment of the present invention;
[0067] Figure 4 A schematic diagram of the structure of a table generating device provided by an embodiment of the present invention;
[0068] Figure 5 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0069] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field based on this application belong to the scope of protection of the present invention.
[0070] Traditional multidimensional analysis technologies generally include Excel (spreadsheet) perspectives, Cognos (metadata model) and other products. Excel perspectives can only analyze inherent data and the amount of data they can carry is very limited; Cognos only supports IE (Internet Explorer, web pages) browsers and relational databases, has poor compatibility, can only be deployed on a single machine, has weak scalability, poor concurrency performance, slow query speed, and low security, and can no longer meet the daily analysis needs of enterprises.
[0071] As business develops and market competition changes, the business side has higher and higher requirements for multi-dimensional data analysis services:
[0072] 1. The analysis granularity is getting smaller and smaller, and the number of indicators is increasing, resulting in an increasing amount of data after the dimensions are combined. The results of an analysis model can reach billions or even tens of billions.
[0073] 2. The organizational levels of business units of enterprises are getting deeper and deeper, and it is necessary to meet the personalized analysis needs of different levels, requiring the ability to drill down and analyze in batches;
[0074] 3. Each business side has different focuses, and the same analysis model needs to meet different analysis angles, such as customizing personalized subsets for dimensions and supporting custom calculation formulas for indicators.
[0075] 4. In addition to traditional tables, the presentation format must also meet the requirements of graphical, card-based, and template-based analysis capabilities.
[0076] The table generation method provided by the embodiment of the present invention is described below.
[0077] See also Figure 1a , Figure 1a This is a flow chart of a first table generation method provided by an embodiment of the present invention. The method includes the following steps S101-S105.
[0078] Before describing the above steps, first, the execution subject of the embodiment of the present invention is described. The execution subject of the embodiment of the present invention is a client.
[0079] Steps S101 to S105 are described below.
[0080] Step S101: Obtain the dimension identifiers included in each target dimension and the indicator identifier of each target indicator.
[0081] Dimensions represent the type of data obtained by classifying data from a specific data classification perspective. For example, data can be classified from a regional perspective to obtain a regional dimension, and data can be classified from a gender perspective to obtain a gender dimension.
[0082] The dimension identifier included in the dimension represents the type value of different types of data under each dimension. For example, for the region and province dimension, the dimension identifier included in the region dimension can be a province identifier.
[0083] An indicator represents the type of data obtained by statistically analyzing data from a specific statistical perspective. For example, the number of births in the population data can be statistically analyzed to obtain the number of births, and the number of deaths in the population data can be statistically analyzed to obtain the number of deaths.
[0084] The indicator identifier represents the identifier of the indicator. For example, the indicator identifier of the population birth number indicator can be "population birth number", and the indicator identifier of the population death number indicator can be "population death number".
[0085] Take the population table shown in Table 1 as an example.
[0086] Table 1
[0087]
[0088] In Table 1, the dimension is province, and "Province A" and "Province B" are the dimension identifiers included in the province dimension; the indicators include the number of births and the number of deaths, and the indicator identifier of the birth number indicator is "number of births", and the indicator identifier of the death number indicator is "number of deaths".
[0089] In Table 1, "1000" represents the population of Province A, and "2000" represents the population of Province B. It can be seen that dimensions and indicators can comprehensively represent the meaning of data.
[0090] In one embodiment of the present invention, the above-mentioned target dimensions may include: dimensions having a hierarchical relationship.
[0091] A dimension with a hierarchical relationship means that the dimension identifiers contained in the dimension have a hierarchical relationship. For example, taking the region dimension as an example, the region dimension is a dimension with a hierarchical relationship. Figure 1b Take the regional dimension diagram shown as an example. Figure 1b The identifier corresponding to each node in the regional dimension diagram shown in is: the identifiers of the dimensions included in the regional dimension;
[0092] exist Figure 1b In the figure, the first-level dimension identifier from top to bottom is: Province A; the dimension identifier of the next level below the dimension identifier of Province A is the dimension identifier of the second level: City B1, City B2 and City B3; the dimension identifier of the next level below the dimension identifiers of City B1, City B2 and City B3 is the dimension identifier of the third level; among them, the dimension identifier of the next level below the dimension identifier of City B1 is: County C1 and County C2; the dimension identifier of the next level below the dimension identifier of City B2 is: County C3 and County C4; the dimension identifier of the next level below the dimension identifier of City B3 is: County C5 and County C6.
[0093] In one implementation, the user may select the dimension identifiers included in the desired target dimensions and the indicator identifiers of the target indicators in the user interface provided by the client, and the client may thereby obtain the above-mentioned dimension identifiers and indicator identifiers.
[0094] Of course, when it is detected that the user has not made a selection, the dimension identifiers included in the preset dimension can also be determined as the dimension identifiers included in the target dimension, and the indicator identifier of the preset indicator can be determined as the indicator identifier of the target indicator.
[0095] After obtaining the dimension identifier contained in the target dimension, the client can determine whether the selected target dimension exists among the hierarchically related dimensions stored locally. If so, it means that the dimension identifier contained in the obtained target dimension has a hierarchical relationship, and a tree link containing the dimension identifiers can be generated according to the hierarchical relationship.
[0096] Step S102: Combine the dimension identifier and each indicator identifier included in each target dimension to obtain a target combination including the dimension identifier and the indicator identifier.
[0097] The above combination process is illustrated by an example: suppose that the target dimension includes: city-level regional dimension and gender dimension. The city-level regional dimension is a dimension with a hierarchical relationship. The dimension identifiers included in the city-level regional dimension are: B1 city, B2 city, B3 city, and the dimension identifiers included in the gender dimension are: male and female. The indicator identifiers of each target indicator are: number of births and number of deaths. When the dimension identifiers and each indicator identifier included in each target dimension are combined, the target combinations obtained are shown in Table 2 below.
[0098] Table 2
[0099] B1 City female Number of births B1 City male Number of births B1 City female Number of deaths B1 City male Number of deaths B2 City female Number of births B2 City male Number of births B2 City female Number of deaths B2 City male Number of deaths B3 city female Number of births B3 city male Number of births B3 city female Number of deaths B3 city male Number of deaths
[0100] The specific implementation method of obtaining the target combination can be found in the following Figure 2 The illustrated embodiment will not be described in detail here.
[0101] In one embodiment of the present invention, after the target combination is determined, the target combination may be preprocessed, for example, target combinations containing empty identifiers and repeated target combinations may be filtered out. The preprocessed target combination is determined as the target combination in the following step S103.
[0102] Step S103: Acquire data corresponding to each target combination from a preset database.
[0103] The data corresponding to the target combination represents the data under the dimension identifier and indicator identifier included in the target combination. Taking the above Table 2 as an example, when the target combination is: "B1 City-Female-Number of Births", the data corresponding to the target combination is: the data on the number of births of females in B1 City; when the target combination is: "B2 City-Male-Number of Deaths", the data corresponding to the target combination is: the data on the number of deaths of males in B2 City.
[0104] Specifically, when the operating system of the electronic device run by the client is the Kylin operating system, a corresponding KylinSQL (Structured Query Language) query script can be generated to read the data corresponding to each target combination from the database.
[0105] In one implementation, each target combination may be converted into a combination consisting of indexes based on a correspondence between preset identifiers and indexes, and data corresponding to the converted combination may be read from a preset database.
[0106] Since the data stored in the database is stored in a corresponding relationship between indexes and data, it is necessary to convert the target combination into a combination composed of indexes so that the corresponding data can be obtained from the database.
[0107] For example: based on the correspondence between the preset identifier and the index, the target combination "B1 city-female-number of births" is converted, where the index corresponding to "B1 city" is X, the index corresponding to "female" is "1", and the index corresponding to "number of births" is "5-2". Therefore, the converted combination of the above target combination is: "X-1-5-2".
[0108] Step S104: Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, determine the first cell corresponding to each first target identifier and the second cell corresponding to the data corresponding to each target combination.
[0109] The above-mentioned first target identifier is: a dimension identifier or an indicator identifier.
[0110] In one implementation, when determining the above-mentioned first cell, the product of the number of target dimensions and the number of dimension identifiers contained in each target dimension can be calculated to obtain the first target number, and the first target number of header cells can be determined from the vertical header cells contained in the initial table as the first cells for recording the dimension identifiers; and the target indicator number of header cells can be determined from the horizontal header cells contained in the initial table as the first cells for recording the indicator identifiers.
[0111] Taking the embodiment shown in Table 2 as an example, the number of target dimensions is 2, among which the number of dimension identifiers included in the region dimension is 3, and the number of dimension identifiers included in the gender dimension is 2. Therefore, the number of targets is: 2*3=6; the number of target indicators is 2. Figure 1c In the table diagram shown, the cells in the first row are horizontal header cells, and the cells in the first column and the second column are vertical header cells.
[0112] exist Figure 1c In the horizontal table header cells shown, the cell marked as A is determined as the first cell for recording the indicator mark of "number of births"; the cell marked as B is determined as the first cell for recording the indicator mark of "number of deaths";
[0113] exist Figure 1c In the vertical header cells shown, the first 6 cells in the first column are determined as the first cells for recording the dimension identifier contained in the regional dimension, among which the cells identified as 11 and 12 are used as cells for recording the dimension identifier of "B1 city", the cells identified as 13 and 14 are used as cells for recording the dimension identifier of "B2 city", and the cells identified as 15 and 16 are used as cells for recording the dimension identifier of "B3 city".
[0114] exist Figure 1c In the vertical header cells shown, the first 6 cells in the second column are determined as the first cells for recording the dimension identifier contained in the gender dimension; among them, the cells identified as 21, 23 and 25 are used as cells for recording the dimension identifier of "female", and the cells identified as 22, 24 and 26 are used as cells for recording the dimension identifier of "male".
[0115] After determining the first cell corresponding to each first target identifier, for each target combination, the horizontal direction along which the first cell corresponding to the dimension identifier included in the target combination is located, and the vertical direction along which the first cell corresponding to the indicator identifier included in the target combination is located can be determined, and the cell at the intersection of the horizontal direction and the vertical direction can be determined as the second cell for recording the data corresponding to the target combination.
[0116] Take the target combination of "B1 City - Female - Number of Births" as an example. The dimension identifiers of this target combination include "B1 City" and "Female", and the indicator identifier is "Number of Births". Figure 1c As shown, the arrow marked 1 represents the horizontal direction along the cells where "B1 City" and "Female" are located, and the arrow marked 2 represents the vertical direction along the cell where "Number of Births" is located. The cell where the intersection of the above horizontal direction and vertical direction is located is the second cell for recording the corresponding data of the target combination.
[0117] Step S105: Record the corresponding first target identifier in the first cell, and record the corresponding data in the second cell, and determine the table containing the cells recording the first target identifier and the data as the finally generated table.
[0118] Using the embodiment mentioned in the above step S104, the generated table is as follows: Figure 1d As shown, Figure 1d The table shown is in the Figure 1c Based on the table shown, the first cell records the corresponding first target identifier, and the second cell records the corresponding data.
[0119] It can be seen from the above that when the solution provided by this embodiment is applied to generate a table, the client combines the dimension identifiers and indicator identifiers to obtain a target combination, obtains the data corresponding to each target combination, and determines the cell for recording each dimension identifier or indicator identifier, as well as the cell for recording the data corresponding to each target combination, and records the corresponding content in the determined cells. Compared with the prior art, there is no need for staff to manually generate tables, which significantly improves the efficiency of table generation.
[0120] Furthermore, since the table is generated based on the obtained dimension identifiers and indicator identifiers, when the dimension identifiers and indicator identifiers change, the data contained in the generated table will also change accordingly, thereby making the data in the generated table flexible and changeable, and able to meet the corresponding requirements of the obtained dimension identifiers and indicator identifiers.
[0121] The aforementioned Figure 1a In step S102 of the embodiment shown, it is possible to use Figure 2 The target combination determination method mentioned in the embodiment shown in the figure obtains the above target combination. In one embodiment of the present invention, see Figure 2 , Figure 2 A schematic diagram of a flow chart of a second table generation method provided in an embodiment of the present invention, wherein the Figure 1a Step S102 shown in FIG. Figure 2 In the illustrated embodiment, steps S202 - S204 are implemented.
[0122] Specifically, Figure 2 The illustrated embodiment includes the following steps S201 - S207 .
[0123] Step S201: Obtain the dimension identifiers included in each target dimension and the indicator identifier of each target indicator.
[0124] Specifically, the above step S201 is the same as the above step S202. Figure 1a Step S101 in the illustrated embodiment is the same and will not be described in detail here.
[0125] Step S202: Combining the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension.
[0126] Use the above Figure 1aThe example listed in step S102 of the illustrated embodiment. The target dimensions include: a geographical dimension and a gender dimension. The dimension identifiers included in the geographical dimension are: B1 city, B2 city, B3 city, respectively. The dimension identifiers included in the gender dimension are: male, female, respectively. The dimension identifiers included in each target dimension are combined, and the first combination obtained is shown in Table 3 below.
[0127] Table 3
[0128] B1 City female B1 City male B2 City female B2 City male B3 city female B3 city male
[0129] Step S203: Combine each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier.
[0130] Continue to use the above Figure 1a The example listed in step S102 of the illustrated embodiment. The indicator identifier of the target indicator includes: the number of births and the number of deaths. Each first combination is combined with each indicator identifier, and the second combination obtained is shown in the above Table 2.
[0131] Step S204: determine the obtained second combination as the target combination.
[0132] Step S205: Acquire data corresponding to each target combination from a preset database.
[0133] Step S206: Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, determine the first cell corresponding to each first target identifier and the second cell corresponding to the data corresponding to each target combination.
[0134] The above-mentioned first target identifier is: a dimension identifier or an indicator identifier.
[0135] Step S207: Record the corresponding first target identifier in the first cell, and record the corresponding data in the second cell, and determine the table containing the cells recording the first target identifier and the data as the finally generated table.
[0136] Specifically, the above steps S205-S207 are respectively Figure 1a In the illustrated embodiment, steps S103 - S105 are the same and will not be described in detail herein.
[0137] From the above, it can be seen that since the dimension identifiers included in each target dimension are first combined, and then the first combination is combined with each indicator identifier, and the combinations are performed in sequence according to the above two steps, the occurrence of erroneous combinations can be reduced, thereby improving the accuracy of the obtained target combination.
[0138] In one embodiment of the present invention, after the above step S203, the following step A1 may be further included.
[0139] Step A1: Combine each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including a dimension identifier and a data summary identifier.
[0140] The above-mentioned data summary identifier may represent the identifier of the summary value of the data of the target dimension under the corresponding indicator identifier.
[0141] For example; using the above Figure 1a In the example listed in step S102 of the illustrated embodiment, the indicator identifiers include: the number of births and the number of deaths. For the indicator identifier of the number of births, taking the target dimension as the regional dimension as an example, the data summary identifier corresponding to the indicator identifier can be represented as: the identifier of the summary value of the data of B1 city, B2 city and B3 city under the "number of births" indicator. Taking the target dimension as the gender dimension as an example, the data summary identifier corresponding to the indicator identifier can also be represented as: the summary value of the number of births of females and males in B1 city.
[0142] Since each indicator identifier has a corresponding data summary identifier, each indicator identifier is combined with the corresponding data summary identifier to obtain a third combination including the indicator identifier and the data summary identifier.
[0143] Based on the above step A1, the above step S204 can be implemented according to the following step A2.
[0144] Step A2: Determine the obtained second combination and third combination as target combinations.
[0145] Since the third combination includes the indicator identifier and the data summary identifier, the second combination and the third combination are determined as the target combination, so that the determined target combination includes not only the combination of the dimension identifier and the indicator identifier, but also the combination of the indicator identifier and the data summary identifier, thereby enriching the content of the target combination.
[0146] Based on the above steps A1-A2, the aforementioned Figure 1a Step S103 of the illustrated embodiment may be implemented according to the following steps B1-B2.
[0147] Step B1: for each second combination, obtaining a first value corresponding to the second combination from a preset database as first data corresponding to the second combination.
[0148] The specific implementation of the above step B1 can refer to the above Figure 1a The implementation method of step S103 of the illustrated embodiment will not be described in detail here.
[0149] Step B2: For each third combination, obtain from the database the second value of the target dimension under the target indicator identified by the indicator in the third combination, and calculate the sum of the second values as the second data corresponding to the third combination.
[0150] The second data corresponding to the third combination represents: the summary value of the data of the target dimension under the target indicator identified by the indicator included in the third combination.
[0151] In one embodiment, when obtaining the above-mentioned second value, the indicator identifier in each third combination can be converted into a corresponding index based on the correspondence between the preset identifier and the index, and the second value of the target dimension under the target indicator of the indicator identifier in the converted third combination can be read from a preset database.
[0152] For example: based on the correspondence between the preset identifier and the index, the "number of births" in the third combination "number of births-summary value of number of births" is converted, where the index corresponding to the "number of births" is A. Therefore, the indicator identifier in the above third combination is converted to "A", and the second value of the target dimension under the target indicator identified as "A" is read from the preset database.
[0153] As can be seen from the above, the third combination includes a data summary identifier, and the value of the target dimension under the target indicator of the indicator identifier included in the third combination is obtained from a preset database, and the values are added to obtain the accurate data summary value of the target dimension under the same target indicator.
[0154] Based on the above steps B1-B2, the above Figure 1a Step S104 of the illustrated embodiment may be implemented according to the following step C1.
[0155] Step C1: Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators and the number of data summary identifiers, determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination.
[0156] The above-mentioned second target identifier is one of the following three identifiers: dimension identifier, indicator identifier, and data summary identifier.
[0157] In one implementation, when determining the above-mentioned third cell, the product between the number of target dimensions and the number of dimension identifiers contained in each target dimension can be calculated to obtain a first target number, and the first target number of header cells can be determined from the vertical header cells contained in the initial table, respectively serving as the third cells for recording the dimension identifiers.
[0158] After determining the third cell for recording the dimension identifier, the adjacent cell in a preset direction of the third cell for recording the dimension identifier included in each target dimension can be determined as the third cell for recording the data summary identifier.
[0159] The number of header cells of the target indicator is determined from the horizontal header cells contained in the initial table as the third cell for recording the indicator identifier.
[0160] by Figure 1e For example, Figure 1e The table shown includes a third cell for recording each third target identifier.
[0161] Figure 1e is Figure 1d On this basis, the lower adjacent cell of the cell used to record "B3 City" is used as the cell for recording the data summary mark "Total", and the lower adjacent cell of the cell used to record each "Male" is used as the cell for recording the data summary mark "Total". Among them, for the bottom cell recording "Total", the first header cell adjacent to the right of the cell is used as the cell for recording "Female", the second header cell adjacent to the right of the cell is used as the cell for recording "Male"; and the third header cell adjacent to the right of the cell is used as the cell for recording "Total".
[0162] For determining the second cell corresponding to the data corresponding to the third combination, for each third combination, a third direction along the third cell used to record the data summary identifier in the third combination and a fourth direction along the third cell used to record the indicator identifier in the third combination can be determined, and the cell at the point where the third direction intersects the fourth direction can be used as the second cell for recording the data corresponding to the third combination.
[0163] Based on the above step C1, the above Figure 1a In the illustrated embodiment, the first target identifier corresponding to the first cell in step S105 may be recorded according to the following step D1.
[0164] Step D1: Record the corresponding second target identifier in the third cell.
[0165] If the target dimension includes a hierarchical dimension, Figure 1a In step S105 of the illustrated embodiment, only a table containing the obtained dimension identifiers is generated, and a table is not generated for all dimension identifiers included in the target dimension. When the user needs to obtain a table corresponding to the dimension identifier of the next level for the currently recorded dimension identifier, in one embodiment of the present invention, in the aforementioned Figure 1aAfter step S105 of the illustrated embodiment, it is also possible to respond to a request to generate a fine-grained dimension table and determine whether the dimension identifier contained in the target dimension with a hierarchical relationship in the generated table has the dimension identifier of the next level. If so, obtain the dimension identifier of the next level, update the obtained dimension identifier to the dimension identifier included in the target dimension, and return to step S102 to generate a fine-grained dimension table.
[0166] The above-mentioned fine-grained dimension table generation request is used to request the generation of a fine-grained dimension table. When the user is viewing the generated table, the user may also need to obtain the data corresponding to the dimension identifier of the next level of the dimension identifier contained in the target dimension with a hierarchical relationship in the table. In this case, the user can perform a preset operation for viewing the fine-grained dimension table on the user interface. If the client detects the above-mentioned operation, it means that the fine-grained dimension table generation request has been obtained.
[0167] In one implementation, it is possible to determine whether the dimension identifier included in the target dimension with a hierarchical relationship has a dimension identifier of a next level from the dimension identifiers of each level included in the locally stored hierarchical dimensions.
[0168] For example, the dimension identifiers of each level contained in the locally stored regional dimension are Figure 1b The dimension identifiers shown in the table are as follows. The lowest dimension identifiers of the regional dimension in the generated table are B1 city, B2 city, and B3 city. Figure 1b It can be seen that B1 City, B2 City, and B3 City all have dimension identifiers of the next level. The dimension identifiers of the next level of "B1 City" are "C1 County" and "C2 County", the dimension identifiers of the next level of "B2 City" are "C3 County" and "C4 County", and the dimension identifiers of the next level of "B3 City" are "C5 County" and "C6 County".
[0169] When there is no dimension identifier of the next level, a message indicating that there is no dimension of the next level may be displayed in the user interface provided by the client.
[0170] When there is a dimension identifier of the next level, the dimension identifier of the next level can be obtained and updated to the dimension identifier included in the target dimension, and the process returns to step S102 to generate a fine-grained table.
[0171] When there is a dimension identifier for the next level, return to the above step S102 to generate a fine-grained table. The technology used in this process can be called lazy loading technology. Only the data visible in the current user interface is calculated and displayed using the calculation logic, and the non-visual data only saves the calculation logic relationship. When the non-visual data becomes a visible data range again, it is calculated and displayed using the calculation logic. Because the overall multidimensional analysis model often has a large number of dimensions and indicators, the resulting mapping relationship grows exponentially, and the data sets of all calculation dimensions are very large. If the full amount is calculated, it will inevitably consume a lot of resources, and the system performance will be seriously dragged down. Therefore, the use of lazy loading technology can reduce resource consumption and improve system performance.
[0172] by Figure 3a The flowchart shown illustrates the above lazy loading process. Figure 3a The process includes steps S301-S306.
[0173] Step S301: The user clicks a “drill down” button in the user interface.
[0174] The client detects that the user clicks the drill-down button, indicating that a fine-grained table generation request has been received.
[0175] Step S302: Determine whether the dimension identifier of the next level is included. If yes, execute step S303, if no, end the process.
[0176] Step S303: Calculate the hierarchical dimension and the number of layers.
[0177] Specifically, the level and number of levels corresponding to the dimension identifier contained in the target dimension recorded in the currently generated table are obtained, so as to prepare for obtaining data after batch drilling and automatically piecing together cells to expand the level column.
[0178] Step S304: Obtain the dimension identifier of the next level.
[0179] Specifically, the dimension identifier of the next level can be obtained from the stored dimension identifier hierarchical relationship.
[0180] Step S305: Maintain the hierarchical relationship between the dimension identifiers of each level.
[0181] Specifically, the hierarchical relationship between the dimension identifiers of each level may be updated regularly to implement the dimension of the hierarchical relationship.
[0182] Step S306: Generate a table based on the obtained dimension identifier of the next level and the indicator identifier of the target indicator.
[0183] by Figure 3b-3c As an example, in the user interface shown Figure 3bIn the example above, the user can right-click in the data area corresponding to the data recorded in "City B1" and a "Drill Down" button will appear. Figure 3b The client generates a table corresponding to the dimension identifier of the next level for recording the city B1 according to the above steps S301-S306 based on the above operation performed by the user, such as Figure 3c shown.
[0184] Corresponding to the above table generating method, an embodiment of the present invention further provides a table generating device.
[0185] See also Figure 4 , Figure 4 A schematic diagram of the structure of a table generating device provided in an embodiment of the present invention, the device includes the following modules 401-405.
[0186] The identifier obtaining module 401 is used to obtain the identifiers of each dimension included in each target dimension and the indicator identifier of each target indicator;
[0187] A combination determination module 402 is used to combine the dimension identifier and each indicator identifier included in each target dimension to obtain a target combination including the dimension identifier and the indicator identifier;
[0188] The data acquisition module 403 is used to acquire data corresponding to each target combination from a preset database;
[0189] The cell determination module 404 is used to determine the first cell corresponding to each first target identifier and the second cell corresponding to the data corresponding to each target combination based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, wherein the first target identifier is: a dimension identifier or an indicator identifier;
[0190] The table generation module 405 is used to record the corresponding first target identifier in the first cell and the corresponding data in the second cell, and determine the table containing the first target identifier and the data as the final generated table.
[0191] It can be seen from the above that when the solution provided by this embodiment is applied to generate a table, the client combines the dimension identifiers and indicator identifiers to obtain a target combination, obtains the data corresponding to each target combination, and determines the cell for recording each dimension identifier or indicator identifier, as well as the cell for recording the data corresponding to each target combination, and records the corresponding content in the determined cells. Compared with the prior art, there is no need for staff to manually generate tables, which significantly improves the efficiency of table generation.
[0192] In one embodiment of the present invention, the combination determination module 402 includes:
[0193] A first combination determination submodule, used to combine the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension;
[0194] A second combination determination submodule, used for combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier;
[0195] The third combination determination submodule is used to determine the obtained second combination as a target combination.
[0196] From the above, it can be seen that since the dimension identifiers included in each target dimension are first combined, and then the first combination is combined with each indicator identifier, and the combinations are performed in sequence according to the above two steps, the occurrence of erroneous combinations can be reduced, thereby improving the accuracy of the obtained target combination.
[0197] In one embodiment of the present invention, the combination determination module 402 includes:
[0198] a fourth combination determination submodule, configured to combine each first combination with each indicator identifier in the second combination determination submodule to obtain a second combination including the first combination and the indicator identifier, and then combine each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including the dimension identifier and the data summary identifier;
[0199] The third combination determination submodule is specifically used to determine the obtained second combination and third combination as the target combination.
[0200] Since the third combination includes a dimension identifier and a data summary identifier, the second combination and the third combination are determined as target combinations, so that the determined target combination includes not only a combination of a dimension identifier and an indicator identifier, but also a combination of a dimension identifier and a data summary identifier, thereby enriching the content of the target combination.
[0201] In one embodiment of the present invention, the data acquisition module 403 includes:
[0202] A first data acquisition submodule is used to acquire, for each second combination, a first value corresponding to the second combination from a preset database as first data corresponding to the second combination;
[0203] A second data acquisition submodule is used to acquire, for each third combination, from the database a second value of the target dimension under the target indicator identified by the indicator in the third combination, and calculate a sum of the second values as the second data corresponding to the third combination;
[0204] The cell determination module 404 is specifically used to determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators and the number of data summary identifiers, wherein the second target identifier is one of the following three identifiers: a dimension identifier, an indicator identifier and a data summary identifier;
[0205] The table generation module 405 is specifically configured to record the corresponding second target identifier in the third cell.
[0206] As can be seen from the above, the third combination includes a data summary identifier. The values of the dimension identifiers contained in the third combination under each target indicator are obtained from a preset database, and the values are added to obtain accurate data summary values of the target dimensions under each target indicator.
[0207] In one embodiment of the present invention, the target dimension includes: a dimension having a hierarchical relationship.
[0208] In one embodiment of the present invention, the above device further includes:
[0209] An information judgment module, for responding to a request for generating a fine-grained dimension table, judging whether the dimension identifier contained in the target dimension with a hierarchical relationship in the generated table has a dimension identifier of a next level; if yes, triggering an identifier update module;
[0210] The identification updating module is used to obtain the dimension identification of the next level dimension, update the obtained dimension identification to the dimension identification included in the target dimension, and trigger the combination determination module to generate a fine-grained dimension table.
[0211] The embodiment of the present invention further provides an electronic device, such as Figure 5 As shown, it includes a processor 501, a communication interface 502, a memory 503 and a communication bus 504, wherein the processor 501, the communication interface 502, and the memory 503 communicate with each other through the communication bus 504.
[0212] Memory 503, used for storing computer programs;
[0213] The processor 501 is used to implement the above table generation method when executing the program stored in the memory 503.
[0214] The communication bus mentioned in the above electronic device can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.
[0215] The communication interface is used for communication between the above electronic device and other devices.
[0216] The memory may include a random access memory (RAM) or a non-volatile memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.
[0217] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.
[0218] In another embodiment of the present invention, a computer-readable storage medium is provided, in which a computer program is stored. When the computer program is executed by a processor, the steps of the above table generating method are implemented.
[0219] In another embodiment of the present invention, a computer program product including instructions is provided, which enables the computer to execute the above table generating method when the computer program product is executed on the computer.
[0220] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented by software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present invention is generated in whole or in part. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions can be transmitted from a website site, computer, server or data center to another website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that a computer can access or a data storage device such as a server or data center that includes one or more available media integrated. The available medium can be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state hard disk Solid State Disk (SSD)), etc.
[0221] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.
[0222] Each embodiment in this specification is described in a related manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for devices, electronic devices, computer-readable storage media, and computer program product embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.
[0223] The above description is only a preferred embodiment of the present invention and is not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention are included in the protection scope of the present invention.
Claims
1. A table generation method, characterized in that: The method comprises: Obtaining the dimension identifiers included in each target dimension and the indicator identifier of each target indicator; The dimension identifier and each indicator identifier included in each target dimension are combined to obtain a target combination including the dimension identifier and the indicator identifier, including: Combining the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension; Combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier; determining the obtained second combination as the target combination; Combining each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including a dimension identifier and a data summary identifier; The step of determining the obtained second combination as the target combination comprises: The obtained second combination and third combination are determined as target combinations; and data corresponding to each target combination is obtained from a preset database, including: For each second combination, obtaining a first value corresponding to the second combination from a preset database as first data corresponding to the second combination; For each third combination, obtaining from the database a second value of the target dimension under the target indicator identified by the indicator in the third combination, and calculating a sum of the second values as the second data corresponding to the third combination; Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, determine a first cell corresponding to each first target identifier and a second cell corresponding to the data corresponding to each target combination, wherein the first target identifier is: a dimension identifier or an indicator identifier; The determining, based on the number of target dimensions, the number of dimension identifiers included in each target dimension, and the number of target indicators, a first cell corresponding to each target identifier and a second cell corresponding to data corresponding to each target combination includes: Based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators, and the number of data summary identifiers, determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination, wherein the second target identifier is one of the following three identifiers: a dimension identifier, an indicator identifier, and a data summary identifier; Recording the corresponding first target identifier in a first cell, and recording the corresponding data in a second cell, and determining the table including the cells recording the first target identifier and the data as the finally generated table; The first target identifier corresponding to the first cell is recorded, including: The corresponding second target identifier is recorded in the third cell.
2. The method according to claim 1, characterized in that The target dimensions include: Dimensions with hierarchical relationships.
3. The method according to claim 2, characterized in that The method further comprises: In response to a request to generate a fine-grained dimension table, determining whether a dimension identifier included in a target dimension having a hierarchical relationship in a generated table has a dimension identifier of a next level; If yes, obtain the dimension identifier of the next level dimension, update the obtained dimension identifier to the dimension identifier included in the target dimension, and return to the step of combining the dimension identifier and each indicator identifier included in each target dimension to obtain the target combination including the dimension identifier and the indicator identifier, and generate a fine-grained dimension table.
4. A table generating device, characterized in that: The device comprises: An identification acquisition module, used to obtain the identification of each dimension included in each target dimension and the indicator identification of each target indicator; A combination determination module is used to combine the dimension identifier and each indicator identifier included in each target dimension to obtain a target combination including the dimension identifier and the indicator identifier. The combination determination module comprises: A first combination determination submodule, used to combine the dimension identifiers included in each target dimension to obtain a first combination of dimension identifiers including the target dimension; A second combination determination submodule, used for combining each first combination with each indicator identifier to obtain a second combination including the first combination and the indicator identifier; The third combination determination submodule is used to determine the obtained second combination as the target combination a fourth combination determination submodule, configured to combine each first combination with each indicator identifier in the second combination determination submodule to obtain a second combination including the first combination and the indicator identifier, and then combine each indicator identifier and the data summary identifier corresponding to each indicator identifier to obtain a third combination including the dimension identifier and the data summary identifier; The third combination determination submodule is specifically used to determine the obtained second combination and third combination as the target combination; A data acquisition module, used to acquire data corresponding to each target combination from a preset database; The data acquisition module comprises: A first data acquisition submodule is used to acquire, for each second combination, a first value corresponding to the second combination from a preset database as first data corresponding to the second combination; A second data acquisition submodule is used to obtain, for each third combination, from the database a second value of the target dimension under the target indicator of the indicator identifier in the third combination, and calculate the sum of the second values as the second data corresponding to the third combination; a cell determination module is used to determine, based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, and the number of target indicators, a first cell corresponding to each first target identifier and a second cell corresponding to the data corresponding to each target combination, wherein the first target identifier is a dimension identifier or an indicator identifier; The cell determination module is specifically used to determine the third cell corresponding to each second target identifier and the second cell corresponding to the data corresponding to each target combination based on the number of target dimensions, the number of dimension identifiers contained in each target dimension, the number of target indicators and the number of data summary identifiers, wherein the second target identifier is one of the following three identifiers: a dimension identifier, an indicator identifier, and a data summary identifier; A table generation module, used for recording the corresponding first target identifier in a first cell, and recording the corresponding data in a second cell, and determining the table containing the cells recording the first target identifier and the data as the finally generated table; The table generation module is specifically used to record the corresponding second target identifier in the third cell.
5. The device according to claim 4, characterized in that The target dimensions include: Dimensions with hierarchical relationships.
6. The device according to claim 5, characterized in that The device also includes: An information determination module, configured to respond to a request for generating a fine-grained dimension table and determine whether a dimension identifier included in a target dimension with a hierarchical relationship in a generated table has a dimension identifier of a next level; If yes, trigger the identification update module; The identification updating module is used to obtain the dimension identification of the next level dimension, update the obtained dimension identification to the dimension identification included in the target dimension, and trigger the combination determination module to generate a fine-grained dimension table.
7. An electronic device, characterized in that: It includes a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other through the communication bus; Memory, used to store computer programs; A processor, for implementing the method steps described in any one of claims 1 to 3 when executing a program stored in a memory.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method steps described in any one of claims 1 to 3 are implemented.
Citation Information
Patent Citations
Service index obtaining method and device, server and computer readable storage medium
CN109800225A
Data verification method and device based on database migration, equipment and medium
CN113392090A
Creating a spreadsheet template for generating an end user spreadsheet with dynamic cell dimensions retrieved from a remote application
US10067928B1
