CN108415917B - Visual report generation method and visual report generation device - Google Patents
Visual report generation method and visual report generation device Download PDFInfo
- Publication number
- CN108415917B CN108415917B CN201710146322.0A CN201710146322A CN108415917B CN 108415917 B CN108415917 B CN 108415917B CN 201710146322 A CN201710146322 A CN 201710146322A CN 108415917 B CN108415917 B CN 108415917B
- Authority
- CN
- China
- Prior art keywords
- information
- sub
- preset
- report
- model
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention discloses a method for generating a visual report, which comprises the following steps: detecting whether year information input by a user is received; if so, judging whether the years contained in the year information are preset years or not; if yes, determining a fund risk model corresponding to the year information according to the year information and a preset corresponding relation, wherein the fund risk model comprises a preset number of sub-models which display fund risk information of a plurality of service points from different dimensions; generating a calling instruction according to the dimension information of the sub-model; acquiring data information of a service point matched with the dimension information of the submodel according to the calling instruction; generating a sub-report according to the configuration information of the sub-model and the corresponding data information; and correspondingly displaying the sub-report in a preset area on a terminal page. The embodiment of the invention also discloses a device for generating the visual report. The embodiment of the invention can improve the generation efficiency of the visual report and realize the multi-party linkage of the visual report.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for generating a visual report.
Background
At present, various data information is presented to a user in a visual manner of a data report through intelligent devices such as a computer, a server, and a mobile terminal, so that the user can intuitively and quickly master the data information. For example, enterprise managers can know the completion conditions of various task indexes of the enterprises according to the report data so as to find problems in time, adjust the operation direction, make measures and improve the operation management level and the like. However, the problems of long time consumption and low generation efficiency exist in the generation process of the existing visual report, and the existing report cannot realize linkage comparison of a plurality of reports, so that the use experience of a user is reduced.
Disclosure of Invention
The embodiment of the invention provides a method and a device for generating a visual report, which can improve the generation efficiency of the visual report and realize multi-party linkage of the visual report so as to improve the use experience of a user.
In one aspect, an embodiment of the present invention provides a method for generating a visual report, where the method includes: detecting whether year information input by a user is received; if so, judging whether the years contained in the year information are preset years or not; if yes, determining a fund risk model corresponding to the year information according to the year information and a preset corresponding relation, wherein the fund risk model comprises a preset number of sub-models which display fund risk information of a plurality of service points from different dimensions; generating a calling instruction according to the dimension information of the sub-model; acquiring data information of a service point matched with the dimension information of the submodel according to the calling instruction; generating a sub-report according to the configuration information of the sub-model and the corresponding data information; and correspondingly displaying the sub-report in a preset area on a terminal page.
On the other hand, the embodiment of the invention provides a device for generating a visual report, which comprises a detection unit, a display unit and a display unit, wherein the detection unit is used for detecting whether year information input by a user is received; the fund risk model comprises a judging unit, a determining unit and a corresponding relation determining unit, wherein the judging unit is used for judging whether the years contained in the year information are preset years or not if the years contained in the year information are preset years, the determining unit is used for determining a fund risk model corresponding to the year information according to the year information and a preset corresponding relation, the preset corresponding relation is the corresponding relation between the year information and the fund risk model, and the fund risk model comprises a preset number of submodels for displaying fund risk information of a plurality of service points from different dimensions; the first generation unit is used for generating a calling instruction according to the dimension information of each submodel; the acquisition unit is used for acquiring data information matched with the dimension information of each sub-model according to the calling instruction; the second generation unit is used for generating a sub-report according to the configuration information of the sub-model and the corresponding data information; and the display unit is used for correspondingly displaying the sub-report in a preset area on a terminal page.
The embodiment of the invention corresponds the year information and the capital risk model so as to determine the corresponding capital risk model and the corresponding sub-model according to the year information input by the user, then generates a calling instruction according to the dimension information of each sub-model, such as capital inspection problem quantity distribution or capital inspection item ratio, and the like so as to obtain the corresponding data information according to the calling instruction, then generates the corresponding sub-report according to the configuration information and the data information of each sub-model, and correspondingly displays the generated sub-report in the preset area on the terminal page. The embodiment of the invention takes the year information and the dimension information of the submodel as the selection conditions for screening the data information from the plurality of service points, thereby reducing the workload of acquiring the data information, improving the data acquisition speed and further improving the generation efficiency of the visual report. Meanwhile, the generated sub-reports are correspondingly displayed in the preset area on the terminal page, so that linkage comparison of a plurality of visual reports is realized, and after the user changes the year information, the visual reports corresponding to the sub-reports are displayed in the preset area in the terminal page, so that the user can conveniently compare different dimension information, and further the user experience is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flowchart of a method for generating a visual report according to an embodiment of the present invention;
FIG. 2 is a schematic sub-flow chart of step S103 in FIG. 1;
FIG. 3 is a schematic sub-flow chart of step S107 in FIG. 1;
FIG. 4 is a diagram of a visual report according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of another visual report provided by the embodiment of the invention;
FIG. 6 is a schematic block diagram of a generation apparatus for a visual report according to an embodiment of the present invention;
FIG. 7 is a schematic block diagram of the determination unit of FIG. 6;
fig. 8 is a schematic block diagram of the display unit in fig. 6.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
Fig. 1 is a schematic flow chart of a method for generating a visual report according to an embodiment of the present invention. The visual report is used for visually displaying the fund risk information of different service points. As shown in the figure, the method for generating the visual report comprises steps S101-S107.
S101, detecting whether year information input by a user is received.
Specifically, the year information means a certain year or a certain number of years. When the user wants to check the fund risk information of each service point for a certain year or a certain number of years, the corresponding year information for the certain year or the certain number of years may be input, for example, the year information may be input through a keyboard or the year information to be checked may be selected through a pull-down menu, and the input mode of the year information is not limited herein. In the embodiment of the present invention, if the year information input by the user is detected, step S102 is executed. If the year information input by the user is not detected, the step S101 is continuously executed.
And S102, judging whether the year contained in the year information is a preset year or not.
Specifically, the preset year refers to a year having the capital risk information. When it is detected that the user inputs the year information, determining whether the years included in the year information are preset years, and executing step S103 when the years included in the year information are all preset years; when the year information includes a year other than the preset year, the process may be ended or the fund risk information corresponding to the year included in the preset year may be displayed, which is not limited herein.
S103, determining a fund risk model corresponding to the year information according to the year information and a preset corresponding relation, wherein the fund risk model comprises a preset number of sub-models which display fund risk information of a plurality of service points from different dimensions.
Specifically, in the embodiment of the present invention, the fund risk model is to present fund risk data of different service points in a set data format for the user to visually view and compare. Each of the fund risk models corresponds to a data format. In the embodiment of the invention, the preset corresponding relation is set between the year information and the fund risk model so as to realize that different year information corresponds to different fund risk models. Such as may correspond a particular year in the year information to the fund risk model. E.g., 2015 for one fund risk model, 2016 for another fund risk model, etc. Referring to FIG. 2, in other embodiments, step S103 includes steps S201-S202.
S201, counting the number of years contained in the year information, wherein different numbers of years correspond to different fund risk models.
And S202, searching a corresponding fund risk model according to the number of years and a preset corresponding relation.
Specifically, the number of years included in the year information is associated with the fund risk model. The current year information includes individual years, such as 2015, corresponding to a first fund risk model; the year information includes two years, such as 2015 and 2016, corresponding to a second fund risk model that may set a comparison graph of 2015 and 2016 related data information for more intuitive viewing by the user. When the year information includes three years, a third fund risk model is corresponded. And by analogy, the method realizes the correspondence with different fund risk models according to the number of the years contained in the year information.
In order to display the fund risk information of a plurality of service points from different dimensions, the fund risk model comprises a preset number of sub models, each self model corresponds to one dimension information, and preferably each self model corresponds to a separate data format. The preset number corresponds to different dimensions, and each submodel is used for displaying one dimension information of the fund risk information. The dimension information can be one of the whole distribution of the capital inspection problems, the quantity distribution of the capital inspection problems, the occupation ratio of the capital inspection items, the capital risk evaluation and the capital inspection type distribution, and each sub-model displays the capital risk condition of each service point according to the corresponding format and the preset dimension. It is to be understood that the dimension information is not limited thereto. The data format can be sector graph, bar graph, line graph, etc. It should be noted that each sub-model showing the same dimensional information in different fund risk models may be different or partially the same.
And S104, generating a calling instruction according to the dimension information of the sub-model.
Specifically, the call instruction is an SQL instruction. After the fund risk model is determined according to step S103, the sub-models included therein are also correspondingly determined. Each sub-model contains dimension information and configuration information. The dimensional information may be one of a capital review problem overall distribution, a capital review problem quantity distribution, a capital review item proportion, a capital risk assessment, and a capital review type distribution. The configuration information comprises attribute information and display configuration information. The display configuration information may be "report type", "display type", and "support terminal", and the attribute information may be "X-axis column name", "Y-axis column name", "Z-axis column name", "data precision", "X-axis name", "Y-axis name", and the like. It should be noted that the call instruction includes an instruction generated according to the dimension information corresponding to each sub-model in the fund risk model.
And S105, acquiring data information of the service point matched with the dimension information of the sub-model according to the calling instruction.
Specifically, after a call instruction is generated according to the dimension information of the submodel, the data information of the service point matched with the dimension information of the submodel is acquired according to the call instruction. If the year information is the year of a certain year, the corresponding fund risk model comprises four sub-models, the dimension information of the first sub-model is the whole fund check problem distribution, the dimension information of the second sub-model is the fund check problem quantity distribution, the dimension information of the third sub-model is the fund check item proportion, the dimension information of the fourth sub-model is the fund risk evaluation, and after a calling instruction is generated according to the respective corresponding dimension information of the four sub-models, corresponding data information needs to be acquired from each service point according to the corresponding instruction.
And S106, generating a sub-report according to the configuration information of the sub-model and the corresponding data information.
Specifically, after data information corresponding to each submodel is acquired, configuration information that cooperates with the data information needs to be set. The configuration information is mainly used for setting a data format corresponding to each sub-model. As described above, the configuration information includes attribute information and presentation configuration information. The display configuration information can be a report type, a display type, a support terminal and the like; the attribute information may be "X-axis column name", "Y-axis column name", "Z-axis column name", "data accuracy", "X-axis name", and "Y-axis name", and the like. It should be noted that, because the data formats corresponding to each submodel are different, after the configuration information is set for the acquired data information, a sub-report corresponding to the data format is generated according to the configuration information of the submodel and the corresponding data information.
In some other embodiments, the step of generating the sub-report according to the configuration information of the sub-model and the corresponding data information specifically includes: generating corresponding sub-report data according to the attribute information of the sub-model and the data information; and generating a corresponding sub-report according to the display configuration information of the sub-model and the corresponding sub-report data.
And S107, correspondingly displaying the sub-report in a preset area on a terminal page.
Specifically, the terminal page is divided into a plurality of preset areas, and the preset areas are used for displaying the generated sub-reports. One sub-report may be displayed in one preset area, or two or more sub-reports may be displayed in one preset area according to specific settings, which is not limited herein. In some preferred embodiments, each preset area has identification information corresponding to dimension information of at least one sub-model, and referring to fig. 3, step S107 specifically includes steps S301 to S302.
S301, distributing the sub-report to a corresponding preset area according to the corresponding relation between the dimension information and the identification information.
Specifically, each preset area corresponds to the dimension information of at least one sub-model, that is, one preset area corresponds to at least one sub-report. In the specific implementation, the identification information of the preset area is compared with the dimension information of the submodel, and the sub-report of the submodel with the matched sub-dimension information and the identification information of the preset area is distributed to the corresponding preset area. It can be understood that, as a display result on the terminal page, one sub-report can be displayed in one preset area or a plurality of sub-reports can be correspondingly displayed in one preset area.
And S302, sequentially displaying the sub-reports in the corresponding preset areas according to a preset display sequence.
Specifically, the preset display sequence may be to display all the sub-reports in the corresponding preset area at the same time, or display all the sub-reports in the corresponding preset area according to a preset time interval sequence, which is not limited herein. It can be understood that, as a display result on the terminal page, one sub-report can be displayed in one preset area or a plurality of sub-reports can be correspondingly displayed in one preset area.
The embodiment of the invention corresponds the year information and the capital risk model so as to determine the corresponding capital risk model and the corresponding sub-model according to the year information input by the user, then generates a calling instruction according to the dimension information of each sub-model, such as capital inspection problem quantity distribution or capital inspection item ratio, and the like so as to obtain the corresponding data information according to the calling instruction, then generates the corresponding sub-report according to the configuration information and the data information of each sub-model, and correspondingly displays the generated sub-report in the preset area on the terminal page. The embodiment of the invention takes the year information and the dimension information of the submodel as the selection conditions for screening the data information from the plurality of service points, thereby reducing the workload of acquiring the data information, improving the data acquisition speed and further improving the generation efficiency of the visual report. Meanwhile, the generated sub-reports are displayed in the preset area on the terminal page in the corresponding display sequence, so that linkage comparison of a plurality of visual reports is realized, and after the user changes the year information, the visual reports corresponding to the sub-reports are displayed in the preset area in the terminal page, so that the user can conveniently compare information with different dimensions, and the user experience is improved.
Fig. 4 is a schematic diagram of a visual report according to an embodiment of the present invention. As shown in the figure, the visual report is used for displaying the fund risk condition of each service point nationwide in 2015. As can be seen from the figure, the terminal page is divided into 4 preset regions, and the fund risk model corresponding to 2015 includes 5 sub-models. The first preset area corresponds to the first sub-model and is used for displaying the whole situation distribution of the fund checking problem; the first preset area corresponds to the second submodel and the third submodel and is used for displaying the capital risk evaluation condition and the capital inspection type distribution condition; the third preset area corresponds to the fourth submodel and is used for displaying the distribution condition of the quantity of the capital inspection problems; the fourth preset area corresponds to the fifth submodel and is used for displaying the fund checking proportion condition.
Specifically, the first sub-model shows the overall distribution of the fund check problems of each service point in a Chinese map form. Because the service points are distributed in different provinces, and a plurality of service points may exist in the same province, in order to more intuitively display the overall situation distribution of the fund check problem of each service point, the province where the service points are located can be identified in different colors according to the high and low sequence of the fund risk level corresponding to each service point. The rank of the fund risk level corresponding to each business point may be counted according to the existing fund check problem and the corresponding scoring rule, which is not specifically limited herein. After the overall distribution situation of the fund check problems corresponding to all business points in the country is displayed in the first preset area in the form of the Chinese map corresponding to the first sub-model, a user can clearly and quickly master the distribution situation of the fund check existing in each business point. The second sub-model shows the overall evaluation condition of the fund risk of each business point in the country in the form of a sector graph. The proportion sizes corresponding to high risk, medium risk and low risk in the sector graph can be obtained by counting the fund risk level in different service points. And the third sub-model shows the fund check type distribution situation adopted by each service point in the form of a piece model graph. The fund inspection types comprise six inspection types of on-site inspection, off-site inspection, fund self-inspection, special inspection, cash risk investigation, counter cashier audit and fund self-inspection. Different service points can adopt different fund check types according to the actual conditions of the service points. And displaying the capital risk evaluation condition of each service point through a sector in a second preset area, and displaying the capital inspection type distribution condition adopted by different service points through a piece of pattern diagram, thereby facilitating the capital risk condition and the capital inspection type distribution condition corresponding to a plurality of service points of a user. And the fourth sub-model displays the fund check problem quantity distribution condition of the province where each service point is located by a histogram. The user can intuitively master the fund checking problem quantity distribution condition corresponding to the province where each service point is located through the columnar body. And the fifth sub-model displays the fund check item ratio corresponding to each business point by an area diagram. The fund checking items comprise fund receipt and payment, training instruction, account management, POS machine related management, checking work management, seal management, reserve fund management, cash management and the like. The sub-reports corresponding to the first sub-model to the fifth sub-model are correspondingly displayed in the first preset area to the fourth preset area respectively, so that the function of linkage comparison of the plurality of visual reports is realized, and the user experience is improved.
Fig. 5 is a schematic diagram of another visual report according to an embodiment of the present invention. As shown, the visual report is used to display the capital risk status for two years 2015 and 2016. Since the number of years is two years, the corresponding fund risk model is different from the fund risk model corresponding to one year in fig. 4. As shown in the figure, the evaluation of the capital risk in the second preset area includes comparing the capital risk levels in two years of 2015 and 2016, and the distribution of the quantity of the capital inspection problems in the third preset area is used for counting the ratio of the quantity of the high risk, the medium risk and the low risk in the quantity of the capital inspection problems in the provinces where different business points are located in 2015 and 2016. Since the first preset area and the fourth preset area are the same as those in fig. 4, the details are not repeated here. As can be seen from fig. 5, different year information corresponds to different fund risk models, and the fund risk status in the selected year information is further shown by the respective sub-models of the fund risk model.
Referring to fig. 6, a schematic block diagram of an apparatus according to an embodiment of the present invention is shown. The apparatus 40 in the present embodiment as shown in the figure includes a detection unit 41, a judgment unit 42, a determination unit 43, a first generation unit 44, an acquisition unit 45, a second generation unit 46, and a display unit 47.
A detecting unit 41 for detecting whether the year information input by the user is received.
A determining unit 42, configured to determine whether the year included in the year information is a preset year if the year is received.
A determining unit 43, configured to determine, if a year included in the year information is a preset year, a fund risk model corresponding to the year information according to the year information and a preset corresponding relationship, where the fund risk model includes a preset number of sub-models that show fund risk information of multiple service points from different dimensions.
And the first generating unit 44 is configured to generate a call instruction according to the dimension information of each sub-model.
And the obtaining unit 45 is configured to obtain, according to the call instruction, data information matched with the dimension information of each sub-model.
And a second generating unit 46, configured to generate a sub-report according to the configuration information of the sub-model and the corresponding data information.
And the display unit 47 is used for correspondingly displaying the sub-report in a preset area on a terminal page.
Further, referring to fig. 7, it is a schematic structural diagram of the determination unit in fig. 6. As shown, the determining unit 43 includes a counting unit 431 and a searching unit 432.
A statistic unit 431, configured to count the number of years included in the year information, where different numbers of years correspond to different fund risk models.
A searching unit 432, configured to search a corresponding fund risk model according to the number of years.
Further, fig. 8 is a schematic structural diagram of the display unit in fig. 6. As shown, the display unit 47 includes a distribution unit 471 and a display unit 472.
The allocating unit 471 is configured to allocate the sub-report to a corresponding preset area according to the corresponding relationship between the dimension information and the identification information. Specifically, each preset area corresponds to the dimension information of at least one sub-model, that is, one preset area corresponds to at least one sub-report.
The display unit 472 is configured to sequentially display the sub-reports in the corresponding preset areas according to a preset display order.
The embodiment of the invention corresponds the year information and the capital risk model so as to determine the corresponding capital risk model and the corresponding sub-model according to the year information input by the user, then generates a calling instruction according to the dimension information of each sub-model, such as capital inspection problem quantity distribution or capital inspection item ratio, and the like so as to obtain the corresponding data information according to the calling instruction, then generates the corresponding sub-report according to the configuration information and the data information of each sub-model, and correspondingly displays the generated sub-report in the preset area on the terminal page. The embodiment of the invention takes the year information and the dimension information of the submodel as the selection conditions for screening the data information from the plurality of service points, thereby reducing the workload of acquiring the data information, improving the data acquisition speed and further improving the generation efficiency of the visual report. Meanwhile, the generated sub-reports are displayed in the preset area on the terminal page in the corresponding display sequence, so that linkage comparison of a plurality of visual reports is realized, and after the user changes the year information, the visual reports corresponding to the sub-reports are displayed in the preset area in the terminal page, so that the user can conveniently compare information with different dimensions, and the user experience is improved.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the terminal and the unit described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed terminal and method can be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, device apparatuses or units, and may also be an electrical, mechanical or other form of connection.
It will be understood by those skilled in the art that all or part of the steps of the method implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc. Moreover, the steps in the method according to the above embodiment of the present invention may be sequentially adjusted, combined, and deleted according to actual needs.
The units in the terminal of the embodiment of the invention can be merged, divided and deleted according to actual needs.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a terminal, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above are preferred embodiments of the invention and are not intended to limit the invention in any way. Various equivalent changes and modifications can be made by those skilled in the art based on the above-described embodiments, and all equivalent changes and modifications within the scope of the claims should be considered as falling within the scope of the present invention.
Claims (10)
1. A method for generating a visual report is characterized by comprising the following steps: detecting whether year information input by a user is received;
if so, judging whether the years contained in the year information are preset years or not;
if yes, determining a fund risk model corresponding to the year information according to the year information and a preset corresponding relation, wherein the fund risk model comprises a preset number of sub-models which display fund risk information of a plurality of service points from different dimensions;
generating a calling instruction according to the dimension information of the sub-model, wherein the calling instruction is an SQL instruction;
acquiring data information of a service point matched with the dimension information of the submodel according to the calling instruction;
generating a sub-report according to the configuration information of the sub-model and the corresponding data information;
and correspondingly displaying the sub-report in a preset area on a terminal page.
2. The method according to claim 1, wherein the determining a fund risk model corresponding to the year information according to the year information and a preset correspondence specifically comprises:
counting the number of years contained in the year information, wherein different numbers of years correspond to different fund risk models;
and searching a corresponding fund risk model according to the number of years and a preset corresponding relation.
3. The method of claim 1, wherein the configuration information includes attribute information and presentation configuration information, and the generating a sub-report according to the configuration information of the sub-model and the corresponding data information specifically includes:
generating corresponding sub-report data according to the attribute information of the sub-model and the data information;
and generating the corresponding sub-report according to the display configuration information of the sub-model and the corresponding sub-report data.
4. The method of claim 1, wherein the dimensional information is one of a capital inspection problem overall distribution, a capital inspection problem quantity distribution, a capital inspection item proportion, a capital risk assessment, and a capital inspection type distribution.
5. The method according to claim 1, wherein the terminal page is divided into a plurality of preset areas, each preset area has identification information, the identification information corresponds to the dimension information of at least one of the submodels, and the correspondingly displaying the sub-report in the preset area on the terminal page specifically comprises:
distributing the sub-report to a corresponding preset area according to the corresponding relation between the dimension information and the identification information;
and sequentially displaying the sub-reports in the corresponding preset areas according to a preset display sequence.
6. An apparatus for generating a visual report, comprising:
a detecting unit for detecting whether year information input by a user is received,
the device comprises a judging unit, a judging unit and a judging unit, wherein the judging unit is used for judging whether the years contained in the year information are preset years or not if the year information input by a user is received;
a determining unit, configured to determine, if a year included in the year information is a preset year, a fund risk model corresponding to the year information according to the year information and a preset corresponding relationship, where the fund risk model includes a preset number of sub-models that show fund risk information of a plurality of service points from different dimensions,
the first generation unit is used for generating a calling instruction according to the dimension information of each sub-model, wherein the calling instruction is an SQL instruction;
the acquisition unit is used for acquiring data information matched with the dimension information of each sub-model according to the calling instruction;
the second generation unit is used for generating a sub-report according to the configuration information of the sub-model and the corresponding data information;
and the display unit is used for correspondingly displaying the sub-report in a preset area on a terminal page.
7. The apparatus according to claim 6, wherein the determining unit specifically includes:
the statistical unit is used for counting the number of years contained in the year information, and different numbers of years correspond to different fund risk models;
and the searching unit is used for searching the corresponding fund risk model according to the number of years and the preset corresponding relation.
8. The apparatus according to claim 6, wherein the configuration information includes attribute information and presentation configuration information, and the second generating unit is specifically configured to generate corresponding sub-report data according to the attribute information of the sub-model and the data information, and generate the corresponding sub-report according to the presentation configuration information of the sub-model and the corresponding sub-report data.
9. The apparatus of claim 6, wherein the dimensional information is one of a capital check problem, a capital check item, a capital risk level, and a capital check type for each business point.
10. The apparatus of claim 6, wherein the terminal page is divided into a plurality of preset regions, each of the preset regions has identification information, and the display unit specifically includes, corresponding to the dimension information of at least one of the submodels:
the distribution unit is used for distributing the sub-report to a corresponding preset area according to the corresponding relation between the dimension information and the identification information;
and the display unit is used for sequentially displaying the sub-reports in the corresponding preset areas according to a preset display sequence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710146322.0A CN108415917B (en) | 2017-03-13 | 2017-03-13 | Visual report generation method and visual report generation device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710146322.0A CN108415917B (en) | 2017-03-13 | 2017-03-13 | Visual report generation method and visual report generation device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108415917A CN108415917A (en) | 2018-08-17 |
| CN108415917B true CN108415917B (en) | 2021-01-15 |
Family
ID=63125370
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710146322.0A Active CN108415917B (en) | 2017-03-13 | 2017-03-13 | Visual report generation method and visual report generation device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108415917B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109784641A (en) * | 2018-12-13 | 2019-05-21 | 深圳壹账通智能科技有限公司 | Data-pushing device, equipment, method and readable storage medium storing program for executing |
| CN110851173B (en) * | 2019-11-18 | 2023-11-14 | 中国银行股份有限公司 | Report generation method and device |
| CN111652747B (en) * | 2020-05-29 | 2023-08-29 | 泰康保险集团股份有限公司 | Electronic policy processing method, device, equipment and computer readable storage medium |
| CN112651619A (en) * | 2020-12-22 | 2021-04-13 | 上海哔哩哔哩科技有限公司 | Business-oriented wind control method and device |
| CN112905593B (en) * | 2021-03-04 | 2024-02-02 | 天九共享网络科技集团有限公司 | Report generation method, report generation device, report generation medium and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136445A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Method for converting openEHR information into relational database |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| US9495437B1 (en) * | 2013-11-06 | 2016-11-15 | Dell Software Inc. | System and method for accessing dimensional databases |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9361429B2 (en) * | 2012-06-08 | 2016-06-07 | Liposcience, Inc. | Multi-parameter diabetes risk evaluations |
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN104317923A (en) * | 2014-10-31 | 2015-01-28 | 国家电网公司华北分部 | Method for presenting multi-dimensional data of regulation and control integrated systems of power grids |
| CN104866599B (en) * | 2015-06-01 | 2018-06-05 | 北京京东尚科信息技术有限公司 | The production method and system of Visual Report Forms |
| CN105894125A (en) * | 2016-04-22 | 2016-08-24 | 牛东晓 | Transmission and transformation project cost estimation method |
| CN106055565A (en) * | 2016-05-18 | 2016-10-26 | 广东源恒软件科技有限公司 | Method and device for generating tax affair report |
-
2017
- 2017-03-13 CN CN201710146322.0A patent/CN108415917B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136445A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Method for converting openEHR information into relational database |
| US9495437B1 (en) * | 2013-11-06 | 2016-11-15 | Dell Software Inc. | System and method for accessing dimensional databases |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
Non-Patent Citations (1)
| Title |
|---|
| EDA海量数据查询和报表性能优化;陈雪梅;《广东通信技术》;20140615(第06(2014)期);65-67 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108415917A (en) | 2018-08-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108415917B (en) | Visual report generation method and visual report generation device | |
| US7797356B2 (en) | Dynamically detecting exceptions based on data changes | |
| CN110716966B (en) | Data visualization processing method and system, electronic device and storage medium | |
| CN111125560A (en) | Data visualization processing method and device and computer system | |
| EP2866168A1 (en) | Calibration of strategies for fraud detection | |
| CN106528511B (en) | Form analysis method and device | |
| CN111125266A (en) | Data processing method, device, equipment and storage medium | |
| CN110246002A (en) | Method for pushing, device and the computer equipment of financing recommendation information | |
| CN106779999A (en) | Financial situation identification and device | |
| WO2019019789A1 (en) | Parameter value calculation method and apparatus, storage medium and computer device | |
| EP3759665A1 (en) | Multi-dimensional organization of data for efficient analysis | |
| CN105608151A (en) | Financial statement analysis device and method | |
| CN117056352A (en) | Data display method, device, terminal equipment and readable storage medium | |
| CN112508119A (en) | Feature mining combination method, device, equipment and computer readable storage medium | |
| JPH11175602A (en) | Credit risk measurement device | |
| JP2013218607A (en) | Software quality evaluation apparatus, software quality evaluation method and program | |
| CN111523764A (en) | Business architecture detection method, device, tool, electronic equipment and medium | |
| CN115545791A (en) | Guest group portrait generation method and device, electronic equipment and storage medium | |
| CN116610583A (en) | SCA tool maturity evaluation method, SCA tool maturity evaluation device, SCA tool maturity evaluation equipment, SCA tool maturity evaluation medium and SCA tool maturity evaluation product | |
| CN110111201A (en) | A kind of credit line management method, device, system and recording medium | |
| CN113837615A (en) | Index data acquisition method, device, electronic device and readable storage medium | |
| CN114490406A (en) | Test coverage item management method, device, equipment and medium | |
| CN113792961A (en) | Audit decision-making method and equipment for Renzhong economic responsibility based on audit big data | |
| CN117194704B (en) | Method, device and equipment for inquiring attribute of component-level live-action three-dimensional model | |
| CN112699014A (en) | Method and device for testing and displaying storage performance prediction function |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |