CN105335459B - Consolidated accounts data pick-up method based on XBRL intelligence reporting platform - Google Patents
Consolidated accounts data pick-up method based on XBRL intelligence reporting platform Download PDFInfo
- Publication number
- CN105335459B CN105335459B CN201510615299.6A CN201510615299A CN105335459B CN 105335459 B CN105335459 B CN 105335459B CN 201510615299 A CN201510615299 A CN 201510615299A CN 105335459 B CN105335459 B CN 105335459B
- Authority
- CN
- China
- Prior art keywords
- report
- allocation list
- consolidated accounts
- dimension
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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 present invention relates to financial statement generation techniques, in order to solve the problems, such as that heavy workload is easy to appear mistake in existing financial statement merging data acquisition process.The present invention provides a kind of consolidated accounts data pick-up method based on XBRL intelligence reporting platform, include the following steps: first, fixed dimension and row dimension are obtained from report allocation list, report line allocation list and report column allocation list, it generates dynamic sql and executes, retrieve the data useful to current report from consolidated accounts fact table automatically and be inserted into true middle table；Then, Descartes's connection is carried out by report ID by report line allocation list and report column allocation list, generates the dynamic sql isolated and is inserted into the interim table of ranks dynamic sql, obtain path and true value information and be inserted into true value table；Finally, carrying out above-mentioned circulation to each report, obtaining the identifiable true value table data of complete XBRL platform and being stored in report value table.The present invention is suitable for the consolidated accounts data pick-up of XBRL intelligence reporting platform.
Description
Technical field
The present invention relates to financial statement generation techniques, in particular to the consolidated accounts data based on XBRL intelligence reporting platform
Abstracting method.
Background technique
XBRL Extensible Business Reporting Language dedicated for financial report establishment, is draped over one's shoulders based on internet, cross-platform operation
The computer language for revealing and using.After enterprise's editing classification standard and instance document, need a large amount of manual operations that could generate
Instance data document.
As the use of XBRL platform puts more effort, financial staff is allowed manually to import report data using XBRL platform
When, also expose some drawbacks:
(1) it when reporting financial report, needs to download related statements data, repetitive operation from consolidated accounts system.
(2) need to comb report, and it is corresponding with instance document items on, it is cumbersome, be easy error.
(3) artificial importing XBRL platform is needed, it, must accent importing if the information imported is wrong.
(4) it by artificial treatment, only tries out in reporting few financial report, when needing largely to report financial report, the work of financial staff
Work amount will be extremely huge.
Summary of the invention
In view of the above-mentioned problems, the present invention provides a kind of consolidated accounts data pick-up side based on XBRL intelligence reporting platform
Method.Include the following steps:
A. fixed dimension and row dimension are obtained from report allocation list, report line allocation list and report column allocation list, generated
Dynamic sql simultaneously executes, and retrieves the data useful to current report from consolidated accounts fact table automatically and is inserted into true middle table；
B. Descartes's connection is carried out by report ID by report line allocation list and report column allocation list, generate isolate it is dynamic
State SQL is simultaneously inserted into the interim table of ranks dynamic sql, obtains path and true value information and is inserted into true value table；
C. above-mentioned circulation is carried out to each report, obtain the identifiable true value table data of complete XBRL platform and deposited
It is stored in report value table.
Specifically, include: that merging report form sample is analyzed and modeled before step A, generate report allocation list, report
Fixed dimension, row dimension and column dimension are stored in above-mentioned three tables by row allocation list and report column allocation list respectively.
Further, step B further includes executing dynamic sql after generating the dynamic sql isolated, from consolidated accounts fact table
The data of the middle current report of search, and be saved in consolidated accounts fact middle table.
Specifically, the report allocation list is used to store all report headings and fixed dimension that consolidated accounts system defines,
Specific field includes: report name, report alias, fixed dimension and row dimension name.
Specifically, the report line allocation list for store all report subject information defined in consolidated accounts system and
Row dimensional information, specific field include: report ID, row coding, Course in English, row dimension and row dimension values.
Specifically, the report column allocation list is for storing all report column heads defined in consolidated accounts system and column dimension
Spend information, specific field include: report ID, column coding, column name, column dimension, whether calculate year dimension and whether the computing interval
Dimension.
Specifically, for the report value table for storing the report value extracted and routing information, specific field includes: row
ID, ID, path, true value, true value affiliated period, report year information, entity ID and report ID are arranged.
The beneficial effects of the present invention are: according to the technical solution of the present invention, can simplify the data of consolidated accounts, wealth is reduced
The workload of business staff, and consolidated accounts of the invention automatically generates, it is not easy to it malfunctions.
Specific embodiment with reference to embodiments is described in further detail technical solution of the present invention, should infuse
Meaning, embodiment are not intended to limit the invention just for the sake of helping reader to more fully understand technical concept of the invention
Scope of protection of the claims.
Specific embodiment
The present invention is easy to appear the problem of mistake for heavy workload in existing financial statement merging data acquisition process,
A kind of consolidated accounts data pick-up method based on XBRL intelligence reporting platform is provided, specific step is as follows for this method.
It is attached first by report allocation list, report line allocation list and report column allocation list and obtains vernier handle (outside
Layer vernier), fixed dimension and row dimension value field are therefrom obtained, dynamic sql is generated and executes, automatically from consolidated accounts fact table
The middle retrieval data useful to current report are simultaneously inserted into true middle table.After handling in this way, the data volume of true middle table generation
It is minimum.
Descartes's connection is carried out by report ID by report line allocation list and report column allocation list again, generate isolate it is dynamic
State SQL is simultaneously inserted into the interim table of ranks dynamic sql, then obtains this table vernier handle (internal layer vernier), obtains path and true value
Etc. information, and be inserted into true value table.Above-mentioned circulation is carried out to each report, finally obtaining complete Xbrl platform can know
Other true value table data.
Embodiment
Further exemplary description is made to each step of method of the invention and specific implementation below.
The each table occurred in the present invention is described in detail first.
1. report allocation list
Report allocation list, for storing all report headings and fixed dimension that consolidated accounts system defines, specific field packet
Include: report name, report alias, fixed dimension, whether have year dimension mark, whether have during dimension mark, whether be merge with
Individual statements mark and row dimension name.The report form sample title that report name saves such as " is included in fair value measurement and its variation
The financial asset (pressing type) of current profit and loss ", the report form sample alias that report alias saves, because report form sample is with Excel file
What form provided, table sample title and Sheet title are inconsistent, deposit allocation lists, it is later to be easier investigation problem, such as " with
Fair value measurement and its variation are included in the financial asset -1 of current profit and loss ", fixed dimension extracts this report relevant rudimentary data
Dimension group, such as " C1# [None]；I# [ICP Top] ", if there is a year dimension mark to represent whether in fixed dimension certainly
It is dynamic to fetch plus " Y#VY ", if dimension mark represents whether in fixed dimension automatically plus " P#VP " during having
It fetches, if be to merge to represent whether to increase in fixed dimension with individual statements mark to merge individual entities or list
Entity, row dimension name break database and design three normal forms, accelerate to extract related data from true table to true middle table.
2. report line allocation list
Report line allocation list is used to store all report subject information and row dimensional information defined in consolidated accounts system,
Specific field includes: report ID, row coding, Course in English, row dimension and row dimension values.
Report ID quotes the major key from report allocation list, row coding saves the line number gone and corresponded in Excel document, such as
" 6 ", " 7 " ..., Course in English also known as row entry name save the entry name come given by every a line first row, are mainly side
Just the row dimension group for saving with maintenance work from now on, row dimension and extracting data from true middle table, such as " C2#AG0501 are consulted；
Account#112301 ", row dimension values kick other useless data off when extracting true middle table for isolating logic, are promoted
In the data pick-up rate of true middle table.
3. report column allocation list
Report column allocation list is for storing all report column heads and column dimensional information defined in consolidated accounts system, specifically
Field include: report ID, column coding, column name, column dimension, whether calculate year dimension and whether computing interval dimension.
Report ID quotes the major key from report allocation list, column coding saves the column code gone and corresponded in Excel document, such as
" B ", " C " ..., column name save the column name that table sample provides, mainly for convenience of access and maintenance work from now on, column dimension
Degree saves the column dimension group that data are extracted from true middle table, such as " C3#NAC30501；C2#[None]；", if calculate year dimension
Degree indicates whether calculate year dimension when isolating, such as " Y#Y-1；", if computing interval dimension expression be when isolating
It is no that period dimension is calculated, such as " P#P-1；".
4. consolidated accounts fact table
Consolidated accounts fact table is by the fact that consolidated accounts system migration to XBRL platform database Value Data, factor
It is quite huge according to measuring, after consolidated accounts full dose migrating data, data are inserted through the thing that entity No carries out Hash subregion
In real table, storage is split to data, with guarantee search for certain entity useful data to the fact middle table when rate；Fact object
Including dimensional information field, (such as Y#；P#；E#；A#；...) and true value field (finally need to be presented in instance document
Data (data " 373068474.57 " as indicated the amount of money).
5. consolidated accounts fact middle table
Table structure is consistent with consolidated accounts fact table, and effect is, by fixed dimension in report allocation list with
The combination of row dimension name, the data of current report are searched for from consolidated accounts fact table, are saved in consolidated accounts fact middle table,
Accelerate logic of isolating.
6. report value table
Report value table, for storing the report value extracted, routing information, specific field includes: that row ID (is introduced from registration
Row allocation list), column ID (report column allocation list is known in reference), path (storage correspond to Excel in path values, such as " 7B,
7C ... "), true value (specific amount information), belonging to true value during (during saving this fact value generation Mr. Yu, such as
" 2014-08-31 "), report year information (save the generation time of this report, such as " 2015 "), entity ID (be incorporated in entity
Table) and report ID (being incorporated in report allocation list).
Based on relevant configuration table and true middle table, by following operation logic, logic of quickly isolating can be realized, specifically
Process is as follows:
A. data are retrieved from consolidated accounts fact table by fixed dimension and column dimension name and column dimension values；
B. the data retrieved are inserted into true middle table；
C. the relevant dynamic sql of current report is generated by row dimension and column dimension, executes and be inserted into ranks dynamic sql and faces
When table；
D. dynamic sql is executed, and value is stored in instance document value table.
According to the above operation logic, which is recycled to every report in consolidation reporting, then the corresponding report of entity is all
It will automatically take out, complete report value table data are directly transferred for Xbrl platform, and generate instance document.
Claims (7)
1. the consolidated accounts data pick-up method based on XBRL intelligence reporting platform, which comprises the steps of:
A. fixed dimension and row dimension are obtained from report allocation list, report line allocation list and report column allocation list, generate dynamic
SQL is simultaneously executed, and is retrieved the data useful to current report from consolidated accounts fact table automatically and is inserted into true middle table；
B. Descartes's connection is carried out by report ID by report line allocation list and report column allocation list, generates the dynamic isolated
SQL is simultaneously inserted into the interim table of ranks dynamic sql, obtains path and true value information and is inserted into true value table；
C. above-mentioned circulation is carried out to each report, obtain the identifiable true value table data of complete XBRL platform and be stored in
In report value table；
The report allocation list is for storing all report headings and fixed dimension that consolidated accounts system defines；
The report line allocation list is for storing all report subject information and row dimensional information that consolidated accounts system defines；
The report column allocation list is for storing all report column heads and column dimensional information that consolidated accounts system defines；
The consolidated accounts fact table is for the fact that store consolidated accounts system migration to XBRL platform database Value Data；
The consolidated accounts fact middle table is used to store the data of the current report searched from consolidated accounts fact table；
The fact value table is for storing the fact that extract value and routing information；
The report value table is used to store the data in true value table.
2. as described in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, which is characterized in that
Include: that merging report form sample is analyzed and modeled before step A, generates report allocation list, report line allocation list and report
Fixed dimension, row dimension and column dimension are stored in above-mentioned three tables by column allocation list respectively.
3. as described in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, which is characterized in that
Step B further includes executing dynamic sql after generating the dynamic sql isolated, and the number of current report is searched for from consolidated accounts fact table
According to, and be saved in consolidated accounts fact middle table.
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, the report allocation list is used to store all report headings and fixed dimension that consolidated accounts system defines, specifically
Field includes: report name, report alias, 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, the report line allocation list is for storing all report subject information defined in consolidated accounts system and row dimension
Information is spent, specific field includes: report 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, the report column allocation list is for storing all report column heads defined in consolidated accounts system and column dimension letter
Breath, specific field include: report ID, column coding, column name, column dimension, whether calculate year dimension and whether computing interval dimension.
7. as described in claim 1 based on the consolidated accounts data pick-up method of XBRL intelligence reporting platform, which is characterized in that
The report value table includes: row ID, column ID, path, the fact for storing the report value extracted and routing information, specific field
Period belonging to value, true value, report year information, entity ID and report 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 CN105335459A (en) | 2016-02-17 |
| CN105335459B true 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) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106844320B (en) * | 2016-12-27 | 2020-09-15 | 税友软件集团股份有限公司 | Financial statement integration method and equipment |
| CN111159173B (en) * | 2018-11-08 | 2023-04-18 | 王纹 | Method for constructing multidimensional semantic database |
| 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 |
Citations (3)
| 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) |
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8510259B2 (en) * | 2011-03-17 | 2013-08-13 | Xbrl Cloud, Inc. | XBRL database mapping system and method |
-
2015
- 2015-09-24 CN CN201510615299.6A patent/CN105335459B/en active Active
Patent Citations (3)
| 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) |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105335459A (en) | 2016-02-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105335459B (en) | Consolidated accounts data pick-up method based on XBRL intelligence reporting platform | |
| US8645332B1 (en) | Systems and methods for capturing data refinement actions based on visualized search of information | |
| CN104361018B (en) | Electronic archives information reorganization method and device | |
| CN103810224B (en) | information persistence and query method and device | |
| CN103631842B (en) | For detecting the method and system of multiple row compound keys row set | |
| CN110297866A (en) | Method of data synchronization and data synchronization unit based on log analysis | |
| CN103593336B (en) | Knowledge pushing system and method based on semantic analysis | |
| CN107679146A (en) | The method of calibration and system of electric network data quality | |
| CN104866426A (en) | Software test integrated control method and system | |
| CN108280051A (en) | Detection method, device and the equipment of error character in a kind of text data | |
| AU2015331030A1 (en) | System generator module for electronic document and electronic file | |
| CN102110102A (en) | Data processing method and device, and file identifying method and tool | |
| US20110264703A1 (en) | Importing Tree Structure | |
| CN108009223B (en) | Method and device for detecting consistency of transaction data | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| CN106997350A (en) | A kind of method and device of data processing | |
| CN113722472A (en) | Technical literature information extraction method, system and storage medium | |
| CN112214609B (en) | Audit method and system based on knowledge graph | |
| KR102243794B1 (en) | Data integration device and data integration method | |
| CN110019139A (en) | Method, apparatus, electronic equipment and the storage medium of Data Migration | |
| CN116226108A (en) | Data management method and system capable of realizing different management degrees | |
| CN110147396B (en) | Mapping relation generation method and device | |
| CN106933783A (en) | A kind of method and device on the intelligent extraction date from text | |
| CN114863463A (en) | Intelligent auditing and checking method and device for same text | |
| CN114185958A (en) | Blood relationship generation method and device, computer equipment and storage medium |
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 |