CN117669514A - Method and device for generating analysis report, electronic equipment and storage medium - Google Patents
Method and device for generating analysis report, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN117669514A CN117669514A CN202311393212.6A CN202311393212A CN117669514A CN 117669514 A CN117669514 A CN 117669514A CN 202311393212 A CN202311393212 A CN 202311393212A CN 117669514 A CN117669514 A CN 117669514A
- Authority
- CN
- China
- Prior art keywords
- analysis report
- data
- matrix
- index
- query
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Game Theory and Decision Science (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for generating an analysis report, which belong to the technical field of data processing, wherein the method comprises the following steps: determining an index signboard and a query condition of service data based on query demand information of a user; further obtaining a plurality of groups of response data; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and further obtaining an analysis report. According to the invention, the response data can be acquired accurately by determining the index board and the query condition to acquire the response data. By combining the rows and columns in the matrix data and generating a final analysis report, the multi-dimensional analysis report is obtained according to the requirements of clients so as to view the data in multiple dimensions.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for generating an analysis report, an electronic device, and a storage medium.
Background
In the business process of enterprises, decision makers are more concerned about the development condition of the businesses, and in order for the decision maker to better develop the businesses and perform business analysis, the development condition of the businesses needs to be checked dynamically according to different conditions, dimensions or indexes. The existing service data are independent and scattered and complex, so that the data analysis is low in efficiency and low in utilization rate.
In summary, a method needs to be found that can flexibly view service data.
Disclosure of Invention
The invention provides a generation method of an analysis report, which is used for solving the defect of limited view dimension of business data in the prior art and realizing multi-dimensional view of the data according to the requirements of clients.
In a first aspect, the present invention provides a method for generating an analysis report, including:
determining an index signboard and a query condition of service data based on query demand information of a user;
acquiring a plurality of groups of response data associated with the query condition from the index board;
generating a multi-dimensional table based on the response data;
converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located;
And converting the combined matrix data into a table to obtain an analysis report.
According to the method for generating the analysis report, the query conditions comprise screening conditions, selection dimensions and selection indexes; the index signboard comprises components, matching rules and component values, and determining the index signboard and the query condition of the service data based on the query requirement information of the user comprises the following steps:
determining the index signboards matched with the query requirement information;
selecting a first component element, a first matching rule and a first component element value which are matched with the query requirement information in the index billboard to obtain the screening condition;
selecting a second component matched with the query requirement information from the index board to obtain the selected dimension;
and selecting a third component value matched with the query requirement information and a third matching rule from the index billboard to obtain the selection index.
According to the method for generating the analysis report, which is provided by the invention, the multidimensional table is generated based on the response data, and the method comprises the following steps:
acquiring a type value, a sorting value, an ID and a parent ID of the response data;
Performing first sorting on the response data based on the type value to obtain a first-stage sorting result;
performing secondary sorting on the response data based on the sorting value to obtain a secondary sorting result;
performing multistage sorting on the response data based on the ID of the response data and the parent ID of the response data to obtain a multistage sorting result;
and based on the primary sorting result, the secondary sorting result and the multi-stage sorting result, sorting and combining the response data to obtain the multi-dimensional table.
According to the method for generating the analysis report, the multi-dimensional table is converted into matrix data, identical matrix points in the matrix data are determined, and rows and columns where the identical matrix points are located are combined, and the method comprises the following steps:
forming one row of the multi-dimensional table into one row of the matrix data, forming one column of the multi-dimensional table into one column of the matrix data, wherein one parameter item in the multi-dimensional table is one matrix point in the matrix data;
determining matrix points with the same value in the matrix data as the same matrix points;
and merging the same adjacent matrix points in one column of the matrix data, and merging the same adjacent matrix points in one row of the matrix data.
According to the method for generating the analysis report provided by the invention, the combined matrix data is converted into the table to obtain the analysis report, and the method comprises the following steps:
combining the rows of the matrix data to form the rows of the analysis report;
forming the columns of the combined matrix data into the columns of the analysis report;
and obtaining the analysis report based on the rows and columns of the analysis report.
According to the method for generating an analysis report provided by the invention, after the combined matrix data is converted into a table to obtain the analysis report, the method further comprises the following steps:
storing the name of the analysis report, the query condition, the response data with the combined identifier and the ID of the index signboard;
and inquiring the analysis report based on the ID of the index board and the name of the analysis report.
According to the method for generating the analysis report, provided by the invention, the index signboard and the query condition of the service data are determined based on the query requirement information of the user, and the method comprises the following steps:
determining a first interaction component of the screening condition, a second interaction component of the selection dimension and a third interaction component of the selection index; wherein the first interaction component comprises a plurality of initial screening conditions, the second interaction component comprises a plurality of initial selection dimensions, and the third interaction component comprises a plurality of initial selection indexes;
Selecting the initial screening condition matched with the query requirement information in the first interaction component to obtain the screening condition;
selecting the initial selection dimension matched with the query requirement information in the second interaction component to obtain the selection dimension;
and selecting the initial selection index matched with the query requirement information in the third interaction component to obtain the selection index.
In a second aspect, the present invention further provides a generating device for an analysis report, including:
the determining module is used for determining an index signboard and a query condition of the service data based on the query demand information of the user;
the acquisition module is used for acquiring a plurality of groups of response data associated with the query condition from the index billboard;
the multidimensional form generating module is used for generating a multidimensional form based on the response data;
the merging module is used for converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data and merging the row and the column where the same matrix point is located;
and the analysis report generation module is used for converting the combined matrix data into a table so as to obtain an analysis report.
In a third aspect, the present invention provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method for generating an analysis report as described in any one of the above when executing the program.
In a fourth aspect, the present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of a method of generating an analysis report as described in any of the above.
According to the method and the device for generating the analysis report, the index signboards and the query conditions of the business data are determined based on the query demand information of the user; acquiring a plurality of groups of response data associated with the query condition from the index board; generating a multi-dimensional table based on the response data; converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report. According to the invention, the response data can be acquired accurately by determining the index board and the query condition to acquire the response data. By combining the rows and columns in the matrix data and generating a final analysis report, the multi-dimensional analysis report is obtained according to the requirements of clients so as to view the data in multiple dimensions.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for generating an analysis report according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an index board and a multi-dimensional table according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of initial selection indicators, and unselected data provided by an embodiment of the present invention;
FIG. 4 is a schematic diagram of an analysis report according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a device for generating an analysis report according to the present invention;
fig. 6 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are 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.
It should be noted that in the description of embodiments of the present invention, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element. The orientation or positional relationship indicated by the terms "upper", "lower", etc. are based on the orientation or positional relationship shown in the drawings, are merely for convenience of description and to simplify the description, and are not indicative or implying that the apparatus or elements in question must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be construed as limiting the present invention. Unless specifically stated or limited otherwise, the terms "mounted," "connected," and "coupled" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art according to the specific circumstances.
The terms "first," "second," and the like in this specification are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged, as appropriate, such that embodiments of the present invention may be implemented in sequences other than those illustrated or described herein, and that the objects identified by "first," "second," etc. are generally of a type, and are not limited to the number of objects, such as the first object may be one or more. In addition, "and/or" indicates at least one of the connected objects, and the character "/", generally indicates that the associated object is an "or" relationship.
The following describes a method and a device for generating an analysis report provided by the embodiment of the invention with reference to fig. 1 to fig. 6.
Fig. 1 is a flow chart of a method for generating an analysis report according to the present invention, as shown in fig. 1, including but not limited to the following steps:
step 100: determining an index signboard and a query condition of service data based on query demand information of a user;
it should be noted that, the execution main body of the task construction method provided by the embodiment of the present invention may be a server, a computer device, such as a mobile phone, a tablet computer, a notebook computer, a palm computer, a vehicle-mounted electronic device, a wearable device, an ultra-mobile personal computer (ultra-mobile personal computer, UMPC), a netbook, a personal digital assistant (personal digital assistant, PDA), or the like.
As shown in fig. 2, the index bulletin is an interface for displaying business index data, and the index bulletin includes various types, such as a device index bulletin, a performance index bulletin, a claim settlement index bulletin, a wind control index bulletin, a financial index bulletin, and the like. Different index signboards have different configuration information and response data. Configuration information and response data in the index signboards are not used differently. For example, financial indicators relate to finance, money, cost, etc.; the equipment index sign relates to installation quantity, equipment quantity and the like. The query condition is the configuration information matched with the query requirement information in the index signboard.
And the user selects an index board matched with the query requirement information at the client, and selects a query condition matched with the query requirement information from configuration information of the index board.
Step 200: acquiring a plurality of groups of response data associated with the query condition from the index billboard;
when a user selects an index board from a client, each index board has a unique identity ID, and when the user selects the corresponding index board, the configuration information and response data under the index board are obtained according to the ID of the index board. The configuration information includes constituent elements, matching rules, and constituent element values, each of which has a uniquely specified ID by which corresponding response data can be identified. And acquiring multiple groups of response data associated with the query conditions from the index bulletin board according to the query conditions (configuration information selected by the user) input by the user.
Step 300: generating a multi-dimensional table based on the response data;
based on the response data, a multi-dimensional table is generated. For example, a user experience network (ux-grid) component employing a you Mi UI (umy-UI) generates a multi-dimensional table. First, the response data is processed into a data format receivable by ux-grid, such as array (columns). And according to the head data in the response data, sequencing and assembling the array to form the array with the tree structure. And then inputting the array of the tree structure and main data in the response data into a ux-grid component together, and rendering through ux-grid to obtain a multidimensional table.
Step 400: converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located;
the whole multi-dimensional table is regarded as matrix data, and one parameter item in response data corresponds to one matrix point on the matrix data. As shown in fig. 4, the rows in the matrix data where the same matrix points exist are combined, for example, in 2 rows of the matrix data, two rows in which the matrix points are all the same are combined. The columns of the matrix data, in which the same matrix point exists, are combined, for example, in 2 columns of the matrix data, partial columns in which the same matrix point exists are combined, and partial columns in which the matrix point is different are reserved.
Step 500: and converting the combined matrix data into a table to obtain an analysis report.
And taking the rows of the combined matrix data as the rows of the analysis report, taking the columns of the combined matrix data as the columns of the analysis report, and outputting the rows and the columns of the analysis report to obtain the analysis report.
Further, the matrix data is converted into an analysis table by the ux-grid component. Parameters such as a row (row), a column (col), a row merging row (rowspan), a column merging column (colspan) and the like in the matrix data are determined, and the processed data such as row, col, rowspan, colspan are set in merging cell (mergeCells) attributes in the ux-grid assembly so as to merge and output the matrix data, so that an analysis report is obtained.
According to the method for generating the analysis report, provided by the embodiment of the invention, the index signboards and the query conditions of the business data are determined based on the query demand information of the user; acquiring a plurality of groups of response data associated with the query condition from the index billboard; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report. According to the embodiment of the invention, the response data can be acquired accurately by determining the index board and the query condition to acquire the response data. By combining the rows and columns in the matrix data and generating a final analysis report, the multi-dimensional analysis report is obtained according to the requirements of clients so as to view the data in multiple dimensions.
Based on the above embodiment, the query conditions include a screening condition, a selection dimension, and a selection index; the index signboard comprises components, matching rules and component values, and the index signboard and the query conditions of the service data are determined based on the query requirement information of the user, and the method comprises the following steps:
step 110: determining an index billboard matched with the query requirement information;
step 120: selecting a first component element matched with the query requirement information, a first matching rule and a first component element value in the index billboard to obtain screening conditions;
step 130: selecting a second component matched with the query requirement information in the index billboard to obtain a selected dimension;
step 140: and selecting a third component value matched with the query requirement information and a third matching rule in the index billboard to obtain a selection index.
As shown in fig. 2, the query conditions include a screening condition, a selection dimension, and a selection index; the configuration information includes constituent elements, matching rules, and constituent element values. As shown in fig. 2, for example, the constituent elements include organization architecture, date, installed quantity, dispatch rate, and the like; the matching rule comprises equal to, less than or equal to, including, etc.; constituent element values include Shanxi, 2023-7-04, company A, and the like.
For example, when the user wants to view the number of installed devices of the insurance company of the a-province B, C on the 7 th year of 2023, "the number of installed devices of the insurance company of the a-province A, B, C, D on the 7 th year of 2023" is the query requirement information, and the index sign is determined as the device index sign based on the query requirement information.
When the screening condition is determined, a first component is determined, a first matching rule matched with the first component is searched in the matching rules according to the first component, and a first component value matched with the first component is selected based on the determined first component and the first matching rule. For example, a first component (e.g., date, organization structure, insurance company), a first matching rule (e.g., equals, contains), and a first component value (e.g., a province, a insurance company, B insurance company, C insurance company, D insurance company, 2023, 7 months, 4 days) that match the query requirement information are selected in the screening condition column of the device index bulletin. And obtaining screening conditions according to the first component, the first matching rule and the first component value selected by the user, wherein the date is 2023, 7 and 4, the organization structure is A province, and the insurance companies comprise A insurance companies, B insurance companies, C insurance companies and D insurance companies.
And selecting a second component element matched with the query requirement information, such as an organization structure and an insurance company, in a selection dimension column of the equipment index board. And selecting the organization architecture and the insurance company according to the selection dimension obtained by the screening of the user.
Selecting a third component value matched with the query demand information in the equipment index board, such as dispatching order aging, 0,3,7, 30, 15, 60, installation aging, dispatching order rate, installation rate and health rate; the third matching rule is, for example, equal to or less than, equal to or greater than, less than, or greater than. According to the selection indexes obtained by screening of users, the dispatching time efficiency is more than or equal to 0 and less than or equal to 7, the dispatching time efficiency is more than or equal to 0, the dispatching time efficiency is more than or equal to 7 and less than or equal to 30, the dispatching time efficiency is more than or equal to 15 and less than or equal to 30, the dispatching time efficiency is more than or equal to 30 and less than or equal to 60, and the dispatching rate, the installation rate and the health rate are all the same.
The screening condition, the selection dimension and the selection index selected by the user form the query condition.
According to the embodiment of the invention, the query condition is determined in the index bulletin board selected by the user based on the query requirement information, and the corresponding response data is matched according to the query requirement information, so that the flexibility and pertinence of analyzing the report are improved.
Based on the above embodiment, generating a multi-dimensional table based on response data includes:
Step 310: acquiring a type value, a sorting value, an ID and a parent level ID of response data;
step 320: the response data is sequenced for the first time based on the type value, and a first-level sequencing result is obtained;
step 330: performing secondary sorting on the response data based on the sorting value to obtain a secondary sorting result;
step 340: performing multistage sequencing on the response data based on the ID of the response data and the parent ID of the response data to obtain a multistage sequencing result;
step 350: and based on the first-level sorting result, the second-level sorting result and the multi-level sorting result, sorting and combining the response data to obtain a multi-dimensional table.
The response data is composed of a plurality of parameter items including header (head) data for recording the kind and ID of the response data and body (body) data for recording specific values and details.
The head data in the response data includes a type value (type), a sort value (sort). And sorting the response data for the first time based on the type value to obtain a first-stage sorting result. For example, the data with type 1 in the response data is the dimension to be observed under what condition, and should be arranged in the forefront of the multidimensional table column; the data of type 2 in the response data is an index that the user wants to see, and should be arranged behind the data of type 1. And performing secondary sorting on the response data based on the sorting value to obtain a secondary sorting result.
The body data in the response data includes an ID and a parent ID (pantid). And carrying out multistage sequencing on the response data in a recursive form based on the ID and the parent ID to obtain a multistage sequencing result.
And ordering the response data based on the first-level ordering result, the second-level ordering result and the multi-level ordering result to obtain a multi-dimensional table.
The embodiment of the invention carries out multistage sequencing on the response data based on the type value, the sequencing value, the ID and the father level ID of the response data, is favorable for intuitively displaying the association relationship of the response data by the multidimensional form and the analysis data, and improves the analysis value of the multidimensional data and the analysis form.
Based on the above embodiment, converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located, including:
step 410: forming one row of the multi-dimensional table into one row of matrix data, forming one column of the multi-dimensional table into one column of the matrix data, and taking one parameter item in the multi-dimensional table as one matrix point in the matrix data;
step 420: determining matrix points with the same value in the matrix data as the same matrix points;
step 430: and merging the adjacent identical matrix points in one column of the matrix data, and merging the adjacent identical matrix points in one row of the matrix data.
The embodiment of the invention combines the multidimensional tables based on the ux-grid component, and parameters such as the line, the column, the line combining lines, the column combining columns and the like are required to be predetermined to be given to the ux-grid component. To determine the same parameter item in the multidimensional table, and find the row and column where the same item is located, so as to combine the row and column; the multi-dimensional table is required to be converted into matrix data, one row of the multi-dimensional table is formed into one row of the matrix data, one column of the multi-dimensional table is formed into one column of the matrix data, and one parameter item in the multi-dimensional table is a matrix point in the matrix data. The value of each matrix point is known, as well as the current coordinates, the matrix data is then grouped, and matrix points (identical matrix points) that are adjacent and have the same value in each column are found and combined. And merging the same matrix points of adjacent rows in each row into an array, merging the same matrix points of part of adjacent rows in each row into an array, and finally outputting the sorted matrix points.
For example, the matrix data is combined and grouped according to columns, and then combined and grouped according to rows, and the matrix data can be circulated to each matrix point in total of 12 columns and 19 rows. The parameter set { what row (row), what column (col), row-merging-row (rowspan), column-merging-column (colspan) } of each matrix point is output. And (3) giving parameter sets { row, col, rowspan, colspan } of all matrix points to merging cell (mergeCells) attributes in the ux-grid component, so as to realize merging of matrix data.
According to the embodiment of the invention, the multidimensional form is converted into the matrix data, so that the same matrix points in the matrix data are obtained and combined and grouped, and further, the combination and grouping of one whole row with more matrix data or part of parameters in one whole column are realized, the visual display of the association relation of the response data is facilitated, and the practicability of the analysis form is improved.
Based on the above embodiment, converting the combined matrix data into a table to obtain an analysis report, including:
step 510: forming the rows of the combined matrix data into the rows of the analysis report;
step 520: forming the columns of the combined matrix data into the columns of the analysis report;
step 530: and obtaining the analysis report based on the rows and columns of the analysis report.
Based on the ux-grid component, the rows in the combined matrix data are output to form the rows of the analysis report. Based on the ux-grid component, the columns of the combined matrix data are output to form the columns of the analysis report. And combining the rows and columns of the analysis report to obtain the analysis report.
The embodiment of the invention forms the analysis report based on the combined rows and columns, simplifies the content of the analysis report, and improves the practicability of the analysis report.
Based on the above embodiment, after converting the combined matrix data into a table to obtain an analysis report, the method further includes:
step 600: storing the name of the analysis report, the query condition, the response data with the combined identifier and the ID of the index board;
step 700: the analysis report is queried based on the ID of the index billboard and the name of the analysis report.
In order to improve the reusability of the analysis report, the analysis report is stored. And the screening conditions, the selection dimension, the selection index and the corresponding response data with the combined identifier selected by the user are taken as the input parameters together with the names of the analysis report forms and the IDs of the index signboards to be uploaded to the back-end server for storage. When the user wants to review the analysis report, the back-end server determines the ID of the corresponding index board according to the name of the analysis report by inputting the name of the analysis report, acquires response data associated with the ID of the index board and sends the response data to the client. And the client merges and reorganizes the response data according to the merging identifier to obtain an analysis report and displays the analysis report to the user.
Further, the xlsx component is used to download the analysis report. And processing response data associated with the analysis report into an object required by xlsx, adding a worksheet into the existing Excel workbook, writing the response data, and further downloading the analysis report.
According to the embodiment of the invention, the analysis report is stored, and when a customer needs to check the analysis report, the analysis report can be generated and obtained only by inputting the name of the analysis report, so that the analysis report can be reused.
Based on the above embodiment, determining the index signboards and the query conditions of the service data based on the query requirement information of the user includes:
step 150: determining a first interaction component of screening conditions, selecting a second interaction component of dimensions and selecting a third interaction component of indexes; the first interaction component comprises a plurality of initial screening conditions, the second interaction component comprises a plurality of initial selection dimensions, and the third interaction component comprises a plurality of initial selection indexes;
step 160: selecting initial screening conditions matched with the query requirement information in the first interaction component to obtain screening conditions;
step 170: selecting an initial selection dimension matched with the query requirement information in the second interaction component to obtain a selection dimension;
step 180: and selecting an initial selection index matched with the query requirement information in the third interaction component to obtain the index.
A component (component) is set in the configuration information of the index board, and the component content determines interaction rules of the configuration information, such as date selection, input box, drop-down selection, cascading, and the like. And directly displaying the configuration information without the interaction rule. One interaction component includes at least one interaction rule, e.g., the interaction rule of the first interaction component includes date selection, input box, drop down selection, cascade; the interaction rules of the second interaction component comprise drop-down selection and cascading; the interaction rules of the third interaction component include a drop down selection.
In the first interaction component, selecting initial screening conditions matched with the query requirement information according to interaction rules (such as input date and drop-down selection) to obtain screening conditions; in the second interaction component, selecting (for example, pull-down selection) an initial selection dimension matched with the query requirement information according to the interaction rule to obtain a selection dimension; as shown in fig. 3, in the third interaction component, an initial selection index matching the query requirement information is selected (e.g., drop-down selection) according to the interaction rule, resulting in an index.
Further, as shown in fig. 3, the first interaction component, the second interaction component and the third interaction component use the xorBy function of the Lodash library to isolate the query condition determined by the user from the unselected data.
According to the embodiment of the invention, the first interaction component, the second interaction component and the third interaction component are arranged to further determine the query condition, so that the selection dimension of a user is enriched, and the pertinence of the analysis report is further improved.
The embodiment of the invention also provides a device for generating the analysis report, as shown in fig. 5, and fig. 5 is a schematic structural diagram of the device for generating the analysis report. It should be noted that, when the generating device for an analysis report provided in the embodiment of the present invention is specifically executed, the generating method for an analysis report described in any one of the foregoing embodiments may be executed, which is not described in detail in this embodiment.
Referring to fig. 5, an embodiment of the present invention provides an apparatus for generating an analysis report, including:
a determining module 501, configured to determine an index signboard and a query condition of service data based on query requirement information of a user;
the acquisition module 502 acquires a plurality of groups of response data associated with the query condition from the index bulletin board;
a multidimensional table generating module 503, configured to generate a multidimensional table based on the response data;
the merging module 504 is configured to convert the multidimensional table into matrix data, determine the same matrix point in the matrix data, and merge the rows and columns where the same matrix point is located;
the analysis report generation module 505 is configured to convert the combined matrix data into a table, so as to obtain an analysis report.
The generating device of the analysis report provided by the embodiment of the invention determines the index signboards and the query conditions of the service data based on the query demand information of the user; acquiring a plurality of groups of response data associated with the query condition from the index billboard; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report. According to the embodiment of the invention, the response data can be acquired accurately by determining the index board and the query condition to acquire the response data. By combining the rows and columns in the matrix data and generating a final analysis report, the multi-dimensional analysis report is obtained according to the requirements of clients so as to view the data in multiple dimensions.
In one embodiment, the query criteria include a screening criteria, a selection dimension, and a selection index; the index billboard includes constituent elements, matching rules and constituent element values, and the determining module 501 is configured to: determining an index billboard matched with the query requirement information; selecting a first component element matched with the query requirement information, a first matching rule and a first component element value in the index billboard to obtain screening conditions; selecting a second component matched with the query requirement information in the index billboard to obtain a selected dimension; and selecting a third component value matched with the query requirement information and a third matching rule in the index billboard to obtain a selection index.
In one embodiment, the multi-dimensional table generation module 503 is configured to: acquiring a type value, a sorting value, an ID and a parent level ID of response data; the response data is sequenced for the first time based on the type value, and a first-level sequencing result is obtained; performing secondary sorting on the response data based on the sorting value to obtain a secondary sorting result; performing multistage sequencing on the response data based on the ID of the response data and the parent ID of the response data to obtain a multistage sequencing result; and based on the first-level sorting result, the second-level sorting result and the multi-level sorting result, sorting and combining the response data to obtain a multi-dimensional table.
In one embodiment, the merge module 504 is to: forming one row of the multi-dimensional table into one row of matrix data, forming one column of the multi-dimensional table into one column of the matrix data, and taking one parameter item in the multi-dimensional table as one matrix point in the matrix data; determining matrix points with the same value in the matrix data as the same matrix points; and merging the adjacent identical matrix points in one column of the matrix data, and merging the adjacent identical matrix points in one row of the matrix data.
In one embodiment, the analytic report generation module 505 is to: forming the rows of the combined matrix data into the rows of the analysis report; forming the columns of the combined matrix data into the columns of the analysis report; and obtaining the analysis report based on the rows and columns of the analysis report.
In one embodiment, the analysis report generation module 505 is further configured to: storing the name of the analysis report, the query condition, the response data with the combined identifier and the ID of the index board; the analysis report is queried based on the ID of the index billboard and the name of the analysis report.
In one embodiment, the determining module 501 is configured to: determining a first interaction component of screening conditions, selecting a second interaction component of dimensions and selecting a third interaction component of indexes; the first interaction component comprises a plurality of initial screening conditions, the second interaction component comprises a plurality of initial selection dimensions, and the third interaction component comprises a plurality of initial selection indexes; selecting initial screening conditions matched with the query requirement information in the first interaction component to obtain screening conditions; selecting an initial selection dimension matched with the query requirement information in the second interaction component to obtain a selection dimension; and selecting an initial selection index matched with the query requirement information in the third interaction component to obtain a selection index.
Fig. 6 is a schematic structural diagram of an electronic device according to the present invention, where the electronic device may include: processor 610, communication interface (Communications Interface) 620, memory 630, and communication bus 640, wherein processor 610, communication interface 620, and memory 630 communicate with each other via communication bus 640. The processor 610 may invoke logic instructions in the memory 630 to perform a method of generating an analytics report, the method comprising:
determining an index signboard and a query condition of service data based on query demand information of a user; acquiring a plurality of groups of response data associated with the query condition from the index billboard; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report.
Further, the logic instructions in the memory 630 may be implemented in the form of software functional units and stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the method of generating an analysis report provided by the above embodiments, the method comprising:
determining an index signboard and a query condition of service data based on query demand information of a user; acquiring a plurality of groups of response data associated with the query condition from the index billboard; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report.
In still another aspect, the present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program, which when executed by a processor is implemented to perform the method for generating an analysis report provided by the above embodiments, the method comprising:
determining an index signboard and a query condition of service data based on query demand information of a user; acquiring a plurality of groups of response data associated with the query condition from the index billboard; generating a multi-dimensional table based on the response data; converting the multidimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located; and converting the combined matrix data into a table to obtain an analysis report.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. The method for generating the analysis report is characterized by comprising the following steps of:
determining an index signboard and a query condition of service data based on query demand information of a user;
acquiring a plurality of groups of response data associated with the query condition from the index board;
generating a multi-dimensional table based on the response data;
converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located;
and converting the combined matrix data into a table to obtain an analysis report.
2. The method for generating an analysis report according to claim 1, wherein the query conditions include a screening condition, a selection dimension, and a selection index; the index signboard comprises components, matching rules and component values, and the index signboard and the query conditions of the service data are determined based on the query requirement information of the user, and the method comprises the following steps:
Determining the index signboards matched with the query requirement information;
selecting a first component element, a first matching rule and a first component element value which are matched with the query requirement information in the index billboard to obtain the screening condition;
selecting a second component matched with the query requirement information from the index board to obtain the selected dimension;
and selecting a third component value matched with the query requirement information and a third matching rule from the index billboard to obtain the selection index.
3. The method of generating an analysis report according to claim 1, wherein generating a multidimensional table based on the response data includes:
acquiring a type value, a sorting value, an ID and a parent ID of the response data;
performing first sorting on the response data based on the type value to obtain a first-stage sorting result;
performing secondary sorting on the response data based on the sorting value to obtain a secondary sorting result;
performing multistage sorting on the response data based on the ID of the response data and the parent ID of the response data to obtain a multistage sorting result;
and based on the primary sorting result, the secondary sorting result and the multi-stage sorting result, sorting and combining the response data to obtain the multi-dimensional table.
4. The method for generating an analysis report according to claim 1, wherein the converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data, and merging the rows and columns where the same matrix point is located, includes:
forming one row of the multi-dimensional table into one row of the matrix data, forming one column of the multi-dimensional table into one column of the matrix data, wherein one parameter item in the multi-dimensional table is one matrix point in the matrix data;
determining matrix points with the same value in the matrix data as the same matrix points;
and merging the same adjacent matrix points in one column of the matrix data, and merging the same adjacent matrix points in one row of the matrix data.
5. The method for generating an analysis report according to claim 1, wherein the converting the combined matrix data into a table to obtain the analysis report comprises:
combining the rows of the matrix data to form the rows of the analysis report;
forming the columns of the combined matrix data into the columns of the analysis report;
and obtaining the analysis report based on the rows and columns of the analysis report.
6. The method for generating an analysis report according to claim 1, wherein after converting the combined matrix data into a table to obtain the analysis report, further comprising:
storing the name of the analysis report, the query condition, the response data with the combined identifier and the ID of the index signboard;
and inquiring the analysis report based on the ID of the index board and the name of the analysis report.
7. The method for generating an analysis report according to claim 2, wherein determining the index bulletin board and the query condition of the business data based on the query demand information of the user comprises:
determining a first interaction component of the screening condition, a second interaction component of the selection dimension and a third interaction component of the selection index; wherein the first interaction component comprises a plurality of initial screening conditions, the second interaction component comprises a plurality of initial selection dimensions, and the third interaction component comprises a plurality of initial selection indexes;
selecting the initial screening condition matched with the query requirement information in the first interaction component to obtain the screening condition;
selecting the initial selection dimension matched with the query requirement information in the second interaction component to obtain the selection dimension;
And selecting the initial selection index matched with the query requirement information in the third interaction component to obtain the selection index.
8. An analysis report generating device, comprising:
the determining module is used for determining an index signboard and a query condition of the service data based on the query demand information of the user;
the acquisition module is used for acquiring a plurality of groups of response data associated with the query condition from the index billboard;
the multidimensional form generating module is used for generating a multidimensional form based on the response data;
the merging module is used for converting the multi-dimensional table into matrix data, determining the same matrix point in the matrix data and merging the row and the column where the same matrix point is located;
and the analysis report generation module is used for converting the combined matrix data into a table so as to obtain an analysis report.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method of generating an analysis report according to any one of claims 1 to 7 when the computer program is executed by the processor.
10. A non-transitory computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when executed by a processor, implements the steps of the method of generating an analysis report according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311393212.6A CN117669514A (en) | 2023-10-25 | 2023-10-25 | Method and device for generating analysis report, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311393212.6A CN117669514A (en) | 2023-10-25 | 2023-10-25 | Method and device for generating analysis report, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117669514A true CN117669514A (en) | 2024-03-08 |
Family
ID=90074205
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311393212.6A Pending CN117669514A (en) | 2023-10-25 | 2023-10-25 | Method and device for generating analysis report, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117669514A (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-10-25 CN CN202311393212.6A patent/CN117669514A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118227674A (en) * | 2024-05-22 | 2024-06-21 | 江苏中仑数字科技有限公司 | Report generation method and device and electronic equipment |
| CN118227674B (en) * | 2024-05-22 | 2024-10-18 | 江苏中仑数字科技有限公司 | Report generation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111401777B (en) | Enterprise risk assessment method, enterprise risk assessment device, terminal equipment and storage medium | |
| US8793567B2 (en) | Automated suggested summarizations of data | |
| CN110532309B (en) | Generation method of college library user portrait system | |
| Stavroulakis et al. | Situation analysis forecasting: the case of European maritime clusters | |
| CN113761334A (en) | Visual recommendation method, device, equipment and storage medium | |
| CN101452487B (en) | Data loading method and system, and data loading unit | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| US10067964B2 (en) | System and method for analyzing popularity of one or more user defined topics among the big data | |
| CN110781251A (en) | Insurance knowledge map generation method, device, equipment and storage medium | |
| CN104364781A (en) | Systems and methods for calculating category proportions | |
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| CN104951843B (en) | Method for Sales Forecast system and method | |
| CN110728123A (en) | Report generation method, system and related equipment | |
| CN117669514A (en) | Method and device for generating analysis report, electronic equipment and storage medium | |
| CN106528511A (en) | Form analysis method and device | |
| CN117454188A (en) | Multi-strategy data governance rule adaptation method and system based on standard data elements | |
| CN115422903A (en) | Report output method and device, electronic equipment and computer readable storage medium | |
| KR20200020932A (en) | Analysis Support Methods, Analysis Support Servers and Storage Media | |
| CN112732891B (en) | Office course recommendation method, device, electronic equipment and medium | |
| US11568177B2 (en) | Sequential data analysis apparatus and program | |
| US20180357227A1 (en) | System and method for analyzing popularity of one or more user defined topics among the big data | |
| CN113592606A (en) | Product recommendation method, device, equipment and storage medium based on multiple decisions | |
| CN114169940A (en) | Business opportunity mining system based on business opportunity service information processing | |
| CN112561277A (en) | City credit index calculation system, city credit index calculation method, electronic device, and storage medium | |
| Yue et al. | Enabling and analyzing how to efficiently extract information from hybrid long documents with llms |
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 |