20
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

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


  • 54 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Track x martin deville ubmatrix europe lessons from implementing xbrl collection systems

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


Three recent xbrl projects

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……


Xbrl document processing service

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


3 simple lessons

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


Taxonomy design

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


Levels of xbrl validation

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


Extend quality checks with xbrl formulas

Extend Quality Checks with XBRL Formulas

Embedded XBRL Processor enables execution of XBRL formula validation

Public Validation Criteria

Private business rules and compliance


Performance

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


Effective data management is at the core of an xbrl system

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


Ubmatrix xbrl database adapter xda

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


Fact query example

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


Xbrl storage model in xpe upgrade path

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


Conclusions

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


  • Login