CN103729713A - Audit result display configuration method and device - Google Patents
Audit result display configuration method and device Download PDFInfo
- Publication number
- CN103729713A CN103729713A CN201310549411.1A CN201310549411A CN103729713A CN 103729713 A CN103729713 A CN 103729713A CN 201310549411 A CN201310549411 A CN 201310549411A CN 103729713 A CN103729713 A CN 103729713A
- Authority
- CN
- China
- Prior art keywords
- monitoring entity
- data
- check
- checking
- attribute
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an audit result display configuration method and device. The method includes the following steps of firstly, setting up a monitoring entity corresponding to a data list to be monitored in a database, configuring a related mapping relation between properties of the monitoring entity and list information in the data list, and obtaining data in the database through the monitoring entity; secondly, setting up a report form corresponding to the monitoring entity to be used for monitoring display of an audit result of the monitoring entity; thirdly, selecting properties to be displayed from the properties of the monitoring entity to serve as a report form list of the report form, and displaying data corresponding to the selected properties in the audit result; fourthly, setting up an audit rule for searching the monitoring entity for data; fifthly, conducting setting according to the execution condition of the audit rule; sixthly, searching the monitoring entity for data according to the audit rule; seventhly, returning data which conform to the audit rule after audit item execution is completed, and displaying the data which conform to the audit rule according to a set report form format. By means of the audit result display configuration method and device, the data display format of the audit result can be flexibly adjusted.
Description
Technical field
The invention belongs to enterprise information management system technical field, more particularly, relate to a kind of displaying collocation method and device of checking result data.
Background technology
The data of information management system or business are checked in demonstrating data result and are had the following disadvantages in the market: when representing and check result data, represent form, display field relatively fixing, if need to change, represent form, need to re-start exploitation, very flexible; Next is that the graphic analyses function of checking result realizes separately as general function, owing to need to taking into account different business datums, so will refine these data when analyzing, to reach general object, but the information dropout that so also can cause some special business datums, analysis result is not accurate enough.
Summary of the invention
The object of this invention is to provide and a kind ofly can make the result of graphic analyses can reflect accurately data to checking that the data exhibiting form of result carries out displaying collocation method and the device adjusted flexibly, assisted user be analyzed and decision-making better.
To achieve these goals, the present invention takes following technical solution:
The displaying collocation method of checking result, comprises the following steps:
Monitoring entity foundation step, creates the monitoring entity corresponding with the tables of data that needs monitoring in database, and the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data are obtained data in database by monitoring entity;
Monitoring entity form foundation step, creates the form corresponding with monitoring entity, for the displaying of checking result of monitoring entity;
Monitoring entity form setting steps selects to need the attribute of showing as the form row in form from the attribute of monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result;
Check regular setting steps, check that rule is for searching data at monitoring entity;
Check project setting steps, to checking that regular implementation status arranges;
Check project implementation step, data based in monitoring entity checked to rule searches;
Check that result shows step, after checking that the project implementation completes, return to meet and check regular data, and to meeting, check that regular data show by the report tableau format setting.
The attribute of monitoring entity of the present invention comprises Chinese, Property Name, attribute type, attribute specification and length.
Monitoring entity of the present invention can be corresponding with the one or more tables of data in database.
The report tableau format creating in monitoring entity form foundation step of the present invention comprises single table, biserial, boss's list and list row figure.
In monitoring entity form setting steps of the present invention, to row display Name, alignment thereof, width in form, font format arranges.
When statement form of the present invention is list row figure, whether monitoring entity form setting steps also comprises graph style, theme, X-axis data rows, Y-axis data rows, data source and supports 3D demonstration to arrange.
Of the present inventionly check that regular content comprises rule name, checks main points, checks item and checks expression formula.
Content of checking project of the present invention comprises the cycle, the unit of checking, the audited unit that check rule and carry out, checks object and check item.
The displaying inking device of checking result, comprising:
Monitoring entity creating unit, for creating the corresponding monitoring entity of tables of data that needs monitoring with database, the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data are obtained data in database by monitoring entity;
Monitoring entity form creating unit, for creating the form corresponding with monitoring entity, shows with the result of checking to monitoring entity;
Monitoring entity form setting unit, selects to need the attribute of showing as the form row form for the attribute from monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result;
Check regular setting unit, for being arranged on monitoring entity, search the rule of checking of data;
Check project setting unit, for to checking that regular implementation status arranges;
Check project implementation unit, for monitoring entity data based being checked to rule searches;
Check result display unit, for after checking that the project implementation completes, by returning to meet, check that regular data check that to meeting regular data show by the report tableau format setting.
From above technical scheme, tables of data in correspondence database of the present invention creates monitoring entity, for monitoring entity creates the corresponding form for checking that result is shown, and setting corresponding with monitoring entity check rule, for the different Data Sources of checking, can be by the relationship maps relation between configuration and monitoring entity, realize statement formization customization, configuration statement form specific aim is out stronger, while changing statement form, do not need again to develop, arrange that content only comprises that chart is shown and two of Data Sources, use simple and convenient, can improve user's work efficiency, and the form representing can be adjusted flexibly.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention, to the accompanying drawing of required use in embodiment or description of the Prior Art be done to simple introduction below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the process flow diagram of the inventive method;
Fig. 2 is the schematic diagram of the setup of attribute page of embodiment of the present invention monitoring entity;
Fig. 3 be embodiment of the present invention monitoring entity form page schematic diagram is set;
Fig. 4 is the schematic diagram that the form of embodiment of the present invention monitoring entity arranges the page;
Fig. 5 is the schematic diagram that embodiment of the present invention acquiescence form arranges the page;
Fig. 6 is that the embodiment of the present invention checks that rule arranges the signal of the page;
Fig. 7 is the schematic diagram that the page is set that the embodiment of the present invention is checked project;
Fig. 8 is that the embodiment of the present invention checks that the execution of project arranges the schematic diagram of the page;
Fig. 9 be embodiment of the present invention monitoring entity check result exploded view.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention; technical scheme in the embodiment of the present invention is clearly and completely described; obviously; described embodiment is only the present invention's part embodiment; rather than whole embodiment; embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
With reference to Fig. 1, Fig. 1 is the process flow diagram of the displaying collocation method of checking result that provides of the embodiment of the present invention, and the method comprises the following steps:
S101, monitoring entity foundation step.Create the monitoring entity corresponding with the tables of data that needs in database to monitor, the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data.Monitoring entity is the mapping of data set that needs are monitored, obtains the data that need monitoring by monitoring entity in database.
As shown in Figure 2, Fig. 2 is a schematic diagram for the setup of attribute page of the monitoring entity that is called " asset data accuracy ".The attribute of asset data accuracy monitoring entity comprises unit designator code, card name, fixed assets card numbering, organization, accumulated depreciation end of term number etc., wherein, each attribute comprises the contents such as Chinese, Property Name, attribute type, attribute specification and length.The attribute of monitoring entity is corresponding with the column information in tables of data.A monitoring entity can be corresponding with a tables of data in database, also can be corresponding with a plurality of tables of data, monitoring entity and a plurality of tables of data are at once, only the column information of the attribute of monitoring entity and data table related need be set up to relationship maps relation, can integrate the data of a plurality of tables of data.By setting up the corresponding relation between monitoring entity and tables of data, can avoid business datum table same in prior art in different operation systems because of the inconsistent situation that cannot be general of structural information.
S102, monitoring entity form foundation step.Form is the displaying interface of checking result of monitoring entity, and the result of checking of monitoring entity is carried out representing of data by the report tableau format to set.Report tableau format comprises the forms such as single table, biserial, boss's list and list row figure.Monitoring entity form the page is set as shown in Figure 3, can select a kind of form as monitoring entity in single table, biserial, boss's list and list row figure.
S103, monitoring entity form setting steps.Data in monitoring entity will be shown in form, need to arrange attribute corresponding to data, select to need the attribute of showing as the form row in form from the attribute of monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result; Meanwhile, can also be to row display Name, alignment thereof, the width in form, font format arranges, such as revising row display Name etc.
As shown in Figure 4, the form that Fig. 4 is " budget control " monitoring entity arranges the schematic diagram of the page, the attributes such as the budget title of " budget control " monitoring entity of wanting to show in form, organization id, budget ID, budget amount are added in the form row of form, check that result while showing shows the data to aforementioned attribute.If the report tableau format arranging in monitoring entity form foundation step is list row bitmap-format, in this step, can also and whether support the contents such as 3D demonstration to arrange to graph style, theme, X-axis data rows, Y-axis data rows, data source, as carry out 3D demonstration and also need Z axis data rows to arrange.With reference to Fig. 4, as graph style is set to histogram, theme is set to theme one, and X-axis shows budget ID, and Y-axis shows budget amount etc.
Further, can be a monitoring entity a plurality of forms are set, when a monitoring entity has a plurality of form, can be set to give tacit consent to form by one of them form, as shown in Figure 5.Arrange after acquiescence form, check that result will automatically apply acquiescence report tableau format and carry out data display.
S104, check regular setting steps.According to checking rule, to needing the data of monitoring to search in monitoring entity, so that carry out while checking, by meeting, check that regular data are shown on form.
For example, to the setting of " budget control " monitoring entity check that rule is for " budget amount is greater than 5000 ", when when execution, this checks rule, budget amount is greater than 5000 data and will be shown on the form of monitoring entity " budget control ".With reference to Fig. 6, Fig. 6 checks that rule arranges the schematic diagram of the page, checks that regular setting comprises rule name, checks main points, checks item and checks the setting of expression formula.
S105, check project setting steps.The setting of checking project is to checking that regular implementation status arranges, and the content of checking project comprises the cycle, the unit of checking, the audited unit that check rule and carry out, checks object and check the contents such as item.That checks project arranges the page as shown in Figure 7.
S106, check project implementation step.By performance period of setting, carry out the project of checking, data based in monitoring entity checked to rule searches.The execution of checking project arranges the page as shown in Figure 8.
S107, check that result shows step.After checking that the project implementation completes, return to meet and check regular data, and show qualified data by the report tableau format setting.
With reference to Fig. 9, what Fig. 9 was " budget control " monitoring entity checks result exploded view, and meeting of checking out checked to regular data are presented in form, wherein has the demonstration of list and figure.
The present invention allows user by configuration, just can complete mapping association and the adjustment to data exhibiting form of Data Source, and the process of operation is simple, convenient, and the result after adjusting can be applied on intrasystem all users.By creating the monitoring entity corresponding with tables of data, show that the Attribute Relative of form and monitoring entity is answered, and can adjust flexibly, make the result of graphic analyses can reflect accurately data, better assisted user is analyzed and decision-making.
When the form that represents to data is unsatisfied with, can repeat aforesaid monitoring entity form and create and monitoring entity form setting steps, adjust and represent statement form flexibly.
The present invention also provides a kind of displaying inking device of checking result based on the inventive method, comprising:
Monitoring entity creating unit, for creating the corresponding monitoring entity of tables of data that needs monitoring with database, the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data are obtained data in database by monitoring entity;
Monitoring entity form creating unit, for creating the form corresponding with monitoring entity, shows with the result of checking to monitoring entity;
Monitoring entity form setting unit, selects to need the attribute of showing as the form row form for the attribute from monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result;
Check regular setting unit, for being arranged on monitoring entity, search the rule of checking of data;
Check project setting unit, for to checking that regular implementation status arranges;
Check project implementation unit, for monitoring entity data based being checked to rule searches;
Check result display unit, for after checking that the project implementation completes, by returning to meet, check that regular data check that to meeting regular data show by the report tableau format setting.
It should be noted that, the contents such as the information interaction between each module/unit of said apparatus, implementation, owing to conceiving based on unified with the inventive method embodiment, its technique effect bringing is identical with the inventive method embodiment, particular content can, referring to the narration in the inventive method embodiment, repeat no more herein.
It will be appreciated by those skilled in the art that, unit and the algorithm steps of each example of describing in conjunction with embodiment disclosed herein, can realize with electronic hardware, computer software or the combination of the two, for the interchangeability of hardware and software is clearly described, composition and the step of each example described according to function in the above description in general manner.These functions are carried out with hardware or software mode actually, depend on application-specific and the design constraint of technical scheme.Professional and technical personnel realizes described function with distinct methods in the time of can specifically should being used for to each, but this realization should not thought and exceeds scope of the present invention.
The software module that the method for describing in conjunction with embodiment disclosed herein or the step of algorithm can directly use hardware, processor to carry out, or the combination of the two is implemented.Software module can be placed in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or the known any other forms of storage medium of technical field.
Above-mentioned explanation to the disclosed embodiments, makes professional and technical personnel in the field can realize or use the present invention.To the multiple modification of previous embodiment, will be apparent for those skilled in the art, in the present invention, defined General Principle can, in the situation that not departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to previous embodiment, but will meet the widest scope consistent with principles of this disclosure and features of novelty.
Claims (9)
1. the displaying collocation method of checking result, is characterized in that, comprises the following steps:
Monitoring entity foundation step, creates the monitoring entity corresponding with the tables of data that needs monitoring in database, and the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data are obtained data in database by monitoring entity;
Monitoring entity form foundation step, creates the form corresponding with monitoring entity, for the displaying of checking result of monitoring entity;
Monitoring entity form setting steps selects to need the attribute of showing as the form row in form from the attribute of monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result;
Check regular setting steps, check that rule is for searching data at monitoring entity;
Check project setting steps, to checking that regular implementation status arranges;
Check project implementation step, data based in monitoring entity checked to rule searches;
Check that result shows step, after checking that the project implementation completes, return to meet and check regular data, and to meeting, check that regular data show by the report tableau format setting.
2. the displaying collocation method of checking result according to claim 1, is characterized in that: the attribute of described monitoring entity comprises Chinese, Property Name, attribute type, attribute specification and length.
3. the displaying collocation method of checking result according to claim 1, is characterized in that: described monitoring entity can be corresponding with the one or more tables of data in database.
4. the displaying collocation method of checking result according to claim 1, is characterized in that: the report tableau format creating in described monitoring entity form foundation step comprises single table, biserial, boss's list and list row figure.
5. according to the displaying collocation method of checking result described in claim 1 or 4, it is characterized in that: in described monitoring entity form setting steps, to row display Name, alignment thereof, width in form, font format arranges.
6. the displaying collocation method of checking result according to claim 5, it is characterized in that: when described statement form is list row figure, whether monitoring entity form setting steps also comprises graph style, theme, X-axis data rows, Y-axis data rows, data source and support 3D demonstration to arrange.
7. the displaying collocation method of checking result according to claim 1, is characterized in that: described in check that regular content comprises rule name, checks main points, checks item and checks expression formula.
8. the displaying collocation method of checking result according to claim 1, is characterized in that: described in check project content comprise the cycle, the unit of checking, the audited unit that check rule and carry out, check object and check item.
9. the displaying inking device of checking result, is characterized in that, comprising:
Monitoring entity creating unit, for creating the corresponding monitoring entity of tables of data that needs monitoring with database, the attribute of configuration monitoring entity and the relationship maps relation between the column information in tables of data are obtained data in database by monitoring entity;
Monitoring entity form creating unit, for creating the form corresponding with monitoring entity, shows with the result of checking to monitoring entity;
Monitoring entity form setting unit, selects to need the attribute of showing as the form row form for the attribute from monitoring entity, and the corresponding data of attribute of choosing will be shown in checking result;
Check regular setting unit, for being arranged on monitoring entity, search the rule of checking of data;
Check project setting unit, for to checking that regular implementation status arranges;
Check project implementation unit, for monitoring entity data based being checked to rule searches;
Check result display unit, for after checking that the project implementation completes, by returning to meet, check that regular data check that to meeting regular data show by the report tableau format setting.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310549411.1A CN103729713A (en) | 2013-11-06 | 2013-11-06 | Audit result display configuration method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310549411.1A CN103729713A (en) | 2013-11-06 | 2013-11-06 | Audit result display configuration method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103729713A true CN103729713A (en) | 2014-04-16 |
Family
ID=50453775
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310549411.1A Pending CN103729713A (en) | 2013-11-06 | 2013-11-06 | Audit result display configuration method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103729713A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN106897455A (en) * | 2017-03-09 | 2017-06-27 | 山东浪潮商用系统有限公司 | A kind of implementation method of configurable statistical analysis |
| CN109299450A (en) * | 2018-10-31 | 2019-02-01 | 上海用天网络科技有限公司 | Dynamic statement method for exhibiting data in a kind of business management software |
| CN111367981A (en) * | 2020-03-06 | 2020-07-03 | 北京思特奇信息技术股份有限公司 | Method, system, medium and equipment for extracting data of automatic monitoring audit report |
| CN112115130A (en) * | 2017-04-25 | 2020-12-22 | 杭州数梦工场科技有限公司 | Method, device, equipment and medium for acquiring data corresponding relation |
| CN112926941A (en) * | 2021-03-04 | 2021-06-08 | 远光软件股份有限公司 | Management method and device for financial auditing rules, storage medium and server |
| CN114911854A (en) * | 2022-05-09 | 2022-08-16 | 建信金融科技有限责任公司 | Data processing method and device |
| CN115185983A (en) * | 2022-09-14 | 2022-10-14 | 北京博点智合科技有限公司 | Report generation method and device |
-
2013
- 2013-11-06 CN CN201310549411.1A patent/CN103729713A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN106897455A (en) * | 2017-03-09 | 2017-06-27 | 山东浪潮商用系统有限公司 | A kind of implementation method of configurable statistical analysis |
| CN112115130A (en) * | 2017-04-25 | 2020-12-22 | 杭州数梦工场科技有限公司 | Method, device, equipment and medium for acquiring data corresponding relation |
| CN109299450A (en) * | 2018-10-31 | 2019-02-01 | 上海用天网络科技有限公司 | Dynamic statement method for exhibiting data in a kind of business management software |
| CN111367981A (en) * | 2020-03-06 | 2020-07-03 | 北京思特奇信息技术股份有限公司 | Method, system, medium and equipment for extracting data of automatic monitoring audit report |
| CN111367981B (en) * | 2020-03-06 | 2023-08-22 | 北京思特奇信息技术股份有限公司 | Method, system, medium and equipment for automatically monitoring audit report data extraction |
| CN112926941A (en) * | 2021-03-04 | 2021-06-08 | 远光软件股份有限公司 | Management method and device for financial auditing rules, storage medium and server |
| CN114911854A (en) * | 2022-05-09 | 2022-08-16 | 建信金融科技有限责任公司 | Data processing method and device |
| CN115185983A (en) * | 2022-09-14 | 2022-10-14 | 北京博点智合科技有限公司 | Report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103729713A (en) | Audit result display configuration method and device | |
| Mingers | Multimethodology | |
| US9183561B2 (en) | Automatic generation of trend charts | |
| CN105989082B (en) | Tabular views generation method and device | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| US9953331B2 (en) | Extensibility for sales predictor (SPE) | |
| US7747564B2 (en) | Comparative analysis of business intelligence data | |
| CN104714949A (en) | Method for customizing report dynamically | |
| CN102541867A (en) | Data dictionary generating method and system | |
| CN109697064A (en) | A kind of generation method and device of the customized page | |
| CN107544808A (en) | The generation method and device of a kind of web form | |
| CN104699742A (en) | Extreme visualization enabling extension for large data sets | |
| US10089120B2 (en) | Widgets in digital dashboards | |
| CN104750771A (en) | Method and system for contextual data analysis using domain information | |
| CN103606037A (en) | Query and configuration method of business data and device thereof | |
| Powell | Microsoft Power BI cookbook: Creating business intelligence solutions of analytical data models, reports, and dashboards | |
| CN103744831A (en) | Compilation method and device for multi-dimensional report | |
| CN105677346A (en) | Dynamic expansion method of web interface and server | |
| CN106779594A (en) | A kind of Workflow management method based on Activiti | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| US20140130008A1 (en) | Generating information models | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140416 |
|
| RJ01 | Rejection of invention patent application after publication |