CN117851404A - Report generation method, device, medium and equipment based on self-configuration - Google Patents
Report generation method, device, medium and equipment based on self-configuration Download PDFInfo
- Publication number
- CN117851404A CN117851404A CN202311718565.9A CN202311718565A CN117851404A CN 117851404 A CN117851404 A CN 117851404A CN 202311718565 A CN202311718565 A CN 202311718565A CN 117851404 A CN117851404 A CN 117851404A
- Authority
- CN
- China
- Prior art keywords
- report
- dimension
- screening
- report generation
- fact table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000005259 measurement Methods 0.000 claims abstract description 32
- 230000001960 triggered effect Effects 0.000 claims abstract description 9
- 238000012216 screening Methods 0.000 claims description 89
- 238000001914 filtration Methods 0.000 claims description 55
- 238000004590 computer program Methods 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 abstract description 8
- 238000005516 engineering process Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 9
- 230000007246 mechanism Effects 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000004519 manufacturing process Methods 0.000 description 5
- 238000004364 calculation method Methods 0.000 description 4
- 238000011160 research Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 235000013410 fast food Nutrition 0.000 description 1
- 239000012634 fragment Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present disclosure relates to the field of data processing technologies, and in particular, to a report generating method, device, medium, and apparatus based on self-configuration. The method comprises the steps of obtaining a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report; generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and outputting dimension fields of the dimension indication report, wherein the measurement information is used for indicating a statistical mode corresponding to any dimension field. And generating measurement information under specific dimensions based on a report generation request comprising the user requirements, so that the report can accurately reflect the user requirements, and the report generation efficiency is improved.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a report generating method, device, medium, and apparatus based on self-configuration.
Background
For some financial institutions, due to the increase of business types, the demands for reports are increasing, and the report demands cannot be put into production rapidly under the conditions of limited number of developers, long on-line production process from demand acceptance and the like.
In the report system configuration method in the prior art, search source configuration information sent by a user is received, a search source is configured based on the received search source configuration information, display mode configuration information aiming at data in the search source and sent by the user is received, a data display mode is configured based on the display mode configuration information, a filter and a query condition pattern corresponding to the search source are determined, and a report system query interface is generated according to the display mode configuration information, the filter and the query condition pattern. The user participates in the whole process of generating the query interface of the report system, but the process of the report system needs too many users to participate in, has higher requirements on the professional ability of the users, and the users can acquire the correct report only by inputting the correct instruction. In addition, the user needs multiple steps of operations, and the user inputs corresponding data almost in each step, so that the requirements of data safety under the financial business scene are not met. Meanwhile, the report generation efficiency is reduced.
Based on the foregoing, there is a need for a report generating method, device, medium and equipment based on self-configuration, which are used for improving the efficiency of report generation.
Disclosure of Invention
The embodiment of the application provides a report generation method, device, medium and equipment based on self-configuration, which are used for improving the report generation efficiency.
In a first aspect, an embodiment of the present application provides a report generating method based on self-configuration, including:
acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report;
generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and the output dimension indicates dimension fields of the report, and the measurement information is used for indicating a statistical mode corresponding to any dimension field.
By the method, the report generation interface is generated based on the fact table and the dimension table in the report creation request, and the report generation interface is used for screening the report for the first time in practice, so that some self-configuration options are provided for the user, and the user can perform more simple configuration operation. The user can trigger a report generation request on the interface, the interface interacts with the user to acquire the requirement of the user on the report, and the measurement information under the specific dimension is generated based on the report generation request comprising the requirement of the user, so that the requirement of the user is accurately reflected by the report, and the report generation efficiency is improved.
In a possible implementation manner, a screening element is set in the report generation interface, and the screening element is obtained based on a screening rule for screening a fact table in the report creation request;
the report generation request also has screening conditions for indicating the report under the screening rules; the screening conditions are determined based on the values of the screening elements set by a user under the screening rules, and are used for acquiring data information meeting the screening conditions from the fact table.
In a possible implementation manner, the filtering rule is a filtering condition for setting fields in the fact table, or a filtering tree formed by a plurality of setting fields in the fact table.
In a possible implementation, the rule tree comprises a root node and a plurality of child nodes, the rule tree being determined by,
for any child node, determining a child screening condition according to the input value of the child node:
determining a splicing rule of a plurality of sub-screening conditions according to the logical symbols of the root node;
and splicing the sub-screening conditions based on the splicing rules to obtain the rule tree.
Through the method, after the screening conditions are determined, the data information meeting the screening conditions can be obtained from the real table, so that a report is obtained.
By means of the rule tree pre-configuration mode, an interface for inputting specific rules is provided for a user, the user can determine screening rules only by inputting specific values in the interface, and accordingly corresponding data information is obtained, and a report is generated. And the rule tree can be configured, screening elements of screening rules are set, types of nodes in the rule tree and calculation logic among the nodes are set, and therefore personalized configuration of the report is achieved.
In a possible implementation manner, a filtering rule is further set in the report generation interface, and the filtering rule is obtained based on each dimension information in the dimension table;
the report generation request also has a filter element determined from the filter rule; the filtering element is determined based on the value of the filtering element set by the user under the screening rule, and is used for acquiring the data information conforming to the filtering element from the fact table.
By the method, the filtering rule options are provided on the report generation interface for the user to select, so that the user can generate the report according to the dimension of the relationship, and the information such as the required dimension is not required to be reported to the research personnel, so that the research personnel can generate the report according to the requirement, and the report can be generated simply and rapidly.
In a possible implementation manner, before the report generating request triggered by the report generating interface is obtained, the method further includes:
acquiring a report creation request, wherein the report creation request comprises a report theme identifier, a fact table list and a dimension table list;
associating a plurality of fact tables corresponding to the report topic identifiers according to the fact table list, associating the plurality of dimension tables corresponding to the report topic identifiers according to the dimension table list, and establishing a first association relationship between the plurality of fact tables and the plurality of dimension tables;
and generating a report generating interface according to the fact tables, the dimension tables and the first association relation.
In a possible implementation manner, establishing an initial report according to the fact tables, the dimension tables and the first association relation includes:
for any fact table, determining a measurement field and a dimension field in the fact table, wherein the measurement field is a field capable of numerical analysis, and the dimension field is a field capable of classification;
determining hierarchy information in a dimension table for any dimension table; the metric field, the dimension field, the hierarchy information and the first association are used to determine a screening element of the report generation interface.
In a possible implementation manner, the method further includes stitching a query sql, based on the output dimension indicated in the report generation request and metric information of the output dimension, where the query sql is used by a computing engine to generate a report.
Through the method, the fact table and the information after the screening and filtering of each field in the dimension table form a query sql for the calculation engine to generate the report, and in the query statement, the output dimension and the measurement information of the output dimension are set, so that the report under the specific dimension and the specific measurement is obtained, and the report is more accurately and conveniently obtained.
In a second aspect, an embodiment of the present application provides a report generating device based on self-configuration, including:
the acquisition module is used for acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report;
the generation module is used for generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and the output dimension indicates dimension fields of the report, and the measurement information is used for indicating a statistical mode corresponding to any dimension field.
In a possible implementation manner, a screening element is set in the report generation interface, and the screening element is obtained based on a screening rule for screening a fact table in the report creation request;
the report generation request also has screening conditions for indicating the report under the screening rules; the screening conditions are determined based on the values of the screening elements set by a user under the screening rules, and are used for acquiring data information meeting the screening conditions from the fact table.
In a possible implementation manner, the filtering rule is a filtering condition for setting fields in the fact table, or a filtering tree formed by a plurality of setting fields in the fact table.
In a possible implementation manner, the rule tree includes a root node and a plurality of sub-nodes, and the generating module is specifically configured to determine, for any one of the sub-nodes, a splicing rule of a plurality of sub-filtering conditions according to a logical symbol of the root node; and splicing the sub-screening conditions based on the splicing rules to obtain the rule tree.
In a possible implementation manner, a filtering rule is further set in the report generation interface, and the filtering rule is obtained based on each dimension information in the dimension table; the report generation request also has a filter element determined from the filter rule; the filtering element is determined based on the value of the filtering element set by the user under the screening rule, and is used for acquiring the data information conforming to the filtering element from the fact table.
In a possible implementation manner, the obtaining module is further configured to obtain a report creation request, where the report creation request includes a report topic identifier, a fact table list and a dimension table list; associating a plurality of fact tables corresponding to the report topic identifiers according to the fact table list, associating the plurality of dimension tables corresponding to the report topic identifiers according to the dimension table list, and establishing a first association relationship between the plurality of fact tables and the plurality of dimension tables; and generating a report generating interface according to the fact tables, the dimension tables and the first association relation.
In a possible implementation manner, the generating module is further configured to determine, for any fact table, a metric field and a dimension field in the fact table, where the metric field is a field of a numerical analysis type, and the dimension field is a sortable field; the generation module is further used for determining the level information in any dimension table; the metric field, the dimension field, the hierarchy information and the first association are used to determine a screening element of the report generation interface.
In a possible implementation manner, the device further comprises a splicing module, configured to splice a query sql, based on the output dimension indicated in the report generation request and the measurement information of the output dimension, where the query sql is used by a computing engine to generate a report.
In a third aspect, embodiments of the present application provide a computer-readable storage medium storing a computer program that, when executed, performs any of the methods of the first aspect described above.
In a fourth aspect, embodiments of the present application provide a computing device comprising: a memory for storing program instructions; and a processor for calling program instructions stored in the memory and executing the method according to the obtained program.
In a fifth aspect, embodiments of the present application provide a computer program product for implementing a method as in any of the designs of the first aspect above, when the computer program product is run on a processor.
The advantages of the second to fifth aspects may be specifically referred to the advantages achieved by any of the designs of the first aspect, and are not described here again.
Drawings
Fig. 1 schematically illustrates a scene architecture provided in an embodiment of the present application;
fig. 2 schematically illustrates a flow chart of a report generating method based on self-configuration according to an embodiment of the present application;
FIG. 3 is a schematic flow chart illustrating a report generating interface generating method according to an embodiment of the present application;
FIG. 4 is a schematic diagram illustrating a report generation interface provided by an embodiment of the present application;
FIG. 5 illustrates a schematic diagram of a query sql provided by an embodiment of the present application;
fig. 6 schematically illustrates a report generating device based on self-configuration according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail below with reference to the accompanying drawings, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
For some financial institutions, due to the increase of business types, the demands for reports are increasing, and the report demands cannot be put into production rapidly under the conditions of limited number of developers, long on-line production process from demand acceptance and the like. In addition, the report requirements of the same department are generally similar, for example, most of report requirements of a certain department are based on a fact table, screening is performed according to a certain caliber, and then multidimensional analysis is performed on the fact table in combination with a dimension table to generate a report. In the current report generation mode, a similar new report needs to be repeatedly developed, codes are not easy to maintain, the report generation efficiency is low, and the business processing process is slow.
Fig. 1 exemplarily illustrates a report system configuration method provided in an embodiment of the present application, as shown in fig. 1, including the following steps:
step 101, a report system receives search source configuration information sent by a user; receiving search source configuration information sent by a user by a report system, wherein the search source configuration information is used for configuring a search source; the retrieval source is typically a database, or a plurality of data tables; the plurality of data tables may be stored in the form of tables, intermediate tables, views, or Structured Query Language (SQL) statement fragments, or functions, or stored procedures; the database contains one or more data tables. The reporting system obtains data by retrieving the source. In the step, the user can configure the retrieval source which is searched by the report system according to the self requirement and the self authority, and in the configuration process, the configuration information of the retrieval source is sent to the report system.
Step 102, configuring a search source based on the received search source configuration information;
step 103, receiving display mode configuration information for the data in the retrieval source, which is sent by a user; the report system acquires data through the retrieval source to generate a report, so that the display mode of the data needs to be determined. Therefore, in this step, the presentation mode configuration information for the data in the search source, which is sent by the user, is received.
Step 104, configuring a data display mode based on the display mode configuration information;
step 105, determining a filter and a query condition pattern corresponding to the retrieval source; after the search source is determined, the reporting system is able to determine the filter corresponding to the search source by analysis of the search source on the one hand, and is also able to determine the query condition pattern corresponding to the search source on the other hand.
And 106, generating a report system query interface according to the display mode configuration information, the filter and the query condition patterns. After the display mode configuration information, the filter and the query condition patterns are determined, the system can generate a report system query interface according to the information, and the interface is generated based on user configuration and analysis of the report system.
According to the steps, the user participates in the whole process of generating the query interface of the report system, so that the query interface of the report system is completely customized according to the needs of the user, completely accords with the use habit of the user, and can meet the needs of users in any field. However, in the above-mentioned process, the process of requiring the user to participate is excessive, and the requirement for the professional ability of the user is high, so that the user must input a correct instruction to obtain a correct report. In addition, the user needs multiple steps of operations, and the user inputs corresponding data almost in each step, so that the requirements of data safety under the financial business scene are not met. Meanwhile, the report generation efficiency is reduced.
Based on the method, the report generating method based on self configuration is provided, so that the report generating process meets the requirements of service scenes better, the steps of processing user operation are reduced, the data security is ensured, and the report generating efficiency is improved.
Fig. 2 schematically illustrates a flow chart of a report generating method based on self-configuration according to an embodiment of the present application, as shown in fig. 2, the method includes:
step 201, acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report.
The user in the step can be a business person, and the business person operates on the report generation interface, clicks a submit button or a confirm button and the like, and generates a report generation request. The report generation page is generated in advance according to a report creation request, wherein the report creation request comprises a set report theme, a fact table corresponding to the report creation request and a dimension table associated with the fact table.
Step 202, generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and outputting dimension fields of the dimension indication report, wherein the measurement information is used for indicating a statistical mode corresponding to any dimension field.
The report generation request includes an output dimension, where the output dimension is a dimension of report observation, that is, a dimension of interest to the user, for example, a card issuing institution dimension, a merchant name dimension, a card property dimension, a card level dimension, and the like. The measurement information is some statistical information, mainly numerical information which can be counted, such as successful transaction amount, successful transaction number, total transaction number and the like.
By the method, the report generation interface is generated based on the fact table and the dimension table in the report creation request, and the report generation interface is used for screening the report for the first time in practice, so that some self-configuration options are provided for the user, and the user can perform more simple configuration operation. The user can trigger a report generation request on the interface, the interface interacts with the user to acquire the requirement of the user on the report, and the measurement information under the specific dimension is generated based on the report generation request comprising the requirement of the user, so that the requirement of the user is accurately reflected by the report, and the report generation efficiency is improved.
In one possible implementation manner, a filtering element is set in the report generating interface, and the filtering element is obtained based on a filtering rule for filtering the fact table in the report creating request. The report generation request also has screening conditions for indicating the report under the screening rules; the screening conditions are determined based on the values of the screening elements set by a user under the screening rules, and are used for acquiring data information meeting the screening conditions from the fact table.
How to generate the report generation interface based on the report creation request is described below. Fig. 3 is a schematic flow chart illustrating a report generating interface generating method according to an embodiment of the present application, where, as shown in fig. 3, the method includes:
step 301, a report creating request is obtained, wherein the report creating request comprises a report theme identifier, a fact table list and a dimension table list.
The report theme identifier is used for identifying only one report theme, and a plurality of different reports can be generated under the report theme so as to meet the requirements of business personnel. For example, the report topic may be a "multidimensional analysis report" under which business personnel may analyze the report in multiple dimensions. In addition, the report creation request also comprises a fact table list and a dimension table list, which are the sets of the fact table and the dimension table needed to be used under the report subject.
Step 302, associating a plurality of fact tables corresponding to the report topic identifications according to the fact table list, associating a plurality of dimension tables corresponding to the report topic identifications according to the dimension table list, and establishing a first association relationship between the plurality of fact tables and the plurality of dimension tables.
The preconfigured data source comprises a plurality of fact tables, dimension tables and a plurality of cluster information. The cluster information is used to describe from which data cluster the data in the data source came. For example, some data is stored in a Shanghai cluster, some data is stored in a Beijing cluster, and the data in the fact table is acquired after determining the cluster information. There is an association between a plurality of fact tables and a plurality of dimension tables, for example, one fact table is a transaction table, and then the dimension table corresponding to the transaction table is the dimension that can filter the transaction table. For example, the card issuing entity is screened out of the transaction list for a transaction of an xxx bank, or is screened out for an online transaction.
And step 303, generating a report generating interface according to the fact tables, the dimension tables and the first association relation.
For any fact table, a measurement field and a dimension field in the fact table are determined, wherein the measurement field is a field of a numerical analysis type, and the dimension field is a field of a sortable type. Determining hierarchy information in a dimension table for any dimension table; for example, the dimension tables may be summarized hierarchically, with a first hierarchy being A1, B1, C1, D1 and a second hierarchy being A2, B2, C2, D2 for the a dimension. For example, the card issuing mechanism (a) has five-level dimensions of a mechanism major class (A4), a mechanism middle class (A3), a mechanism minor class (A2), a mechanism headquarter (A1) and a mechanism code (A0). In particular implementations, the hierarchy may be identified by a level field. And carrying out field statistics on the fact table to obtain a measurement field and a dimension field.
The metric field, the dimension field, the hierarchy information and the first association are used to determine a screening element of the report generation interface. Fig. 4 is a schematic diagram illustrating a report generation interface provided in an embodiment of the present application, where, as shown in fig. 4, a filtering element in the report generation interface has a time range, a small card filtering, a transaction amount with a pen, and a merchant type.
The user sets up in the interface of fig. 4, for example, inputs a time range, fills in the value of the transaction amount, selects a specific merchant type, etc., to form a specific screening condition for each screening element.
In fig. 4, the filtering rule is a filtering condition for setting fields in the fact table, or a filtering tree formed by a plurality of setting fields in the fact table.
The rule tree comprises a root node and a plurality of child nodes, and is determined by the following steps:
step one, aiming at any child node, determining a child screening condition according to an input value of the child node;
step two, determining splicing rules of a plurality of sub-screening conditions according to the logical symbols of the root node;
and thirdly, splicing the sub-screening conditions based on splicing rules to obtain a rule tree.
In a specific implementation, each node has a plurality of attributes: node type nodeType, logical symbol logic, rule, child node list child. The node type nodeType is used for identifying whether a node is a child node child or a root node, the node type nodeType is used for identifying whether a node is a root node or a child node, and the logical symbol logic is used for identifying a splicing rule of the child nodes under a root node, for example, each child rule is connected with 'AND', or connected with 'OR', and the logical symbol of each child node is 'null'. The child attribute of the root node contains 0 to a plurality of child nodes, the child node child attribute is null, and the child node child attribute value is Rule.
In one possible implementation, the rule tree is spliced, and the rule tree is executed according to the following rule, and the filter rule, the filter value rule value list and the operator operators of the nodes are read. If the operator is "in", the spliced SQL is "filter field name in (filter value specific value)"; if the operator takes a value of "LT", then the spliced SQL is "filter < fileValue"; if the Operator takes a value of "GT", then the spliced SQL is "filter > filter value"; if the Operator takes on the value "interval", the filterValue array has two values f1, f2, and the concatenated SQL is "filter > =f1 and filter < =f2". Traversing the child attribute of the node cnode, wherein each child node is an iNode, and the index is i: sql [ i ] = generateSql (iNode), if node attribute logic is "AND", then sub sql in the sql array are concatenated with "AND", such as "(sql [0] AND sql [1] and..sql [ i ])". If the attribute logic is "OR", then "OR" is used to splice, such as "sql [0] OR sql [1] OR.
In the interface shown in fig. 4, the root node logic of the filtering rule takes the value "and", and then uses and splices the two child nodes.
Through the method, after the screening conditions are determined, the data information meeting the screening conditions can be obtained from the real table, so that a report is obtained.
By means of the rule tree pre-configuration mode, an interface for inputting specific rules is provided for a user, the user can determine screening rules only by inputting specific values in the interface, and accordingly corresponding data information is obtained, and a report is generated. And the rule tree can be configured, screening elements of screening rules are set, types of nodes in the rule tree and calculation logic among the nodes are set, and therefore personalized configuration of the report is achieved.
In a possible implementation manner, a filtering rule is further arranged in the report generation interface, and the filtering rule is obtained based on each dimension information in the dimension table; the report generation request also has a filter element determined from the filter rule; the filtering element is determined based on the value of the filtering element set by the user under the screening rule, and is used for acquiring the data information conforming to the filtering element from the fact table.
Illustratively, the rule set in the report generating interface includes a dimension field located at the first level, and then the filtering element may be a filtering element of another level. The user selects a specific filtering element to determine the dimension of interest, and can acquire the data information conforming to the filtering element from the real table to generate a specific report.
By the method, the filtering rule options are provided on the report generation interface for the user to select, so that the user can generate the report according to the dimension of the relationship, and the information such as the required dimension is not required to be reported to the research personnel, so that the research personnel can generate the report according to the requirement, and the report can be generated simply and rapidly.
In one possible implementation, based on the output dimension indicated in the report generation request and the measurement information of the output dimension, a query sql is spliced, where the query sql is used by a computing engine to generate a report.
Fig. 5 schematically illustrates a query sql provided in an embodiment of the present application, as shown in fig. 5, where the first row and the second row represent metric information of an output dimension and an output dimension, the output dimension is an online-offline dimension and a terminal code dimension, and the metric information is a total transaction amount and a total transaction number. The name of the fact table is xxxxxxxxxxxstart day scl, one of the screening conditions is trans at <2, and the transaction type is: fast food restaurants. The left join field represents a fact table or dimension table used for generating the report. Further screening date conditions are information between 2023, 10, month, 01 and 2023, 10, month, 14, filtering conditions are in-house network access organization and online-offline dimension, terminal code dimension.
Through the method, the fact table and the information after the screening and filtering of each field in the dimension table form a query sql for the calculation engine to generate the report, and in the query statement, the output dimension and the measurement information of the output dimension are set, so that the report under the specific dimension and the specific measurement is obtained, and the report is more accurately and conveniently obtained.
Based on the same technical conception, the embodiment of the application also provides a report generating device based on self-configuration. Fig. 6 schematically illustrates a self-configuration-based report generating device provided in an embodiment of the present application, where the device may perform the foregoing self-configuration-based report generating method, as shown in fig. 6, and the device includes:
the acquisition module is used for acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report;
the generation module is used for generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and the output dimension indicates dimension fields of the report, and the measurement information is used for indicating a statistical mode corresponding to any dimension field.
In a possible implementation manner, a screening element is set in the report generation interface, and the screening element is obtained based on a screening rule for screening a fact table in the report creation request;
the report generation request also has screening conditions for indicating the report under the screening rules; the screening conditions are determined based on the values of the screening elements set by a user under the screening rules, and are used for acquiring data information meeting the screening conditions from the fact table.
In a possible implementation manner, the filtering rule is a filtering condition for setting fields in the fact table, or a filtering tree formed by a plurality of setting fields in the fact table.
In a possible implementation manner, the rule tree includes a root node and a plurality of sub-nodes, and the generating module is specifically configured to determine, for any one of the sub-nodes, a splicing rule of a plurality of sub-filtering conditions according to a logical symbol of the root node; and splicing the sub-screening conditions based on the splicing rules to obtain the rule tree.
In a possible implementation manner, a filtering rule is further set in the report generation interface, and the filtering rule is obtained based on each dimension information in the dimension table; the report generation request also has a filter element determined from the filter rule; the filtering element is determined based on the value of the filtering element set by the user under the screening rule, and is used for acquiring the data information conforming to the filtering element from the fact table.
In a possible implementation manner, the obtaining module is further configured to obtain a report creation request, where the report creation request includes a report topic identifier, a fact table list and a dimension table list; associating a plurality of fact tables corresponding to the report topic identifiers according to the fact table list, associating the plurality of dimension tables corresponding to the report topic identifiers according to the dimension table list, and establishing a first association relationship between the plurality of fact tables and the plurality of dimension tables; and generating a report generating interface according to the fact tables, the dimension tables and the first association relation.
In a possible implementation manner, the generating module is further configured to determine, for any fact table, a metric field and a dimension field in the fact table, where the metric field is a field of a numerical analysis type, and the dimension field is a sortable field; the generation module is further used for determining the level information in any dimension table; the metric field, the dimension field, the hierarchy information and the first association are used to determine a screening element of the report generation interface.
In a possible implementation manner, the device further comprises a splicing module, configured to splice a query sql, based on the output dimension indicated in the report generation request and the measurement information of the output dimension, where the query sql is used by a computing engine to generate a report.
Based on the same technical idea, the embodiments of the present invention also provide a computer program product, which when run on a processor, implements the method shown in the above embodiments.
Based on the same technical concept, the embodiment of the invention further provides a computing device, which comprises: a memory for storing program instructions;
and a processor for calling the program instructions stored in the memory and executing the method shown in the above embodiment according to the obtained program.
Based on the same technical idea, the embodiments of the present invention also provide a computer-readable storage medium, which when run on a processor, implements the method shown in the above embodiments.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various modifications and variations can be made in the present application without departing from the spirit or scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims and the equivalents thereof, the present application is intended to cover such modifications and variations.
Claims (11)
1. A report generation method based on self-configuration is characterized by comprising the following steps:
acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report;
generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and the output dimension indicates dimension fields of the report, and the measurement information is used for indicating a statistical mode corresponding to any dimension field.
2. The method of claim 1, wherein,
screening elements are arranged in the report generation interface, and the screening elements are obtained based on screening rules for screening the fact table in the report creation request;
the report generation request also has screening conditions for indicating the report under the screening rules; the screening conditions are determined based on the values of the screening elements set by a user under the screening rules, and are used for acquiring data information meeting the screening conditions from the fact table.
3. The method of claim 2, wherein,
the screening rule is a screening condition aiming at a set field in the fact table or a screening tree formed by a plurality of set fields in the fact table.
4. The method of claim 3, wherein the rule tree comprises a root node and a plurality of child nodes, the rule tree being determined by,
for any child node, determining a child screening condition according to the input value of the child node:
determining a splicing rule of a plurality of sub-screening conditions according to the logical symbols of the root node;
and splicing the sub-screening conditions based on the splicing rules to obtain the rule tree.
5. The method of claim 1, wherein,
the report generation interface is also provided with a filtering rule, and the filtering rule is obtained based on each dimension information in the dimension table;
the report generation request also has a filter element determined from the filter rule; the filtering element is determined based on the value of the filtering element set by the user under the screening rule, and is used for acquiring the data information conforming to the filtering element from the fact table.
6. The method of any one of claims 1-4, wherein prior to obtaining a report generation request triggered by a report generation interface by a user, the method further comprises:
acquiring a report creation request, wherein the report creation request comprises a report theme identifier, a fact table list and a dimension table list;
associating a plurality of fact tables corresponding to the report topic identifiers according to the fact table list, associating the plurality of dimension tables corresponding to the report topic identifiers according to the dimension table list, and establishing a first association relationship between the plurality of fact tables and the plurality of dimension tables;
and generating a report generating interface according to the fact tables, the dimension tables and the first association relation.
7. The method of claim 6, wherein establishing an initial report from the plurality of fact tables, the plurality of dimension tables, and the first association relationship comprises:
for any fact table, determining a measurement field and a dimension field in the fact table, wherein the measurement field is a field capable of numerical analysis, and the dimension field is a field capable of classification;
determining hierarchy information in a dimension table for any dimension table;
the metric field, the dimension field, the hierarchy information and the first association are used to determine a screening element of the report generation interface.
8. The method of any of claims 1-4, further comprising stitching a query sql based on output dimensions indicated in the report generation request and metric information of output dimensions, the query sql being used by a compute engine to generate a report.
9. A report generation method based on self-configuration is characterized by comprising the following steps:
the acquisition module is used for acquiring a report generation request triggered by a user on a report generation interface; the report generation interface is based on a report creation request; the report creation request is provided with a fact table corresponding to the set report theme and a dimension table associated with the fact table; the fact table is used for indicating the data source of the report; the dimension table is used for indicating dimension information of the report;
the generation module is used for generating a report based on the output dimension indicated in the report generation request and the measurement information of the output dimension; and the output dimension indicates dimension fields of the report, and the measurement information is used for indicating a statistical mode corresponding to any dimension field.
10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program which, when run, performs the method according to any one of claims 1 to 8.
11. A computing device, comprising:
a memory for storing program instructions;
a processor for invoking program instructions stored in said memory to perform the method of any of claims 1-8 in accordance with the obtained program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311718565.9A CN117851404A (en) | 2023-12-13 | 2023-12-13 | Report generation method, device, medium and equipment based on self-configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311718565.9A CN117851404A (en) | 2023-12-13 | 2023-12-13 | Report generation method, device, medium and equipment based on self-configuration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117851404A true CN117851404A (en) | 2024-04-09 |
Family
ID=90541131
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311718565.9A Pending CN117851404A (en) | 2023-12-13 | 2023-12-13 | Report generation method, device, medium and equipment based on self-configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117851404A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118227674A (en) * | 2024-05-22 | 2024-06-21 | 江苏中仑数字科技有限公司 | Report generation method and device and electronic equipment |
-
2023
- 2023-12-13 CN CN202311718565.9A patent/CN117851404A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118227674A (en) * | 2024-05-22 | 2024-06-21 | 江苏中仑数字科技有限公司 | Report generation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11328128B2 (en) | System and method for analysis and navigation of data | |
| CN102999561B (en) | The context trend of data set and data, services | |
| US11113317B2 (en) | Generating parsing rules for log messages | |
| CN111191125A (en) | Data analysis method based on tagging | |
| CN117851404A (en) | Report generation method, device, medium and equipment based on self-configuration | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN114168565B (en) | Backtracking test method, device and system of business rule model and decision engine | |
| CN111737608A (en) | Enterprise information retrieval result ordering method and device | |
| CN110737432A (en) | script aided design method and device based on root list | |
| CN116957813B (en) | Wind control strategy testing method and device, electronic equipment and readable storage medium | |
| CN107368500A (en) | Data pick-up method and system | |
| CN112631889A (en) | Portrayal method, device and equipment for application system and readable storage medium | |
| CN115510289B (en) | Data cube configuration method and device, electronic equipment and storage medium | |
| CN113641523B (en) | Log processing method and device | |
| CN110765100A (en) | Label generation method and device, computer readable storage medium and server | |
| CN110781211A (en) | Data analysis method and device | |
| CN114860819A (en) | Method, device, equipment and storage medium for constructing business intelligent system | |
| CN113868141A (en) | Data testing method and device, electronic equipment and storage medium | |
| CN113342786A (en) | Model management and control-based online data management and management method and system | |
| CN112612817A (en) | Data processing method and device, terminal equipment and computer readable storage medium | |
| CN112199269A (en) | Data processing method and related device | |
| CN111352824A (en) | Test method and device and computer equipment | |
| CN116226105A (en) | Data management method and device, electronic equipment and computer storage medium | |
| CN115860010A (en) | Topic mining method and related device | |
| CN116991951A (en) | Root cause quality difference index determination method and device and computer equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |