CN104408030A - XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device - Google Patents
XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device Download PDFInfo
- Publication number
- CN104408030A CN104408030A CN201410590077.9A CN201410590077A CN104408030A CN 104408030 A CN104408030 A CN 104408030A CN 201410590077 A CN201410590077 A CN 201410590077A CN 104408030 A CN104408030 A CN 104408030A
- Authority
- CN
- China
- Prior art keywords
- xbrl
- cell
- roletype
- classification
- dimensional information
- 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.)
- Granted
Links
Abstract
The invention provides an XBRL (eXtensible Business Reporting Language) instance generation method and an XBRL instance generation device. The XBRL instance generation method comprises the following steps of generating a report format file based on a report according to an XBRL instance generation command; judging whether to adjust dimensional information of a predetermined classification standard according to the report format file; establishing mapping relation of accounting subjects and dimensions for the report and the predetermined classification standard according to the judgment result; generating an XBRL instance for the report according to the mapping relation and the data of the report. Through the technical scheme, the workload for mapping establishment and adjustment is reduced, the high efficiency and the correctness for the mapping establishment and adjustment are improved, mapping and multiplexing are realized, the operation of a user is simplified, the probability for occurrence of an error is reduced, and further the data conversion efficiency is improved. Thus, the XBRL instance is quickly, accurately and automatically generated.
Description
Technical field
The present invention relates to data conversion technique field, in particular to a kind of XBRL example generation method and a kind of XBRL example generating apparatus.
Background technology
In existing a lot of form product, all need the data conversion of using between report data and XBRL (Extensible Business Reporting Language) instance document, in not mapping situation, report data cannot generate XBRL example automatically, but, in the process generating XBRL example, the learning cost of XBRL software is high, and set up the process mapped very complicated, workload is huge, and easily go wrong, these problems annoying XBRL always and implement personnel.
Meanwhile, some ease of use issues are also following.In existing Embedded XBRL software, user often wishes that report data can be automatically converted to XBRL example, reduce the workload of manual typing, reduce wrong odds, for these problems, although exist in existing XBRL software by mapping the function automatically realizing instance data and generate, in its mapping process, still there is following defect:
1. mappings work amount is large, the enforcement time is long, especially with the RoleType (character types) with dimension in the definition chained library of XBRL be typical case, supposing existence 2 dimensions, there are 10 members in each dimension, and so an elementary item just needs the cartesian product number of times mapping them, namely 100 times, and in each criteria for classification, probably have the RoleType of about 100, thus, the correctness of mapping also cannot ensure.
2. when after criteria for classification adjustment, map and also need to change thereupon, but, a member in adjustment criteria for classification just likely needs adjustment dozens of to map, and criteria for classification is worked out in the process of XBRL example will often adjust user, so, after adjustment criteria for classification, also very huge for the modification amount mapped.
3. mapping cannot be multiplexing, when a criteria for classification be adjusted by the criteria for classification of last year and come time, after the report data of form also adjusts, the mapping between new criteria for classification and form cannot multiplexing original mapping relations, have to re-establish mapping, bring inconvenience to the operation of user.
Therefore, need a kind of new technical scheme, user can be allowed between statement form and XBRL criteria for classification to set up mapping relations more rapidly and accurately, and in the rear rapid adjustment mapping relations of criteria for classification adjustment, to generate XBRL example fast.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of new technical scheme, user can be allowed between statement form and XBRL criteria for classification to set up mapping relations more rapidly and accurately, and in the rear rapid adjustment mapping relations of criteria for classification adjustment, to generate XBRL example fast.
In view of this, the present invention proposes a kind of XBRL example generation method, it is characterized in that, comprising: generate order, according to report generation statement form file according to the example of XBRL; According to described statement form file, judge whether the dimensional information adjusting the RoleType subscribing criteria for classification; According to judged result, for described form and described predtermined category standard set up account title and dimension map; According to described form and the mapping relations of described predtermined category standard and the data of described form, it is described report generation XBRL example.
In this technical scheme, intuitively can represent the form of report tableau format and criteria for classification, wherein, the form of criteria for classification represents and can go to represent according to the two kinds of modes representing chained library and definition chained library after criteria for classification engine parses, the RoleType of non-dimension can use the mode representing chained library to go to represent, RoleType with dimension can use the mode of definition chained library to go to represent, wherein, certain dimension can be selected to launch chained library, to show the format information under various dimension of criteria for classification as far as possible in definition chained library.And report tableau format major embodiment to be dimensional information, it is described in a kind of mode of XML file, is applicable to the reporting system that all are represented by form.In the technical program, the dimensional information of the RoleType of criteria for classification is subscribed according to the statement form file area adjustment by report generation, between form and criteria for classification, mapping can be set up more rapidly and accurately thus, and realize report data to the fast automatic generation of XBRL example.Simultaneously, the dimensional information of criteria for classification is subscribed according to the adjustment of statement form file, the mapping between form and criteria for classification can also be adjusted in time when described statement form changes, and mapping need not be re-established, reduce the workload mapping and set up, simplify user operation, improve the high efficiency and correctness that map and set up, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, also comprise: when detecting that statement form occurs to upgrade, according to the described statement form after renewal, upgrade described statement form file.
Criteria for classification is worked out in the process of XBRL example will often adjust user, but a member in adjustment criteria for classification just likely needs adjustment dozens of to map, also very huge for the modification amount mapped.Further, when after the criteria for classification directly more renewed, former mapping cannot be multiplexing.For the problems referred to above, in the technical program, automatically can resolve according to the change of criteria for classification and adjust and show form, so that according to the mapping that the adjustment of statement form file has been set up, so, automatically can set up new mapping according to the criteria for classification after renewal, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
In technique scheme, preferably, described according to described statement form file, judge whether to adjust the dimensional information of subscribing criteria for classification, specifically comprise: judge whether described statement form file upgrades; When described judged result is for being, obtain the attribute of each cell in described statement form file, and according to the attribute of described each cell, adjust the dimensional information of the RoleType of described reservation criteria for classification, when described judged result is no, do not adjust the dimensional information of the RoleType of described reservation criteria for classification; And it is described according to judged result, for described form and described predtermined category standard set up dimension map, specifically comprise: according to the dimensional information of described RoleType after adjustment or the dimensional information of unadjusted described RoleType, set up for each cell in each cell of described RoleType and described statement form file and map one by one.
In this technical scheme, can automatically according to subscribing the correlation attribute information of each cell in criteria for classification and statement form file automatically for form coupling maps, by the mode of dimension map, the dimension member used in the member that the RoleType of various dimensions can be used and form maps one to one, thus reduce the workload mapping adjustment, simplify user operation, improve the high efficiency and correctness that map adjustment, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, the attribute of described each cell comprise following at least one or a combination set of: the title of described each cell, the type of described each cell, the dimensional information of described each cell, the account title information of described each cell.
In this technical scheme, by the parsing to statement form file, the correlation attribute information of each cell in statement form can be obtained, wherein, the attribute of each cell include but not limited to following at least one or a combination set of: the title of each cell, type, dimensional information, account title information.On mapping mode, the consistance of the capital of account of XBRL element tags and form can be passed through, accomplish that Auto-matching maps, meanwhile, also manually can carry out mapping adjustment to individual element according to the correlation attribute information of each cell.
In technique scheme, preferably, described according to described form and the mapping relations of described predtermined category standard and the data of described form, be described report generation XBRL example, specifically comprise: according to described mapping relations, generate the context with the dimensional information of described form; After being mated with the data of described form by described context, described context is converted into XBRL context, described report data is converted to the true value of XBRL.
In this technical scheme, without the need to paying close attention to the information such as the measurement unit of XBRL, only have by dimension map generate context mate with the data of form, obtain instance frames, more respectively context and report data are converted into XBRL context and XBRL the fact value can obtain XBRL example.
Another aspect of the present invention proposes a kind of XBRL example generating apparatus, comprising: file generating unit, generates order, according to report generation statement form file according to the example of XBRL; Judging unit, according to described statement form file, judges whether the dimensional information of the RoleType adjusting described reservation criteria for classification; Unit is set up in mapping, according to judged result, for described form and described predtermined category standard set up account title and dimension map; Example generation unit, according to described form and the mapping relations of described predtermined category standard and the data of described form, is described report generation example.
In this technical scheme, intuitively can represent the form of report tableau format and criteria for classification, wherein, the form of criteria for classification represents and can go to represent according to the two kinds of modes representing chained library and definition chained library after criteria for classification engine parses, the RoleType of non-dimension can use the mode representing chained library to go to represent, RoleType with dimension can use the mode of definition chained library to go to represent, wherein, certain dimension can be selected to launch chained library, to show the format information under various dimension of criteria for classification as far as possible in definition chained library.And report tableau format major embodiment to be dimensional information, it is described in a kind of mode of XML file, is applicable to the reporting system that all are represented by form.In the technical program, the dimensional information of the RoleType of criteria for classification is subscribed according to the statement form file area adjustment by report generation, between form and criteria for classification, mapping can be set up more rapidly and accurately thus, and realize report data to the fast automatic generation of XBRL example.Simultaneously, the dimensional information of the RoleType of criteria for classification is subscribed according to the adjustment of statement form file, the mapping between form and criteria for classification can also be adjusted in time when described form changes, and mapping need not be re-established, reduce the workload mapping and set up, simplify user operation, improve the high efficiency and correctness that map and set up, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, also comprising: standard update unit, when detecting that statement form occurs to upgrade, according to the described statement form after renewal, upgrading described statement form file.
Criteria for classification is worked out in the process of XBRL example will often adjust user, but a member in adjustment criteria for classification just likely needs adjustment dozens of to map, also very huge for the modification amount mapped.Further, when after the criteria for classification directly more renewed, former mapping cannot be multiplexing.For the problems referred to above, in the technical program, displaying form can be automatically adjusted according to the change of criteria for classification, so that according to the mapping that the adjustment of statement form file has been set up, so, automatically can set up new mapping according to the criteria for classification after renewal, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
In technique scheme, preferably, described judging unit specifically for: judge whether described statement form file upgrades, wherein when described judged result is for being, obtain the attribute of each cell in described statement form file, and according to the attribute of described each cell, adjust the dimensional information of the RoleType of described reservation criteria for classification, when described judged result is no, do not adjust the dimensional information of the RoleType of described reservation criteria for classification; And described mapping set up unit specifically for: according to the dimensional information of described RoleType after adjustment or the dimensional information of unadjusted described RoleType, set up for each cell in each cell of described RoleType and described statement form file and map one by one.
In this technical scheme, when causing statement form file to change because criteria for classification changes, can automatically according to change after statement form file in each cell correlation attribute information automatically for form coupling mapping, by the mode of dimension map, the dimension member used in the member that the RoleType of various dimensions can be used and form maps one to one, thus reduce the workload mapping adjustment, simplify user operation, improve the high efficiency and correctness that map adjustment, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, the attribute of described each cell comprise following at least one or a combination set of: the title of described each cell, the type of described each cell, the dimensional information of described each cell, the account title information of described each cell.
In this technical scheme, by the parsing to statement form file, the correlation attribute information of each cell in statement form can be obtained, wherein, the attribute of each cell include but not limited to following at least one or a combination set of: the title of each cell, type, dimensional information, account title information.On mapping mode, the consistance of the capital of account of XBRL element tags and form can be passed through, accomplish that Auto-matching maps, meanwhile, also manually can carry out mapping adjustment to individual element according to the correlation attribute information of each cell.
In technique scheme, preferably, described example generation unit specifically for: according to described mapping relations, generate the context with the dimensional information of described form, after described context is mated with the data of described form, described context is converted into XBRL context, described report data is converted to the true value of XBRL.
In this technical scheme, without the need to paying close attention to the information such as the measurement unit of XBRL, only have by dimension map generate context mate with the data of form, obtain instance frames, more respectively context and report data are converted into XBRL context and XBRL the fact value can obtain XBRL example.
By above technical scheme, reduce the workload mapping foundation and adjustment, improve the high efficiency and correctness that map and set up and adjust, achieve mapping multiplexing, simplify the operation of user, decrease wrong odds, and then improve the efficiency of data conversion.Thus automatically generate XBRL example rapidly and accurately.
Accompanying drawing explanation
Fig. 1 shows the process flow diagram of XBRL example generation method according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of XBRL according to an embodiment of the invention embedded example generation method;
Fig. 3 shows the particular flow sheet setting up mapping in the embodiment of Fig. 2;
Fig. 4 shows the particular flow sheet generating example in the embodiment of Fig. 2;
Fig. 5 A shows the particular flow sheet of generation example according to another embodiment of the invention;
Fig. 5 B shows the screenshotss schematic diagram of the report data existed in reporting system;
Fig. 5 C to Fig. 5 F shows the screenshotss schematic diagram generating example in Fig. 5 A;
Fig. 6 A shows the particular flow sheet of mapping according to an embodiment of the invention;
Fig. 6 B shows the screenshotss schematic diagram that between predtermined category standard and described form, account title maps;
Fig. 6 C shows the screenshotss schematic diagram of dimension map between predtermined category standard and described form;
Fig. 6 D freely defines the screenshotss schematic diagram of an expansion dimension under showing the two dimension of described form;
Fig. 6 E shows the screenshotss schematic diagram of XBRL form when the two dimension of predtermined category standard is launched;
After Fig. 6 F shows the adjustment of predtermined category standard dimension, the screenshotss schematic diagram of XBRL form when one-dimensional degree launches;
Fig. 6 G shows predtermined category standard one-dimensional degree and launches the screenshotss schematic diagram that between rear and described form, account title maps;
Fig. 6 H shows the screenshotss schematic diagram of dimension map between predtermined category standard and described form;
Fig. 6 I shows the screenshotss schematic diagram that between predtermined category standard and described form, total entry account title maps;
Fig. 7 shows the block diagram of XBRL example generating apparatus according to an embodiment of the invention.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the process flow diagram of XBRL example generation method according to an embodiment of the invention;
As shown in Figure 1, XBRL example generation method according to an embodiment of the invention, comprising:
Step 102, generates order, according to report generation statement form file according to the example of XBRL.
Step 104, according to statement form file, judges whether the dimensional information adjusting the RoleType subscribing criteria for classification.
Step 106, according to judged result, for form and predtermined category standard set up account title and dimension map.
Step 108, according to form and the mapping relations of predtermined category standard and the data of form, is report generation XBRL example.
In this technical scheme, intuitively can represent the form of report tableau format and criteria for classification, wherein, the form of criteria for classification represents and can go to represent according to the two kinds of modes representing chained library and definition chained library after criteria for classification engine parses, the RoleType of non-dimension can use the mode representing chained library to go to represent, RoleType with dimension can use the mode of definition chained library to go to represent, wherein, certain dimension can be selected to launch chained library, to show the format information under various dimension of criteria for classification as far as possible in definition chained library.And report tableau format major embodiment to be dimensional information, it is described in a kind of mode of XML file, is applicable to the reporting system that all are represented by form.In the technical program, the dimensional information of criteria for classification RoleType is subscribed according to the statement form file area adjustment by described report generation, between form and criteria for classification, mapping can be set up more rapidly and accurately thus, and realize report data to the fast automatic generation of XBRL example.Simultaneously, the dimensional information of criteria for classification RoleType is subscribed according to the adjustment of statement form file, the mapping between form and criteria for classification can also be adjusted in time when described form changes, and mapping need not be re-established, reduce the workload mapping and set up, simplify user operation, improve the high efficiency and correctness that map and set up, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, also comprise: when detecting that statement form occurs to upgrade, according to the described statement form after renewal, upgrade described statement form file.
Criteria for classification is worked out in the process of XBRL example will often adjust user, but a member in adjustment criteria for classification just likely needs adjustment dozens of to map, also very huge for the modification amount mapped.Further, when after the criteria for classification directly more renewed, former mapping cannot be multiplexing.For the problems referred to above, in the technical program, displaying form can be automatically adjusted according to the change of criteria for classification, so that according to the mapping that the adjustment of statement form file has been set up, so, automatically can set up new mapping according to the criteria for classification after renewal, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
In technique scheme, preferably, step 104 specifically comprises: judge whether statement form file upgrades; When judged result is for being, obtain the attribute of each cell in statement form file, and according to the attribute of each cell, the dimensional information of the RoleType of criteria for classification is subscribed in adjustment, when judged result is no, do not adjust the dimensional information of the RoleType subscribing criteria for classification; And step 106 specifically comprises: according to the dimensional information of RoleType after adjustment or the dimensional information of unadjusted RoleType, set up for each cell in each cell of RoleType and statement form file and map one by one.
In this technical scheme, when causing statement form file to change because described statement form changes, can automatically according to change after statement form file in each cell correlation attribute information automatically for form coupling mapping, by the mode of dimension map, the dimension member used in the member that the RoleType of various dimensions can be used and form maps one to one, thus reduce the workload mapping adjustment, simplify user operation, improve the high efficiency and correctness that map adjustment, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, the attribute of each cell comprise following at least one or a combination set of: the title of each cell, the type of each cell, the dimensional information of each cell, the account title information of each cell.
In this technical scheme, by the parsing to statement form file, the correlation attribute information of each cell in statement form can be obtained, wherein, the attribute of each cell include but not limited to following at least one or a combination set of: the title of each cell, type, dimensional information, account title information.On mapping mode, the consistance of the capital of account of XBRL element tags and form can be passed through, accomplish that Auto-matching maps, meanwhile, also manually can carry out mapping adjustment to individual element according to the correlation attribute information of each cell.
In technique scheme, preferably, step 108 specifically comprises: according to mapping relations, generates the context with the dimensional information of form; After being mated with the data of form by context, context is converted into XBRL context, report data is converted to the true value of XBRL.
In this technical scheme, without the need to paying close attention to the information such as the measurement unit of XBRL, only have by dimension map generate context mate with the data of form, obtain instance frames, more respectively context and report data are converted into XBRL context and XBRL the fact value can obtain XBRL example.
Fig. 2 shows the process flow diagram of XBRL according to an embodiment of the invention embedded example generation method.
As shown in Figure 2, XBRL according to an embodiment of the invention embedded example generation method, comprises the following steps:
Step 202, writes criteria for classification.Criteria for classification is write.
Step 204, sets up and maps.Namely according to the statement form file got by described form, set up for form and criteria for classification and map, when criteria for classification changes, the corresponding renewal of row can be injected by automatic mapping.
Step 206, generates example automatically.Namely according to the mapping of having set up, automatically XBRL example is generated.
Step 208, verifies example, to ensure XBRL example correctness and the availability of generation.
By the technical program, reduce the workload mapping foundation and adjust, improve the high efficiency and correctness that map and set up and adjust, achieve mapping multiplexing, simplify the operation of user, decrease wrong odds, and then improve the efficiency of data conversion.Thus automatically generate XBRL example rapidly and accurately.
Fig. 3 shows the particular flow sheet setting up mapping in the embodiment of Fig. 2.
As shown in Figure 3, set up the process mapped specifically to comprise the following steps:
Step 302, derives statement form file at Reports module.
Step 304, resolves in presetting module and represents criteria for classification.
Step 306, imports in presetting module, resolves and represent statement form file.
Step 308, maps dimension member manually or automatically.
Step 310, maps basic item and account title manually or automatically.
Step 312, preserves mapped file.
By the technical program, automatically can set up mapping according to criteria for classification, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
Fig. 4 shows the particular flow sheet generating example in the embodiment of Fig. 2.
As shown in Figure 4, the process generating example specifically comprises the following steps:
Step 402, resolves mapped file.
Step 404, derives report data at Reports module.
Step 406, imports at example generation module and resolves report data.
Step 408, generates context automatically, automatically generates measurement unit.
Step 410, generates instance data automatically.
Pass through the technical program, the information such as the measurement unit of context and XBRL generate all automatically, and, context and report data can realize automatically being converted into XBRL context and the true value of XBRL can obtain XBRL example, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
Fig. 5 A shows the particular flow sheet of generation example according to another embodiment of the invention.
As shown in Figure 5A, according to another embodiment of the invention, the process generating example comprises the following steps:
Step 502, obtains mapping relations.
Step 504, generates Cross Report context.
Step 506, whether the mapping relations that judgement obtains are that default member maps, and when judged result is for being, entering step 508, when judged result is no, entering step 514.
Step 508, whether the mapping relations that judgement obtains are that full dimension is launched to map, and when judged result is for being, entering step 510, when judged result is no, entering step 512.
Step 510, generates acquiescence form context.
Step 512, generating portion dimension default context.
Step 514, mates form context with form account title.
Step 516, matches hereafter by report data dimensional information.
Step 518, mates account title with report data.
Step 520, is worth form context and report data conversion XBRL context with true.
The flow process generating example in Fig. 5 A is specifically described below in conjunction with the screenshotss schematic diagram shown in Fig. 5 B to Fig. 5 F, wherein, Fig. 5 B shows the screenshotss schematic diagram of the report data existed in reporting system, Fig. 5 C shows and switches measurement unit show percent data, Fig. 5 D and Fig. 5 E shows the process that context and measurement unit generate automatically, Fig. 5 F illustrate example generate after instance data.
After the mapped file obtaining criteria for classification and form, externally can be provided for the routine interface generating XBRL example, report data and mapped file is comprised in this interface, therefore, when report data generates XBRL example automatically, first to obtain map information, intersect according to the dimension launched in RoleType in criteria for classification and dimension map member and generate XBRL context template; Obtain the form accountant's department destination that basic item maps, the dimension used by it is filtered the XBRL context template that intersection generates, remove incoherent map information in dimension map, and this context and form cell are bound, with generating report forms data, when report data generates, according to reporting entity, time and context template, batch creates in fact hereafter, and fills true value, finally in fact will hereafter be converted into XBRL context again, and automatically generate XBRL fact value.
Its specific algorithm is described below:
1. obtain mapping relations.
2., according to the dimension map relation in RoleType in mapping relations, multiple dimension iteration member is intersected and generates the form context of cartesian product, this form context is used for the filling of report data.
3. whether judge to have to do on default member after RoleType dimension is launched to map, now, the form context of generation comprises the dimensional information of form, for the filling of report data.
Wherein, when judged result is for being, judging whether RoleType maps in full dimension expansion situation further, if YES, then generating the form context without dimensional information, otherwise, the form context that generating portion dimension is launched; When judged result is no, do not generate the acquiescence form context without dimensional information.
4. form context is mated with form cell.
5. obtain report data, and according to dimensional information coupling form context, fill report data.
6. form context is converted into XBRL context according to mapping relations, report data is converted to the true value of XBRL according to mapping relations.
With a map example, above-mentioned algorithm is described further below:
Have 2 dimensions in RoleType, each dimension has 3 members, if use the mode launching money-capital classification dimension to go to map, three members of dimension map kind of currencies, multiple dimension iteration is intersected can generate 3 form contexts.
On form, the upper bottom of total entry uses half expansion to map, and generates 9 form contexts altogether, but 9 contextual contents of form are consistent, can be regarded as a context.
When filling report data, dynamically the dimension of row is kind of currencies, therefore, and can according to dimension map three form contexts and form account title padding data.
Form total entry can according to form account title padding data.
Finally, by data transformations be XBRL context and true value.
Fig. 6 A shows the particular flow sheet of mapping according to an embodiment of the invention.
As shown in Figure 6A, according to one embodiment of present invention, the idiographic flow of mapping is as follows:
Step 602, the RoleType form launching criteria for classification is used for mapping, and selects RoleType and launch its form from RoleType list.
Step 604, selects corresponding form to launch form and is used for mapping, select Report and launch form from Report list.
Step 606, judges whether the display dimension adjusting RoleType, when judged result is for being, entering step 610, when judged result is no, entering step 608.
Step 608, launches RoleType by adjustment dimension.
Step 610, carries out basic item and form account title maps.
Step 612, carries out dimension member mapping at dimension map window.
Step 614, launches all dimension total entries, and maps.
The flow process adjusting mapping in Fig. 6 A is specifically described below in conjunction with the screenshotss schematic diagram shown in Fig. 6 B to Fig. 6 I, wherein, Fig. 6 B shows the screenshotss schematic diagram that between predtermined category standard and described form, account title maps, and Fig. 6 C shows the screenshotss schematic diagram of dimension map between predtermined category standard and described form.
Fig. 6 D freely defines the screenshotss schematic diagram of an expansion dimension under showing the two dimension of described form, as shown in Figure 6 D, select Report and launch form from Report list.
Fig. 6 E shows the screenshotss schematic diagram of XBRL form when the two dimension of predtermined category standard is launched, and as illustrated in fig. 6e, selects RoleType and launch its form from RoleType list.
After Fig. 6 F shows the adjustment of predtermined category standard dimension, the screenshotss schematic diagram of XBRL form when one-dimensional degree launches, as fig 6 f illustrates, in report tableau format, the member of the money-capital genre dimension of criteria for classification is shown as the row head of form, so, need when mapping to adjust the dimension shown in XBRL, to mate statement form.
Fig. 6 G shows predtermined category standard one-dimensional degree and launches the screenshotss schematic diagram that between rear and described form, account title maps, and as shown in Figure 6 G, then according to the RoleType that money-capital classification is launched, goes to carry out contrast with statement form and maps.
In addition, Fig. 6 H shows the screenshotss schematic diagram of dimension map between predtermined category standard and described form, needs to be dimension member map for the dimension do not shown.Finally, Fig. 6 I shows the screenshotss schematic diagram that between predtermined category standard and described form, total entry account title maps, and does the mapping of total entry after all dimensions are all launched.
In this technical scheme, report tableau format is all generally be made up of cell, and the dimension that each cell is used may have difference, so, in statement form XML file, have the description of the dimension referred to for each cell, and statement form is all generally fixing, only may just can change when data state, such as increase and dynamically go, and the technical program does for the form of form state to map, that is, in application scenarios of the present invention, report tableau format state is fixing, report tableau format is freely, due to the randomness of statement form definition, can dimension data be placed in form among wardrobe or row head, for this reason, the technical program also can adapt to the randomness of statement form definition, when statement form comes according to the tiling of certain dimension, the form of XBRL also should launch according to certain dimension, thus realize the foundation of mapping relations targetedly.
For comparing the form agreed with criteria for classification, dimension map and basic item is only needed to map, above mapping mode supports that the Chinese label Auto-matching of capital of account and criteria for classification element maps, and support the consistent automatic mapping of the label of dimension member, also support laterally or longitudinally batch mapping.
Pass through technique scheme, improve the ease for use mapped between form and XBRL criteria for classification, by methods such as automatic mapping, batch mappings, considerably reduce the workload of mapping, and ensure that the accuracy of mapping, intuitively the process of mapping can be presented to user, be easy to user and understand and implement, substantially increase the work efficiency of user.Meanwhile, quick and precisely generate XBRL example by these mapping relations, and without the need to paying close attention to the ancillary data of the instance data references such as XBRL context, measurement unit.Particularly for the RoleType of the various dimensions type of the complexity defined in XBRL criteria for classification in chained library, mapping process can become and be simple and easy to use, thus more quick.Finally, the technical program can realize the quick generation to XBRL example of mapping between the form of polytype reporting system and XBRL criteria for classification and heterogeneous report form data, and is not limited to a certain form.
Fig. 7 shows the block diagram of XBRL example generating apparatus according to an embodiment of the invention.
As shown in Figure 7, report form embodiment generating apparatus 700 according to an embodiment of the invention, comprising: file generating unit 702, generates order, according to report generation statement form file according to the example of XBRL; Judging unit 704, according to statement form file, judges whether the dimensional information adjusting the RoleType subscribing criteria for classification; Unit 706 is set up in mapping, according to judged result, for form and predtermined category standard set up account title and dimension map; Example generation unit 708, according to form and the mapping relations of predtermined category standard and the data of form, is report generation example.
In this technical scheme, intuitively can represent the form of report tableau format and criteria for classification, wherein, the form of criteria for classification represents and can go to represent according to the two kinds of modes representing chained library and definition chained library after criteria for classification engine parses, the RoleType of non-dimension can use the mode representing chained library to go to represent, RoleType with dimension can use the mode of definition chained library to go to represent, wherein, certain dimension can be selected to launch chained library, to show the format information under various dimension of criteria for classification as far as possible in definition chained library.And report tableau format major embodiment to be dimensional information, it is described in a kind of mode of XML file, is applicable to the reporting system that all are represented by form.In the technical program, the dimensional information of criteria for classification RoleType is subscribed according to the statement form file area adjustment by described report generation, between form and criteria for classification, mapping can be set up more rapidly and accurately thus, and realize report data to the fast automatic generation of XBRL example.Simultaneously, the dimensional information of criteria for classification RoleType is subscribed according to the adjustment of statement form file, the mapping between form and criteria for classification can also be adjusted in time when criteria for classification changes, and mapping need not be re-established, reduce the workload mapping and set up, simplify user operation, improve the high efficiency and correctness that map and set up, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, also comprising: standard update unit 710, when detecting that statement form occurs to upgrade, according to the statement form after renewal, upgrading statement form file.
Criteria for classification is worked out in the process of XBRL example will often adjust user, but a member in adjustment criteria for classification just likely needs adjustment dozens of to map, also very huge for the modification amount mapped.Further, when after the criteria for classification directly more renewed, former mapping cannot be multiplexing.For the problems referred to above, in the technical program, displaying form can be automatically adjusted according to the change of criteria for classification, so that according to the mapping that the adjustment of statement form file has been set up, so, automatically can set up new mapping according to the criteria for classification after renewal, improve the convenience of user operation, decrease wrong odds, and then improve the efficiency of data conversion.
In technique scheme, preferably, judging unit 704 specifically for: judge whether statement form file upgrades, wherein when judged result is for being, obtain the attribute of each cell in statement form file, and according to the attribute of each cell, the dimensional information of the RoleType of criteria for classification is subscribed in adjustment, when judged result is no, do not adjust the dimensional information of the RoleType subscribing criteria for classification; And map set up unit 706 specifically for: according to the dimensional information of RoleType after adjustment or the dimensional information of unadjusted RoleType, set up for each cell in each cell of RoleType and statement form file and map one by one.
In this technical scheme, when causing displaying change of format because criteria for classification changes, can automatically according to change after reservation criteria for classification RoleType in each cell correlation attribute information automatically for form coupling mapping, by the mode of dimension map, the dimension member used in the member that the RoleType of various dimensions can be used and form maps one to one, thus reduce the workload mapping adjustment, simplify user operation, improve the high efficiency and correctness that map adjustment, to generate XBRL example rapidly and accurately.
In technique scheme, preferably, the attribute of each cell comprise following at least one or a combination set of: the title of each cell, the type of each cell, the dimensional information of each cell, the account title information of each cell.
In this technical scheme, by the parsing to statement form file, the correlation attribute information of each cell in statement form can be obtained, wherein, the attribute of each cell include but not limited to following at least one or a combination set of: the title of each cell, type, dimensional information, account title information.On mapping mode, the consistance of the capital of account of XBRL element tags and form can be passed through, accomplish that Auto-matching maps, meanwhile, also manually can carry out mapping adjustment to individual element according to the correlation attribute information of each cell.
In technique scheme, preferably, example generation unit 708 specifically for: according to described mapping relations, generate the context with the dimensional information of form, after context is mated with the data of form, context is converted into XBRL context, report data is converted to the true value of XBRL.
In this technical scheme, without the need to paying close attention to the information such as the measurement unit of XBRL, only have by dimension map generate context mate with the data of form, obtain instance frames, more respectively context and report data are converted into XBRL context and XBRL the fact value can obtain XBRL example.
More than be described with reference to the accompanying drawings technical scheme of the present invention, by technical scheme of the present invention, reduce the workload mapping and set up and adjust, improve the high efficiency and correctness that map and set up and adjust, achieve mapping multiplexing, simplify the operation of user, decrease wrong odds, and then improve the efficiency of data conversion.Thus automatically generate XBRL example rapidly and accurately.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. an XBRL example generation method, is characterized in that, comprising:
Order is generated, according to report generation statement form file according to the example of XBRL;
According to described statement form file, judge whether the dimensional information adjusting the RoleType subscribing criteria for classification;
According to judged result, for described form and described predtermined category standard set up account title and dimension map;
According to described form and the mapping relations of described predtermined category standard and the data of described form, it is described report generation XBRL example.
2. XBRL example generation method according to claim 1, is characterized in that, also comprise:
When detecting that statement form occurs to upgrade, according to the described statement form after renewal, upgrade described statement form file.
3. XBRL example generation method according to claim 2, is characterized in that, described according to described statement form file, judges whether to adjust the dimensional information of subscribing criteria for classification, specifically comprises:
Judge whether described statement form file upgrades;
When described judged result is for being, obtain the attribute of each cell in described statement form file, and according to the attribute of described each cell, adjust the dimensional information of the RoleType of described reservation criteria for classification,
When described judged result is no, do not adjust the dimensional information of the RoleType of described reservation criteria for classification; And
Described according to judged result, for described form and described predtermined category standard set up dimension map, specifically comprise:
According to the dimensional information of described RoleType after adjustment or the dimensional information of unadjusted described RoleType, set up for each cell in each cell of described RoleType and described statement form file and map one by one.
4. XBRL example generation method according to claim 3, is characterized in that, the attribute of described each cell comprise following at least one or a combination set of:
The title of described each cell, the type of described each cell, the dimensional information of described each cell, the account title information of described each cell.
5. XBRL example generation method according to any one of claim 1 to 4, is characterized in that, described according to described form and the mapping relations of described predtermined category standard and the data of described form, is described report generation XBRL example, specifically comprises:
According to described mapping relations, generate the context with the dimensional information of described form;
After being mated with the data of described form by described context, described context is converted into XBRL context, described report data is converted to the true value of XBRL.
6. an XBRL example generating apparatus, is characterized in that, comprising:
File generating unit, generates order, according to report generation statement form file according to the example of XBRL;
Judging unit, according to described statement form file, judges whether the dimensional information of the RoleType adjusting described reservation criteria for classification;
Unit is set up in mapping, according to judged result, for described form and described predtermined category standard set up account title and dimension map;
Example generation unit, according to described form and the mapping relations of described predtermined category standard and the data of described form, is described report generation XBRL example.
7. XBRL example generating apparatus according to claim 6, is characterized in that, also comprise:
Standard update unit, when detecting that statement form occurs to upgrade, according to the described statement form after renewal, upgrades described statement form file.
8. XBRL example generating apparatus according to claim 7, is characterized in that, described judging unit specifically for:
Judge whether described statement form file upgrades, wherein
When described judged result is for being, obtain the attribute of each cell in described statement form file, and according to the attribute of described each cell, adjust the RoleType dimensional information of described reservation criteria for classification, when described judged result is no, do not adjust the dimensional information of the RoleType of described reservation criteria for classification; And
Described mapping set up unit specifically for:
According to the dimensional information of described RoleType after adjustment or the dimensional information of unadjusted described RoleType, set up for each cell in each cell of described RoleType and described statement form file and map one by one.
9. XBRL example generating apparatus according to claim 8, is characterized in that, the attribute of described each cell comprise following at least one or a combination set of:
The title of described each cell, the type of described each cell, the dimensional information of described each cell, the account title information of described each cell.
10. the XBRL example generating apparatus according to any one of claim 6 to 9, is characterized in that, described example generation unit specifically for:
According to described mapping relations, generate the context with the dimensional information of described form,
After being mated with the data of described form by described context, described context is converted into XBRL context, described report data is converted to the true value of XBRL.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410590077.9A CN104408030B (en) | 2014-10-28 | 2014-10-28 | XBRL examples generation method and XBRL example generating means |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410590077.9A CN104408030B (en) | 2014-10-28 | 2014-10-28 | XBRL examples generation method and XBRL example generating means |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104408030A true CN104408030A (en) | 2015-03-11 |
| CN104408030B CN104408030B (en) | 2018-01-05 |
Family
ID=52645662
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410590077.9A Active CN104408030B (en) | 2014-10-28 | 2014-10-28 | XBRL examples generation method and XBRL example generating means |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104408030B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105224512A (en) * | 2015-09-24 | 2016-01-06 | 四川长虹电器股份有限公司 | The method of instance document is generated based on XBRL intelligence report platform data relation |
| CN105224513A (en) * | 2015-09-24 | 2016-01-06 | 四川长虹电器股份有限公司 | A kind of based on the contextual method of XBRL instance document intelligence generation |
| CN105320744A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Analytical method of link library with custom XBRL classification criterion |
| CN105320742A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Method for mapping subject information of traditional financial statement to XBRL classification standard format |
| CN105335459A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | XBRL intelligent report platform based statement consolidation data extraction method |
| CN106528671A (en) * | 2016-10-31 | 2017-03-22 | 用友网络科技股份有限公司 | Modeling method for converting XBRL statement into relational database storage model |
| CN106649769A (en) * | 2016-12-27 | 2017-05-10 | 中国科学院大学 | Method for converting XBRL data into OWL data based on semantics |
| CN109344380A (en) * | 2018-09-25 | 2019-02-15 | 山东浪潮通软信息科技有限公司 | A kind of method and device for opening report |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050144166A1 (en) * | 2003-11-26 | 2005-06-30 | Frederic Chapus | Method for assisting in automated conversion of data and associated metadata |
| CN102214243A (en) * | 2011-07-07 | 2011-10-12 | 中国科学院研究生院 | Version management system for x extensible business reporting language (XBRL) classification standard |
| US20120239610A1 (en) * | 2011-03-17 | 2012-09-20 | Xbrl Cloud, Inc. | Xbrl database mapping system and method |
| US20140013204A1 (en) * | 2012-06-18 | 2014-01-09 | Novaworks, LLC | Method and apparatus for sychronizing financial reporting data |
| CN103729337A (en) * | 2013-12-27 | 2014-04-16 | 金蝶软件（中国）有限公司 | Report conversion method and device |
| US8825614B1 (en) * | 2012-04-27 | 2014-09-02 | WebFilings LLC | Systems and methods for automated taxonomy migration in an XBRL document |
-
2014
- 2014-10-28 CN CN201410590077.9A patent/CN104408030B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050144166A1 (en) * | 2003-11-26 | 2005-06-30 | Frederic Chapus | Method for assisting in automated conversion of data and associated metadata |
| US20120239610A1 (en) * | 2011-03-17 | 2012-09-20 | Xbrl Cloud, Inc. | Xbrl database mapping system and method |
| CN102214243A (en) * | 2011-07-07 | 2011-10-12 | 中国科学院研究生院 | Version management system for x extensible business reporting language (XBRL) classification standard |
| US8825614B1 (en) * | 2012-04-27 | 2014-09-02 | WebFilings LLC | Systems and methods for automated taxonomy migration in an XBRL document |
| US20140013204A1 (en) * | 2012-06-18 | 2014-01-09 | Novaworks, LLC | Method and apparatus for sychronizing financial reporting data |
| CN103729337A (en) * | 2013-12-27 | 2014-04-16 | 金蝶软件（中国）有限公司 | Report conversion method and device |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105224512A (en) * | 2015-09-24 | 2016-01-06 | 四川长虹电器股份有限公司 | The method of instance document is generated based on XBRL intelligence report platform data relation |
| CN105224513A (en) * | 2015-09-24 | 2016-01-06 | 四川长虹电器股份有限公司 | A kind of based on the contextual method of XBRL instance document intelligence generation |
| CN105320744A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Analytical method of link library with custom XBRL classification criterion |
| CN105320742A (en) * | 2015-09-24 | 2016-02-10 | 四川长虹电器股份有限公司 | Method for mapping subject information of traditional financial statement to XBRL classification standard format |
| CN105335459A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | XBRL intelligent report platform based statement consolidation data extraction method |
| CN105335459B (en) * | 2015-09-24 | 2019-03-26 | 四川长虹电器股份有限公司 | Consolidated accounts data pick-up method based on XBRL intelligence reporting platform |
| CN106528671A (en) * | 2016-10-31 | 2017-03-22 | 用友网络科技股份有限公司 | Modeling method for converting XBRL statement into relational database storage model |
| CN106528671B (en) * | 2016-10-31 | 2019-10-22 | 用友网络科技股份有限公司 | XBRL report is converted to the modeling method of relational database storage model |
| CN106649769A (en) * | 2016-12-27 | 2017-05-10 | 中国科学院大学 | Method for converting XBRL data into OWL data based on semantics |
| CN106649769B (en) * | 2016-12-27 | 2020-10-30 | 中国科学院大学 | Semantic-based conversion method from XBRL data to OWL data |
| CN109344380A (en) * | 2018-09-25 | 2019-02-15 | 山东浪潮通软信息科技有限公司 | A kind of method and device for opening report |
| CN109344380B (en) * | 2018-09-25 | 2023-04-07 | 浪潮通用软件有限公司 | Method and device for opening report |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104408030B (en) | 2018-01-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104408030A (en) | XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device | |
| CN106951430B (en) | Account table query method and device | |
| CN105487864B (en) | The method and apparatus of Code automatic build | |
| CN108170809B (en) | Table building script generation method, device, equipment and computer readable storage medium | |
| CN104133772B (en) | Automatic test data generation method | |
| US9110686B2 (en) | Web client command infrastructure integration into a rich client application | |
| US11243971B2 (en) | System and method of database creation through form design | |
| CN100426291C (en) | System and method to realize database upgrading in background management system | |
| CN106547729B (en) | A kind of dynamic creation method and system of data sheet | |
| CN101977121A (en) | Configuration file processing method, device and system | |
| CN104317587A (en) | Automatic android mobile device oriented application generation method | |
| CN105389184B (en) | The configuration method and device of Product Interface information | |
| CN110276074B (en) | Distributed training method, device, equipment and storage medium for natural language processing | |
| CN105095074B (en) | Upgrade test method and device for configuration file | |
| CN105760290A (en) | Problem positioning method based on web front-end testing as well as related device and system | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN109799988A (en) | IOS page layout method, terminal device and computer readable storage medium | |
| US8091064B2 (en) | Supporting system, design supporting method, and computer-readable recording medium recorded with design supporting program | |
| US20060047723A1 (en) | Custom database system and method of building the same | |
| CN110597896A (en) | Data display method, data display device and terminal equipment | |
| CN101441656A (en) | Method and apparatus for processing form setting scheme and enterprise resource planning system | |
| JP2010015458A (en) | Program correction support system, program correction support method, and program correction support program | |
| CN101436309B (en) | Method and apparatus for modifying formula operator | |
| CN107861926A (en) | Document template configuration method and device | |
| CN106502977B (en) | A kind of sheet disposal method and form system based on B/S framework |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |