1 / 14

Track x, Martin DeVille, UBmatrix Europe Lessons from Implementing XBRL Collection Systems

20 th XBRL International Conference “XBRL: Linking Businesses, Public Regulators & Citizens” April 20-22, 2010 Rome, Italy. Track x, Martin DeVille, UBmatrix Europe Lessons from Implementing XBRL Collection Systems. Three Recent XBRL Projects.

kemal
Download Presentation

Track x, Martin DeVille, UBmatrix Europe Lessons from Implementing XBRL Collection Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 20th XBRL International Conference“XBRL: Linking Businesses, Public Regulators & Citizens”April 20-22, 2010Rome, Italy Track x, Martin DeVille, UBmatrix Europe Lessons from Implementing XBRL Collection Systems

  2. Three Recent XBRL Projects The lessons draw on 3 recent UBmatrix Projects: • DICO (SQL Solutions) • Financial Authority System for monitoring banks • COREP style taxonomy • Ministry of Finance – Belgium (CSC/Aguilonius) • Corporate Tax Collections • 600,000 filings • European Financial Supervisor • Collecting COREP and FINREP for 300 banks Oh and many, many others……

  3. XBRL Document Processing Service Taxonomy Designer Taxonomy Manager Downloads Mapping Tool Document Viewer Standard Reports & Aaalysis Document Viewer Management Dashboard Analytics & Exception Reporting Reporting Manager FRONT OFFICE Portal Gateway Taxonomy Management 1. BACK OFFICE Application Database Company 1 XBRL Document Database XBRL Translator XBRL Translator 5. Document Validation XBRL Forms Taxonomies and Templates XBRL Document Archive 7. No XBRL Generator XBRL Processing Engine Query & Viewing 6. XBRL Document Capture XDA Company 2 2. Report Builder Document Processing 4. 3. Validation Report

  4. 3 Simple Lessons • It’s the Taxonomy………..Stupid! • Taxonomy architecture harmonisation and best practices • Validation, Validation, Validation • Calculation Linkbases, Formulas, etc. • What do the filers get out of it filers • OK where do you want this then? • (You need somewhere to store those documents where you can access them easily) • XBRL Storage – how to do it? (ODS vs. DW/OLAP) • Oh plus… • Inline XBRL • Versioning

  5. Taxonomy Design • …. Is it ART? • Truism: No XBRL Project can be successful without the right taxonomy • So .. why do so many projects start with someone new to XBRL playing with a complicated data modelling tool? • Why do so many projects not follow best practice? • …..or use common patterns? • Why do designers not test their taxonomies by trying to create a filing against them. • And why do so very few consider: • Taxonomy Management and Maintenance • Review teams and quality control

  6. Levels of XBRL Validation • Beginning balance must = Prior period ending balance • Is this periods number greater or lesser by a factor of 100 of previous period • Is a company changing the way they report • What are common taxonomy extensions Consistency Accuracy • Balance sheets must balance • Roll Forward validation • Sub-Totals must equal sum of children • All concepts are referenced • Company identity elements must be reported • Report x if reported y • Sub-Totals must be reported • Companies shall provide absolute paths for references to base taxonomies and relative paths for extension taxonomies Completeness • Duplicate facts not allowed • XML Valid • XBRL Valid • Naming standards followed • XML Valid • XBRL Valid Correctness Instance Rules Taxonomy Rules

  7. Extend Quality Checks with XBRL Formulas Embedded XBRL Processor enables execution of XBRL formula validation Public Validation Criteria Private business rules and compliance

  8. Performance Throughput vs. Processing speed (per document, per fact) Evaluate different processor functions – Load, Validate, Calculate, Render, Close. Impact analysis of excessively large and complex documents Dimensions Impact of single and multi-threading CPUs Impact of Formula processing Intelligent caching Flexible architecture Number of documents that can be validated in 1 hour

  9. Taxonomy Design Taxonomy Management Downloads ETL Mapping Tool Document Viewer Standard Reports and Exception Reporting Business Intelligence Tools Management Dashboard Reporting Manager Effective Data Management is at the Core of an XBRL system FRONT OFFICE Portal Gateway Taxonomy Management BACK OFFICE Application Database Company 1 XBRL Database XBRL Translator XBRL Translator Document Validation E-Forms Taxonomies and Templates XBRL Document Archive No XBRL Generator XBRL Processing Engine Analysis XBRL Document Capture Analytical Database XBRL Reporting Tables Company 2 XBRL Generator Document Processing Validation Report

  10. UBmatrix XBRL Database Adapter (XDA) • UBmatrix XDA adopts a ‘Hybrid’ approach • Stores XBRL document as file in the database • Stores XBRL data in a ‘generic’ database table structure • Semantics from the Taxonomy and Instance document are persisted into a relational data store, e.g. • Labels and Documentation • Extended Links • Presentation Order • Dimension Details (applicability and order) • Can add multiple taxonomies without adding any additional table structures • Provides a performant XBRL operational data store • Simple load for validated documents • Performant cross document analysis • Platform for more analytical reporting approaches • Database independent • Today, supports Oracle 10g and above and DB2 V9 XBRL Database Taxonomies and Templates XBRL Document Archive XBRL-Reporting Tables

  11. Fact Query Example • Instance Document Based Query • Fact Based - Traditional SQL Queries • Examples • Total Assets for IBM for 2007 • Entity with Total Assets > $1B • Leverage Taxonomy • Taxonomy Labels, Language, Dimensions

  12. XBRL Storage Model in XPEUpgrade Path UBmatrix XDA Store as Native XML with SQL Access Hybrid Storage (Document + SQL tables) Traditional Approach Ease of Use Store as Binary Object Oracle & UBmatrix Storage Solution XPE/EAS 2.x XPE/EAS 3.x XPE/EAS tbc

  13. Conclusions • Choosing and effective XBRL solution • Choose a taxonomy independent solution • Select XBRL tools that will support the complete XBRL standard • XBRL Dimensions • XBRL Formulas – business rules • Versioning – multiple versions of taxonomy • Implement on a flexible platform • Ability to process XBRL documents in numerous ways • Ability to support large-scale implementations • Ability to integrate into existing applications and environments • Any new technology involves a learning curve and RISK • Need experienced and reliable implementation partners • Need proven software that will evolve to meet future needs

More Related