Open community of practice for filing and XBRL with Open Source
Header image

Academy

Academic Track @ Eurofiling XBRL Week, Frankfurt  2017. June, 7th – 8th visit academy2017.openfiling.info

Academic Track @ Eurofiling XBRL Week, Frankfurt 2016. June, 1st – 2nd

The academic track at the XBRL Week provides a platform for academics from around the world to present their established research projects and new research ideas. The academic track allows academics to receive feedback from the professional XBRL community and, in turn, inform the broader XBRL community and to contribute to the improvement and usability of the standard. Papers and extended abstracts are sought for the academic track. Papers are welcome on any aspect of XBRL technology, adoption, or application. Outlines of proposed research projects and early stage research are particularly welcome.

Proposals should be submitted by May, 1st 2016 to the track chairs,

Abstracts/papers received will be immediately reviewed by an internal panel, with the notification of acceptance/rejection being issued no later than May, 10th 2016. Speakers of accepted abstracts/papers have full conference access at no charge (travelling and accommodation expenses have to be covered individually). We intend to publish conference proceedings with the accepted papers. More information at Academic Track @ XBRL Week, FrankfurtEurofiling and XBRL Europe.

Doctoral Thesis: Framework for multidimensional definition of the data model, structure, taxonomies and rules of the XBRL specification

Next February 10th, 2016, at 12:00 pm will be hold the defence of Ignacio Santos of his Doctoral Thesis in English, in the Carlos III University of Madrid, Computer Science Department, Leganés (Madrid), Spain, in a public act. Carsten Felden, PhD (Technische Universität Bergakademie Freiberg), is member of the tribunal.

UC3M

The author of this thesis invites everyone interested in to take part in the discussion of the defense of the thesis. In any case, if anyone wants to read and comment the thesis, the link is here, in DThesis_I_Santos_Forner or TDoctoral_I_Santos_Forner, please for more information send an e-mail to Ignacio Santos (ignacio.santos@bde.es) and he will send you an e-mail with your inquiries.

Aims of this thesis:

– These reports are designed almost exclusively by economists, accountants, or financial according to their needs.
– The specification is extended according to expert user’s requirements for new elements.
– The specification has been growing and complicated.
– This specification is currently very actively used.
– Financial statements are governed by strict requirements.
– XBRL is used instead of XML, since reports have specific semantics of the IFRS or the GAAP.
– These reports can be large, since taxonomies are created with many concepts and user rules or constraints.
– When the reports are very large, this generates problems in implementation (especially in performance at run-time) using existing XML technology, especially in the validation of the documents.
– Many reports present design errors.
– No public test cases.
– Lack of interoperability.
– Supervisors and / or regulators are continually creating larger and more complex models.
– Complexity of both knowledge and infrastructure specification.

Conclusions of the thesis

– The reports are designed by economists, accountants, or financiers. The main purpose of this thesis is the development of the entire life cycle metadata model using a robust technology as the MDA, non-existent to date.
– Therefore, it facilitates the extension of new elements and / or modifications that using this methodology.
– These reports, which may become large, can be implemented directly in databases. In principle, the implementation of these reports in a database manager can avoid the limitations of processing large reports in XBRL. It is a robust technique that allows for performance monitoring during implementation and subsequent tuning analysis.
– The establishment of a data model design lifecycle ensures fewer errors in the design, since it has been proven in testing concepts and validation, and facilitates the possibility of test cases, because semantic issues or anomalies are analysed.
– This thesis has validated the interoperability of this technology by studying its design. Moreover, it shows how this model can be implemented in different databases of different vendors and even enables mapping to other platforms.
– By using the MDM and OLAP technologies, this research work is helping to simplify complexity, without being less robust, and although the required infrastructure is not any cheaper, it can be shared by other applications.

XBRL Formula Specification in the Multidimensional Data Model.

In the journal Information Systems (JCR,Q2), volume 57, April 2016, pages 20–37 (Now on-line). Authors: Ignacio Santos (ignacio.santos@bde.es, Bank of Spain) and Elena Castro PhD (Carlos III University of Madrid).

Abstract:

XBRL is a specification used to exchange financial/economic information. It is actively used by many international institutions and agencies. In the USA, Canada, Europe, China, etc. all financial entities and companies quoted on the stock market have to report compulsorily to the supervisory and regulatory authority using the XBRL specification. XBRL consists of a set of taxonomies defining different accounting regulations for a specific statement and the statement itself. Reports are generated from various sources and are validated at origin. XBRL displays business information which is multidimensional and whose logical destination for storage is a data warehouse. The proposal presented here focuses on the automation of the mapping between XBRL and the multidimensional data model (MDM) and includes a formalization of the validation rules in the MDM. The approach is designed in accordance with the Model Driven Architecture (MDA) paradigm which consists of a new way to validate XBRL reports through an RDBMS, and offers a proof-of-concept. Additionally, the study aims to provide more clarity about XBRL, a highly complex language made by and for expert users, and to improve interoperability between applications. The proposal also analyses certain semantic questions associated with the XBRL formula specification and its performance.

Paper: Information Systems.

Validation of Semantic Economic / Accounting / Financial Reports and its Implementation in Database, in an automated way.

Final Project of the Polytechnic School of the Carlos III University of Madrid, Spain., October 13th, 2015.

Author: Abel Nieto-Cano (abel.nieto.cano@avanade.com); tutors: Ignacio Santos (ignacio.santos@bde.es) and Elena Castro (ecastro@inf.uc3m.es).

Abstract:

This document consists of 8 sections, except the bibliography and glossary. The first
section is Introduction and basic concepts and define the scope and objectives of the project. The second section refers to the software requirements and hardware used to develop and deploy their work. The third section shows the metamodel defined by the
European Banking Authority (EBA) through taxonomies FINREP (Financial Report) and COREP (Common Solvency Report) both are a metamodel of the reports required by the Banking Regulation and mapping a relational model (implemented in MS SQL Server 2012). The fourth section is a study of the architecture of XBRL, the database table structure as a step towards a management system more appropriate data base (MS SQL Server 2012). Section five conditions and technology used for validation of data Point Model (DPM) and pass data to the relational model are defined, the validation tests conducted are also defined. The sixth section the conditions used for mapping data Point Model (DPM) to a multidimensional data model (MDM) MDM and implemented in a relational database is defined. The seventh section concerns the future work and improvements to the project defined in this document. The eighth and final section covers the feasibility study, project planning and budget.
It is expected that the reader has a knowledge of DPM, as well as basic knowledge of
XBRL, although this work will introduce two models. It is also expected that the reader may have knowledge in the creation of conceptual models for relational databases and multidimensional data.

Presentation in Spanish,PresentationPFC. Final Project in Spanish:  Final_Project.

 

 

Formal Validation of Data Point Models.

Proof of Concept about the validation of EBA DPM, in XBRL week in Brussels, Eurofiling Workshop, Techies’track, November 26th, 2014. Banque Nationale de Belgique/Belgische National Bank, Brussels, Belgium.

Authors: Ignacio Santos (ignacio.santos@bde.es) and Abel Nieto-Cano (abel.nieto.cano@avanade.com), Carlos III University of Madrid, Spain.

Abstract:

The Data Point metamodel consists of:

  • Sets of necessary Data Points or facts in the European Supervisory reports.
  • Definitions and rules of expert users (Supervisor/Regulators).
The main objective of this validation is to ensure the ability of the DPM to be used and to accomplish the design objectives. The validation of conceptual models at early phases of their development can help correct faults in the design at a point where they may still be corrected with relative ease. From the templates in the spreadsheets are obtained: data type, domains, concepts, primary items, dimensions, etc. This proof uses the framework release 09/2013, applicable as of March 2014 (DPM data base 2.0).

Presentation,FormalvalidationofDPM_v2. Proof of concept:DEploy Validacion DPM EBA 2.0_Englsh. The deploy is DEployValidacionDPM_rar and the databases DPM Database_1rar and DPM Database_2rar, You have to change “…rar.txt” by “… .rar”.

 

Error Handling: Formulas expressed in Natural Language.

Comments presented in the workshop titled “Error handling, panel”, in XBRL week in Rome, May 5th, 2014.

Author: Ignacio Santos (ignacio.santos@bde.es).

Abstract:

These slides analyse the validation of the design with expert users, in the XBRL formula specification. Since, as each concept has a description, it is possible to define the facts, formulas or assertions in natural language, so the business user can understand and verify the developed design better. However, this proposal has to be developed in future works.

Slides : Formulas_NL .

 

Road map of the MDM (implemented in a design ROLAP) of FINREP 2012 and Solvency II (01-07-2012) with validations, Proof of Concept.

Final Project of the Polytechnic School of the Carlos III University of Madrid, Spain. Date: November 14th, 2013.

Author: Camelia Cid Canelada (100000188@alumnos.uc3m.es); tutors: Ignacio Santos (ignacio.santos@bde.es) and Elena Castro (ecastro@inf.uc3m.es).

Abstract:

This work consists of mapping XBRL instance documents in a relational database using a tool ROLAP and its validation, and it is an updated and improved of the proofs the concept presented until now.

This project has an aim that is to automate the map of the taxonomies, so that any taxonomy can run with the solution of this project and get the data into SQL. This work analyzes the taxonomies FINREP 2012 and Solvency II, and their formulas but with the information published to date, and has also been analyzed FINREP 2012. Moreover, this paper shows the analysis of the technical solution, system requirements, use case, identifying the subsystems, design of the system engineering, architecture, physical design of the data, implementation of the solution (program development, algorithms), trial games, evolution and results, planning, budgeting and conclusion and future work.

Documentation : Guide . Set of scripts: Scripts(Please, it is necessary to change “ScriptsTotales_rar.txt” by “ScriptsTotales.rar”).

 

 

Data Point Model (DPM) versus Multidimensional Data Model (MDM).

Contribution for the DPM chapter in CEN WS XBRL Plenary Session, Dublin. Friday, April 19th, 2013. Hosted by the Central Bank of Ireland.

Author: Ignacio Santos (ignacio.santos@bde.es).

Abstract:

In this presentation are showed the basic lines of the mapping of the DPM to Multidimensional Data Model.

Slides: DPM versus MDM .

Automation and mapping from the data model of the XBRL specification in Database.

Final Project of the Polytechnic School of the  Carlos III University of Madrid, Spain. Date: October 4th, 2012.

Author: Yolanda León Román (y.leon@alumnos.uc3m.es); tutors: Ignacio Santos (ignacio.santos@bde.es) and Elena Castro (ecastro@inf.uc3m.es).

Abstract:

This work consists of mapping XBRL instance documents in databases and vice versa and its validation, and it is an updated and improved of the proofs the concept filed to date.
The development of this project came about through various European directives that will take effect in 2014 for sending financial reports to supervisors. The objective of this project is the transformation of XBRL taxonomies to the SQL database. In this transformation, three different milestones are analyzed:

  • Uploading the metadata in the database.
  • Loading facts in Database.
  • Validating XBRL instance documents in database.

This project has an aim that is to automate the map of the taxonomies, so that any taxonomy can run with the solution of this project and get the data into SQL. This work analyzes the taxonomies FINREP 2012 and Solvency II, and their formulas but with the information published to date, and has also been analyzed FINREP 2012. Moreover, this paper shows the analysis of the technical solution, system requirements, use case, identifying the subsystems, design of the system engineering, architecture, physical design of the data, implementation of the solution (program development, algorithms), trial games, evolution and results, planning, budgeting and conclusion and future work.

Documentation and work: Documents (Please “automation_txtrar.txt” by “automation_txt.rar”). Document in Spanish: Library of Carlos III University of Madrid.

Validation of a XBRL Document Instance in a RDBMS. Proof of Concept.

15th EuroFiling Workshop: International Reporting. May 31st – June 1st, 2012. Banco de España (Bank of Spain), Madrid, Spain. The web site is: “http://www.eurofiling.info/15th_workshop/index.shtml“.

Authors: Ignacio Santos, Banco de España (Bank of Spain), 522, Alcalá street, Madrid, Sapin (ignacio.santos@bde.es). And Elena Castro, Carlos III University of Madrid, Computer Science Department. Avda. de la Universidad Nº 30, 28911 Leganés, Madrid, Spain (ecastro@inf.uc3m.es).

Abstract:

In the last ten years has been a great increase in the development in XML applications and the Data Warehouse applications. Moreover, these applications need to interact with different technologies. The economic data in this same period have also evolved, increasingly companies and financial institutions need more information, in addition, this information must be reliable, and on-time. Nowadays, the use of the eXtensible Business Reporting Language (XBRL) standard, based on XML continues to rise significantly. This language is mainly used in accounting reports. It consists of a set of taxonomies, which define different accounting regulations of a specific report. XBRL is becoming a global de facto standard. The XBRL reports are created from various sources and are validated at origin, so that this report is syntactically correct. XBRL represents business information, and is multidimensional, and therefore the logical destination is a Data Warehouse (DW). This research proposes to automate the mapping between XBRL, and the Multidimensional Data Model (MDM). Moreover, we propose a new mapping in the validation rules from XBRL (XML) to Multidimensional Model. In the past, we proposed the necessary structures and its semantic rules of the XBRL Data Model (XBRLDM) in the MDM. Presently, we propose the validation rules in the MDM, and formalization these rules, including definitions mathematic. And to provide a second way to validate XBRL reports through a RDBMS. But at the same time, one of the aims of this research is to provide more clarity to this complex language, made by and for business users. This research work will improve the interoperability among applications (e-government and others projects).

Presentation: Document with presentation. Guide: Document with the guide. Scripts: Set of file in rar format (Please you have to change “rar.txt” by “.rar”).

XBRL Interoperability through a Multidimensional Data Model

IADIS International Conference on Internet Technologies & Society (ITS 2011) Shanghai, China, from 8th – 10th , December 2011 (hosting “East China Normal University”). The web site is: “http://www.its-conf.org/“.

Authors: Ignacio Santos and Elena Castro, Carlos III University of Madrid, Computer Science Department. Avda. de la Universidad Nº 30, 28911 Leganés, Madrid, Spain.

Abstract:

The last ten years have increased a great development in XML and Data Warehouse applications. Moreover, these applications need to interact with different technologies. The economic data in this same period have also evolved, increasingly companies and financial institutions need more information, in addition, this information must be reliable and on time. Nowadays, the use of eXtensible Business Reporting Language (XBRL) standard, based on XML continues to rise significantly. This language is mainly used in accounting reports. It consists of a set of taxonomies, which define different accounting regulations of a specific report. XBRL is becoming a global de facto standard.  XBRL reports are created from various sources and are validated at source, so that this is syntactically correct. XBRL represents business information, and is multidimensional, and therefore the logical destination is a Data Warehouse (DW). This paper proposes to automate the mapping between XBRL, and the Multidimensional data model. In this work the necessary structures and its semantic rules are defined. But at the same time, one of the aims of this research is to provide more clarity to this complex language, made by and for business users. This research work will improve the interoperability among applications (e-government and others projects).

Keywords:

XBRL (eXtensible Business Reporting Language), XML (eXtensible Markup Language), Taxonomy, XDT (XBRL Dimensional Taxonomy), Conceptual Data Model, MDM (Multidimensional Data Model).

Presentation in the conference. This paper is in proceedings of IADIS International Conference on Internet Technologies & Society 2011, ISBN: 978-972-8939-55-7 © 2011 IADIS

 

Proof of Concept, XBRL report vs. RDBMS.

OpenFiling First Ordinary General Assembly, September 5th, 2011. Rome, Italy. Hosted by Banca d’Italia.

Authors: Ignacio Santos and Elena Castro (2011). E-mail: (ignacio.santos@bde.es, ecastro@inf.uc3m.es)
Computer Science Department, University Carlos III of Madrid, Leganés (Madrid), SPAIN

Abstract:

The XBRL reports entail that a large number of companies, economic and financial institutions have to spend a large amount of resources on Information Technology (IT). There is also a pressing need for these reports to be interoperable. This presentation presents a mapping between the XBRL data model, and the Relational data model. Our proposal is to automate this process. A XBRL instance document is transformed to a XBRL RDBMS, through the definitions of the XBRL language, and its taxonomy. And in same way from a XBRL database will be transformed to a XBRL instance document. We discuss both models. moreover, its structure and its semantic rules are defined. In addition, with this proposal, this complex language is simplified. We map the XBRL data model to Relational model. We propose a proof of concept, and it explains the set of phases of this mapping. As example we use an instance of the FINREP taxonomy of the last draft (http://www.eurofiling.info/finrepTaxonomy/taxonomy2012.html) .  In this paper the UML data model will be explain, its transformation to the Relational data model. The set of programmes, some consults that the business user need, and some transformations to Access are shown.

Presentation:Document with presentation. Guide: Document with the guide. Scripts: Set of file in rar format (Please you have to change “.pdf” by “.rar”).

 

XBRL Meta-metadata Model.

Final project of Computer engineering technology management, Carlos III University of Madrid. Date September 27th, 2011.

Author: Jorge Valencia Martínez (100033367@alumnos.uc3m.es); tutors: Ignacio Santos (ignacio.santos@bde.es) and Elena Castro (ecastro@inf.uc3m.es).

Abstract:

This final year project seeks to make a first approach to meta-meta model that defines the XBRL reporting language. It is a first step that will explore the concepts used in its definition, analyzing the metamodel itself on which it is based. The definition of this meta-metamodel is to define the existing objects, relationships, and even links to the XML language itself, as XBRL is based on XML. This project is part of a larger project of defining its conceptual model and to map this model to other conceptual models.

Presentation: pdf document. Document in Spanish: Library of Carlos III University of Madrid (“http://www.uc3m.es/portal/page/portal/library/”).

 

XBRL And The Multidimensional Data Model

In Proceedings of the 7th International Conference on Web Information Systems and Technologies, pages161-164. DOI: 10.5220/0003399001610164. Copyright c SciTePress. ISBN 978-989-8425-51-5.

Authors: Ignacio Santos and Elena Castro. E-mail: ignacio.santos@bde.es, ecastro@inf.uc3m.es.
Computer Science Department, University Carlos III of Madrid, Leganés (Madrid), SPAIN

Abstract:

Over the past ten years, there has been a significant increasing of the development of XML and Data Warehouse (DW) applications, and, in turn, more and more applications need to interact, and with different technologies. In parallel, the economic data in the last ten years have also evolved, increasingly companies and financial institutions need more information, in addition, this information must be reliable and on time. Nowadays, it is taking a significant rise for XBRL standard, based on XML. This language is mainly used in accounting reports and this consists of a set of taxonomies, which define different accounting regulations of a specific report. XBRL is becoming a global de facto standard.  XBRL reports are created from various sources and are validated at source, so that, this is syntactically correct. XBRL represents business information, and it is multidimensional, and therefore the logical destination is a DW. This paper aims to analyze the data model of XBRL and its semantics, and how to map this data model to the Multidimensional Data Model (Conceptual Model) and in turn to the Logical Model, either ROLAP (Relational OLAP), MOLAP (Multidimensional OLAP), or HOLAP (Hybrid OLAP), so they can be analyzed by business users.

Poster: Webist 2011.

XBRL, UML and Databases: State of Art

In XIII European Banking Supervisors XBRL Workshop, 24th – 25th November 2010, Luxembourg. Hosted by Commission de Surveillance du Secteur Financier, 110 route d’Arlon, L-2991 Luxembourg.

Authors: Ignacio Santos and Elena Castro. E-mail: (ignacio.santos@bde.es, ecastro@inf.uc3m.es)
Computer Science Department, University Carlos III of Madrid, Leganés (Madrid), SPAIN

Presentation: ModelingXBRLDatabse.

no