DPM ARCHITECT FOR XBRL UPDATE DEMO Vctor Morilla

DPM ARCHITECT FOR XBRL: UPDATE & DEMO Víctor Morilla Banco de España XBRL WEEK Frankfurt, 13 December 2012 INFORMATION SYSTEMS

DPM ARCHITECT FOR XBRL taxonomy editor aimed at BUSINESS USERS Based on the DPM approach and DPM XBRL Architecture Currently on its last stage of development Distributed to a small group of beta testers Successfully used for the development of the PDH taxonomy in production since August Provided for free INFORMATION SYSTEMS 2

TAXONOMY DESIGN IN 2005 Business experts Templates provided by the business experts in excel format Model defined from the analysis of templates by IT experts, with limited support of business experts Data points not fully qualified: different interpretations in different countries IT experts Creation of taxonomy files by IT experts with tools for XBRL experts. Lack of a representation of the model that can be reviewed by business experts !!! Taxonomy files INFORMATION SYSTEMS 3

TAXONOMY DESIGN IN 2012 Business Groups Domain experts have taken over the leading role of the design of the models !!! Matrix DPM Matrix schemas (analysis temp) schemas XBRL Experts ∆Time Clear separation of roles A set of rules establishes the map between the components of the model and its XBRL representation: DPM XBRL Mapping document Taxonomy INFORMATION SYSTEMS 4

COMPUTER AIDED DESIGN OF FINANCIAL MODELS Link between the model and taxonomy elements Model design Rules Data Point Model Taxonomy files DPM Architect for XBRL INFORMATION SYSTEMS 5

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 6

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 7

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 8

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 9

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 10

EXTENSIBLE EBA EIOPA ECB UK FSA Bundesbank INFORMATION SYSTEMS 11

DPM ARCHITECT FOR XBRL FEATURES User oriented view of the DPM Speaks XBRL: not a code generator Unified view of taxonomies Multilanguage (English and Spanish) Takes advantage of XBRL extensibility in a simple way Powerful formulae editor INFORMATION SYSTEMS 12

DPM ARCHITECT: OTHER FEATURES Validation rules report: Document with validation rules of a taxonomy and its description Tables & model link documentation Changes report Usage matrix EBA Database Export INFORMATION SYSTEMS 13

STATUS AND NEXT STEPS Last stages of development: -Concurrent work on a shared folder -Reports and EBA DB Export -Intensive testing on formulae and some pending filters -Error messages -Documentation -Bug fixing Already distributed to a closed group of beta testers -More beta testers welcomed -Feedback welcomed, but please, specify problems found as clear as possible providing steps to reproduce the problem INFORMATION SYSTEMS 14

NEXT RELEASES Future plans: -Tests of formulae with data -Automatic generation of regression tests -More flexibility loading taxonomies -Adaptation to changes on the Table Linkbase Spec. -New features of the Formulae Spec. -Definition of API interfaces for extensions INFORMATION SYSTEMS 15

DRAFT LICENSE Tool and source code to be provided for free -Source code in English -User manual in English -Technical documentation in UML Modifications on the source code are allowed, but: -Source code modification allowed for internal usage -We want to avoid forks of the code during the first stagesof the tool: -Redistribution of other changes or additions will NOT be allowed during the first stages of the tool, unless using the extension APIs -After the initial phase, the source will be released under a GPL / MPL type license INFORMATION SYSTEMS 16

WANT TO HELP? Possibility of having a joint contract for the maintenance / support of the tool Possibility of providing resources Possibility of sponsoring an on-line tutorial IF YOU FIND THE TOOL HELPFUL, LET US KNOW !!! INFORMATION SYSTEMS 17

THANKS FOR YOUR ATTENTION INFORMATION SYSTEMS