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.