CN105335459A - XBRL intelligent report platform based statement consolidation data extraction method - Google Patents
XBRL intelligent report platform based statement consolidation data extraction method Download PDFInfo
- Publication number
- CN105335459A CN105335459A CN201510615299.6A CN201510615299A CN105335459A CN 105335459 A CN105335459 A CN 105335459A CN 201510615299 A CN201510615299 A CN 201510615299A CN 105335459 A CN105335459 A CN 105335459A
- Authority
- CN
- China
- Prior art keywords
- row
- statement
- dimension
- data
- allocation list
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a financial statement generation technology and aims to solve the problems of high workload and high error rate in a process of obtaining existing financial statement consolidation data. The invention provides an XBRL intelligent report platform based statement consolidation data extraction method. The method comprises the following steps: firstly, obtaining fixed dimensions and row dimensions from a statement configuration table, a statement row configuration table and a statement column configuration table, generating and executing a dynamic SQL, automatically retrieving data available for a current statement from a statement consolidation fact table, and inserting the data into a fact middle table; secondly, performing Cartesian join on the statement row configuration table and the statement column configuration table through statement IDs, generating a dynamic SQL of extracted data, inserting the dynamic SQL into a row-column dynamic SQL temporary table, obtaining path and fact value information, and inserting the path and fact value information into a fact value table; and finally, performing circulation on each statement to obtain complete fact value table data identifiable for an XBRL platform, and storing the complete fact value table data in a statement value table. The method is suitable for extracting statement consolidation data of the XBRL intelligent report platform.
Description
Technical field
The present invention relates to financial statement generation technique, particularly based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform.
Background technology
XBRL Extensible Business Reporting Language is based on internet, cross-platform operation, the computerese be specifically designed to financial report establishment, disclosing and use.After enterprise's editing classification standard and instance document, need a large amount of manual operationss could generate instance data document.
Along with the use of XBRL platform puts more effort, allowing financial staff when using XBRL platform manually to import report data, also exposing some drawbacks:
(1), when reporting financial report, need from consolidated accounts system downloads related statements data, repetitive operation.
(2) need combing form, and with instance document every corresponding on, loaded down with trivial details, easily make mistakes.
(3) need artificial importing XBRL platform, if the information imported is wrong, must accent import.
(4) by artificial treatment, only try out in reporting few financial report, when needing to report financial report in a large number, the workload of financial staff will be extremely huge.
Summary of the invention
For the problems referred to above, the invention provides a kind of consolidated accounts data pick-up method based on XBRL intelligence reporting platform.Comprise the steps:
A. from form allocation list, report line allocation list and form row allocation list, obtain fixed dimension and row dimension, generate dynamic sql and perform, automatically retrieve from consolidated accounts fact table the useful data of current form and insert true middle table;
B. carry out Descartes with form row allocation list by form ID by report line allocation list to be connected, generate the dynamic sql of isolating and also insert ranks dynamic sql temporary table, obtain path and true value information and be inserted into true value table;
C. above-mentioned circulation is carried out to each form, obtain the discernible true value table data of complete XBRL platform and be stored in form value table.
Particularly, comprise before steps A: be combined report form sample and carry out analysis and modeling, generating report forms allocation list, report line allocation list and form row allocation list, by fixed dimension, row dimension and row dimension respectively stored in above-mentioned three tables.
Further, step B also comprises, and performs dynamic sql, search for the data of current form from consolidated accounts fact table after generating the dynamic sql of isolating, and is saved in the true middle table of consolidated accounts.
Particularly, described form allocation list is for storing all report headings and the fixed dimension of consolidated accounts system definition, and concrete field comprises: report name, form another name, fixed dimension and row dimension name.
Particularly, described report line allocation list is for all form subject information of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, Course in English, row dimension and row dimension values.
Particularly, described form row allocation list is for all form row heads of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, row title, row dimension, whether calculate year dimension and whether computing interval dimension.
Particularly, described form value table is for storing the form value and routing information that extract, and concrete field comprises: during row ID, row ID, path, true value, true value are affiliated, form year information, entity ID and form ID.
The invention has the beneficial effects as follows: by technical scheme of the present invention, the data of consolidated accounts can be simplified, reduce the workload of finance staff, and consolidated accounts of the present invention generates automatically, is not easy to make mistakes.
Embodiment below in conjunction with embodiment is described in further detail technical scheme of the present invention; should be noted that; embodiment is only used to help reader to understand technical conceive of the present invention better, not in order to limit the protection domain of the claims in the present invention.
Embodiment
The present invention is directed to workload in existing financial statement pooled data acquisition process and greatly easily occur the problem of mistake, provide a kind of consolidated accounts data pick-up method based on XBRL intelligence reporting platform, the concrete steps of the method are as follows.
First carry out connection by form allocation list, report line allocation list and form row allocation list and obtain vernier handle (outer vernier), therefrom obtain fixed dimension and row dimension values field, generate dynamic sql and perform, automatically retrieve from consolidated accounts fact table the useful data of current form and insert true middle table.After such process, the data volume that true middle table produces is minimum.
Carry out Descartes with form row allocation list by form ID by report line allocation list to be again connected, the dynamic sql that generation is isolated also inserts ranks dynamic sql temporary table, then this table vernier handle (internal layer vernier) is obtained, obtain the information such as path and true value, and be inserted into true value table.Above-mentioned circulation is carried out to each form, finally obtains the discernible true value table data of complete Xbrl platform.
Embodiment
Below further exemplary description is done to each step of method of the present invention and specific implementation.
First each table occurred in the present invention is described in detail.
1. form allocation list
Form allocation list, for storing all report headings and the fixed dimension of consolidated accounts system definition, concrete field comprises: report name, form another name, fixed dimension, whether have year dimension mark, whether have period dimension mark, whether be merge to identify and row dimension name with individual statements.The report form sample title that report name is preserved, as " with fair value measurement and its variation counts the financial asset (by kind) of current profit and loss ", the report form sample another name that form another name is preserved, because report form sample provides with Excel file form, table sample title and Sheet title are inconsistent, stored in allocation list, more easily investigate problem later, as " with fair value measurement and its variation counts the financial asset-1 of current profit and loss ", fixed dimension extracts the dimension group of these form relevant rudimentary data, as " C1# [None]; I# [ICPTop] "; whether there is year dimension mark to represent the need of automatically adding that in fixed dimension " Y#VY " peeks; whether to have period dimension mark to represent the need of automatically adding that in fixed dimension " P#VP " peeks; to be whether merge identify with individual statements to represent and merge individual entities or single entity the need of increasing in fixed dimension; row dimension name breaks database design three normal form, accelerates from fact table extraction related data to true middle table.
2. report line allocation list
Report line allocation list is for all form subject information of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, Course in English, row dimension and row dimension values.
Form ID quotes and preserves row corresponding to the line number in the middle of Excel document from the major key of form allocation list, coding of going, as " 6 ", " 7 " ..., Course in English has another name called row entry name, preserve the given next entry name of every a line first row, mainly consult the row dimension group of to preserve with maintenance work from now on, row dimension from true middle table extracted data for convenience, as " C2#AG0501; Account#112301 ", row dimension values for isolate logic extract true middle table time kick other useless data off, be lifted at the data pick-up speed of true middle table.
3. form row allocation list
Form row allocation list is for all form row heads of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, row title, row dimension, whether calculate year dimension and whether computing interval dimension.
Form ID quotes and preserves row from the major key of form allocation list, row coding and correspond to row code in the middle of Excel document, as " B ", " C " ..., row title preserves the row title that provides of table sample, mainly consult for convenience and maintenance work from now on, row dimension preserves the row dimension group from true middle table extracted data, as " C3#NAC30501; C2# [None]; ", whether calculate a year dimension table and be shown in when isolating and whether year dimension calculated, as " Y#Y-1; ", whether whether computing interval dimension table is shown in when isolating calculates, as " P#P-1 period dimension; ".
4. consolidated accounts fact table
Consolidated accounts fact table, to the true Value Data of XBRL platform database by consolidated accounts system migration, factor data amount is quite huge, after consolidated accounts full dose migration data, data being inserted through entity No carries out in the fact table of Hash subregion, carry out segmentation to data to store, to ensure to search for certain entity useful data to speed during true middle table; Fact object comprises dimensional information field, (as Y#; P#; E#; A#; ) and true value field (the final data (as represented the data " 373068474.57 " of the amount of money) needing to represent in instance document.
5. the true middle table of consolidated accounts
List structure is consistent with consolidated accounts fact table, and effect is, is combined, search for the data of current form from consolidated accounts fact table by the fixed dimension in form allocation list and row dimension name, is saved in the true middle table of consolidated accounts, accelerates to isolate logic.
6. form value table
Form value table, for storing the form value extracted, routing information, concrete field comprises: row ID (introducing from reporting for work row allocation list), row ID (quote and know form row allocation list), path (stores the path values corresponded in Excel, as " 7B, 7C ... "), true value (concrete amount information), period belonging to true value (preserves during this fact value results from certain, as " 2014-08-31 "), form year, information (preserved the generation time of this form, as " 2015 "), entity ID (being incorporated in entity list) and form ID (being incorporated in form allocation list).
Based on relevant configuration table and true middle table, by following operation logic, just can realize logic of isolating fast, idiographic flow is as follows:
A. by fixed dimension and row dimension name and row dimension values retrieve data from consolidated accounts fact table;
B. the data retrieved are inserted true middle table;
C. generate the relevant dynamic sql of current form by row dimension and row dimension, perform and insert ranks dynamic sql temporary table;
D. perform dynamic sql, and will be worth stored in instance document value table.
According to above operation logic, the form of often opening be combined in report circulates this logic, then the form that entity is corresponding all will take out automatically, and complete form value table data are directly transferred for Xbrl platform, and generate instance document.
Claims (7)
1., based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, it is characterized in that, comprise the steps:
A. from form allocation list, report line allocation list and form row allocation list, obtain fixed dimension and row dimension, generate dynamic sql and perform, automatically retrieve from consolidated accounts fact table the useful data of current form and insert true middle table;
B. carry out Descartes with form row allocation list by form ID by report line allocation list to be connected, generate the dynamic sql of isolating and also insert ranks dynamic sql temporary table, obtain path and true value information and be inserted into true value table;
C. above-mentioned circulation is carried out to each form, obtain the discernible true value table data of complete XBRL platform and be stored in form value table.
2. as claimed in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, it is characterized in that, comprise before steps A: be combined report form sample and carry out analysis and modeling, generating report forms allocation list, report line allocation list and form row allocation list, by fixed dimension, row dimension and row dimension respectively stored in above-mentioned three tables.
3. as claimed in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, it is characterized in that, step B also comprises, dynamic sql is performed after generating the dynamic sql of isolating, from consolidated accounts fact table, search for the data of current form, and be saved in the true middle table of consolidated accounts.
4. the consolidated accounts data pick-up method based on XBRL intelligence reporting platform as described in claims 1 to 3 any one, it is characterized in that, described form allocation list is for storing all report headings and the fixed dimension of consolidated accounts system definition, and concrete field comprises: report name, form another name, fixed dimension and row dimension name.
5. the consolidated accounts data pick-up method based on XBRL intelligence reporting platform as described in claims 1 to 3 any one, it is characterized in that, described report line allocation list is for all form subject information of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, Course in English, row dimension and row dimension values.
6. the consolidated accounts data pick-up method based on XBRL intelligence reporting platform as described in claims 1 to 3 any one, it is characterized in that, described form row allocation list is for all form row heads of storing consolidated accounts system and defining and row dimensional information, and concrete field comprises: form ID, row coding, row title, row dimension, whether calculate year dimension and whether computing interval dimension.
7. as claimed in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, it is characterized in that, described form value table is for storing the form value and routing information that extract, and concrete field comprises: during row ID, row ID, path, true value, true value are affiliated, form year information, entity ID and form ID.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510615299.6A CN105335459B (en) | 2015-09-24 | 2015-09-24 | Consolidated accounts data pick-up method based on XBRL intelligence reporting platform |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510615299.6A CN105335459B (en) | 2015-09-24 | 2015-09-24 | Consolidated accounts data pick-up method based on XBRL intelligence reporting platform |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105335459A true CN105335459A (en) | 2016-02-17 |
CN105335459B CN105335459B (en) | 2019-03-26 |
Family
ID=55285986
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510615299.6A Active CN105335459B (en) | 2015-09-24 | 2015-09-24 | Consolidated accounts data pick-up method based on XBRL intelligence reporting platform |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105335459B (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106844320A (en) * | 2016-12-27 | 2017-06-13 | 税友软件集团股份有限公司 | A kind of financial statement integration method and equipment |
CN110262969A (en) * | 2019-06-13 | 2019-09-20 | 泰康保险集团股份有限公司 | Report test method, device, electronic equipment and computer readable storage medium |
CN110851441A (en) * | 2019-10-12 | 2020-02-28 | 重庆金融资产交易所有限责任公司 | Data storage method and related equipment |
CN111159173A (en) * | 2018-11-08 | 2020-05-15 | 王纹 | Method for constructing multidimensional semantic database |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102314647A (en) * | 2011-09-29 | 2012-01-11 | 广州中浩控制技术有限公司 | Method for storing business data by using XBRL (extensible business reporting language) |
US20120239610A1 (en) * | 2011-03-17 | 2012-09-20 | Xbrl Cloud, Inc. | Xbrl database mapping system and method |
CN104408030A (en) * | 2014-10-28 | 2015-03-11 | 用友软件股份有限公司 | XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device |
CN104699803A (en) * | 2015-03-20 | 2015-06-10 | 浪潮通用软件有限公司 | XBRL (extensible business reporting language) report writing method meeting requirement for multi-specification submission |
-
2015
- 2015-09-24 CN CN201510615299.6A patent/CN105335459B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120239610A1 (en) * | 2011-03-17 | 2012-09-20 | Xbrl Cloud, Inc. | Xbrl database mapping system and method |
CN102314647A (en) * | 2011-09-29 | 2012-01-11 | 广州中浩控制技术有限公司 | Method for storing business data by using XBRL (extensible business reporting language) |
CN104408030A (en) * | 2014-10-28 | 2015-03-11 | 用友软件股份有限公司 | XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device |
CN104699803A (en) * | 2015-03-20 | 2015-06-10 | 浪潮通用软件有限公司 | XBRL (extensible business reporting language) report writing method meeting requirement for multi-specification submission |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106844320A (en) * | 2016-12-27 | 2017-06-13 | 税友软件集团股份有限公司 | A kind of financial statement integration method and equipment |
CN106844320B (en) * | 2016-12-27 | 2020-09-15 | 税友软件集团股份有限公司 | Financial statement integration method and equipment |
CN111159173A (en) * | 2018-11-08 | 2020-05-15 | 王纹 | Method for constructing multidimensional semantic database |
CN111159173B (en) * | 2018-11-08 | 2023-04-18 | 王纹 | Method for constructing multidimensional semantic database |
CN110262969A (en) * | 2019-06-13 | 2019-09-20 | 泰康保险集团股份有限公司 | Report test method, device, electronic equipment and computer readable storage medium |
CN110262969B (en) * | 2019-06-13 | 2022-03-22 | 泰康保险集团股份有限公司 | Report testing method and device, electronic equipment and computer readable storage medium |
CN110851441A (en) * | 2019-10-12 | 2020-02-28 | 重庆金融资产交易所有限责任公司 | Data storage method and related equipment |
Also Published As
Publication number | Publication date |
---|---|
CN105335459B (en) | 2019-03-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104866426B (en) | Software test integrated control method and system | |
CN104331446B (en) | A kind of massive data processing method mapped based on internal memory | |
CN106815326B (en) | System and method for detecting consistency of data table without main key | |
CN105335459A (en) | XBRL intelligent report platform based statement consolidation data extraction method | |
CN102110102A (en) | Data processing method and device, and file identifying method and tool | |
CN102999524A (en) | Method and system for searching document association | |
CN104021219A (en) | Method and device for generating data template | |
CN115391439B (en) | Document data export method, device, electronic equipment and storage medium | |
CN111177332A (en) | Method and device for automatically extracting referee document case-related mark and referee result | |
CN103399848A (en) | Engine test data standardized specific format leading-in processing method | |
CN102521713B (en) | Data processing equipment and data processing method | |
CN107861965A (en) | Data intelligence recognition methods and system | |
CN105373528A (en) | Method and device for analyzing sensitivity of text contents | |
CN106294401A (en) | Automatically the method and device in SQL list storehouse is set up | |
CN109324963B (en) | Method for automatically testing profit result and terminal equipment | |
CN103699482B (en) | Method and device for testing reasonableness of controls | |
CN111078683A (en) | Interpolation search-based power grid ledger data filling and counting method and device | |
CN116226108A (en) | Data management method and system capable of realizing different management degrees | |
CN106933783A (en) | A kind of method and device on the intelligent extraction date from text | |
CN108268456B (en) | Method for establishing invoice database and method for inquiring invoices in database | |
CN115422180A (en) | Data verification method and system | |
CN104899213B (en) | A kind of method and apparatus for parsing institution term | |
CN109685638B (en) | Audit coverage rate measuring method and device and storage medium | |
CN103810282B (en) | Logistic-normal model topic extraction method | |
CN108073612A (en) | The method and apparatus of synchronous SQL executive plans |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |