ORIENTADOS HACIA UNA BANCA INTELIGENTE PROYECTO Obtencin y

ORIENTADOS HACIA UNA BANCA INTELIGENTE PROYECTO “Obtención y formateo de datos financieros contables para organismos reguladores, así como para Entidades o empresas terceras” Copyright © 2005, INFODESA

Agenda Our approach Financial Institutions Information Environment Corporate DW and XBRL Synergy Architecture Copyright

“. . XBRL permits the automated, efficient and reliable extraction of information by software applications. XBRL facilitates the automated comparison of financial and other business information, accounting policies, notes to financial statements between companies, and other items about which users may wish make comparisons that today are performed manually. XBRL facilitates "drill down" to detailed information, authoritative literature, audit and accounting working papers. XBRL includes specifications for as much information about the reporting entity as may be relevant and useful to the process of financial and business reporting and the interpretation of the information. . ” XBRL Recommendation 2003 -12 -31 + Corrected-Errata-2005 -11 -07 Copyright © 2005, INFODESA S. A.

• FSI Data Architecture: – Information Flow between providers and consumers – Detail,

Information Flow Channels Product LOB´s Marketing Accounting MIS Risk Planning Treasury BOD Finance Copyright

Information Flow Channels Product LOB´s Regulatory Marketing Accounting MIS Operational Risk Strategic Planning Treasury BOD Finance Operational Decision Support Strategic Decision Support Copyright © 2005, INFODESA S. A.

Information Flow Channels Products LOB´s Regulatory Marketing Accounting MIS Operational Risk Strategic Planning Treasury

Information Topology Marketing Channels Products LOB´s MIS DMj Risk Treasury G/L Finance DMn DMk Corporate DW SORz Core SOR Marketing Channels Products LOB´s SORx MIS Risk Copyright © 2005, INFODESA S. A. SORy Treasury G/L Finance

Information Topology Marketing Products LOB´s Channels MIS Risk Treasury G/L Finance OLAP or XBRL Access XBRL PRESENTATION LAYER DMj DMk XBRL Instances PROPAGATION LAYER Instance Management DMa DW Extension Taxonomies DTS Acquisition TRANSFORMATION LAYER SORz Core SOR Marketing Channels Products LOB´s SORx MIS Risk Copyright © 2005, INFODESA S. A. SORy Treasury G/L Finance

Information Topology Marketing Channels Products LOB´s MIS Risk Treasury G/L Finance OLAP or XBRL Access XBRL PRESENTATION LAYER DMj DMk XBRL Instances PROPAGATION LAYER Instance Management Corporate DW DW Extension Taxonomies DTS Acquisition TRANSFORMATION LAYER SORz Core SOR Marketing Channels Products LOB´s SORx MIS Risk Copyright © 2005, INFODESA S. A. SORy Treasury G/L Finance

Data Architecture Metadata Source Transformation Rules Arithmetical & Logical Rules SOR-DW Source Information Data Primitives Concepts Presentation Rules RDBMS Instances Datawarehouse “Image” of DTS and XBRL Instances Copyright © 2005, INFODESA S. A. XBRL”S” Instances

Data Architecture Metadata Source Transformation Rules Arithmetical & Logical Rules SOR-DW Source Information Primitives Concepts Presentation Rules RDBMS Instances Metamodel Datawarehouse (3 NF) “Image” of DTS and XBRL Instances Copyright © 2005, INFODESA S. A. XBRL”S” Instances

Data Architecture Source Transformation Rules Arithmetical & Logical Rules SOR-DW Source Information Primitives Concepts Presentation Rules RDBMS Instances Relationships (definition & ERA type) Primitive Entities Primitive Attributes primitive and derived concepts Relationships (definition) Copyright © 2005, INFODESA S. A. XBRL Instance “Mirror” XBRL”S” Instances

Data Architecture Source Transformation Rules Arithmetical & Logical Rules SOR-DW Source Information Primitives Concepts Definition Relationships Filters, Formulas and Functions ERA Relationships Presentation Rules RDBMS Instances Calculation Relationship Copyright © 2005, INFODESA S. A. Presentation Relationships XBRL”S” Instances

Data Architecture Source Transformation Rules Arithmetical Rules Presentation Rules Arithmetical & Logical Rules 1 SOR-DW Source Information 2 Primitives 4 Concepts 8 7 5 RDBMS Instances 6 XBRL”S” Instances 3 1 Data Transformation 2 Build Concept 3 Derive new concepts in DTS boundaries 4 Present Information 5 Map XBRL Instance 6 Input external XBRL info and map to RDBMS 7 Insert concepts 8 Update primitives Copyright © 2005, INFODESA S. A.

Data Architecture Source Transformation Rules Arithmetical & Logical Rules SOR-DW Source Information Primitives Concepts Presentation Rules RDBMS Instances RDBMS TECH XBRL”S” Instances XBRL TECH 2 nd Scope Copyright © 2005, INFODESA S. A. 1 ST Scope

Component Architecture “DTS” Datawarehouse Extension ERA-DTS Metadata Services SOR-DW Source Information XBRL”S” Instances Primitives

Component Architecture “DTS” Datawarehouse Extension ERA-DTS Metadata Services Propagation Services SOR-DW Source Information Presentation Services XBRL”S” Instances Primitives Concepts RDBMS Instances Transformation Srvices XBRL Mapping Computing Services Copyright © 2005, INFODESA S. A.

Component Architecture “DTS” Datawarehouse Extension ERA-DTS Metadata Services Propagation Services SOR-DW Source Information Presentation Services XBRL”S” Instances Primitives Concepts RDBMS Instances Transformation Services XBRL Mapping Computing Services Copyright © 2005, INFODESA S. A.

Component Architecture “DTS” Datawarehouse Extension ERA-DTS Metadata Services Propagation Services 1 SOR-DW Source Information Presentation Services 5 6 XBRL”S” Instances Concepts Primitives Transformation Services 2 8 1 Data Transformation 2 Build Concept 3 RDBMS Instances 4 7 Computing Services XBRL Mapping 5 Map XBRL Instance 6 Input external XBRL info and map to RDBMS 3 Derive new concepts in DTS boundaries 7 Insert concepts 4 Present Information 8 Update primitives 9 DTS acquisition Copyright © 2005, INFODESA S. A.

Architecture Framework Extended Financial Information Architecture ERA-DTS Metadata Services Propagation Services SOR-DW Source Information Presentation Services XBRL”S” Instances Primitives Concepts RDBMS Instances Transformation Services XBRL Mapping Computing Services Copyright © 2005, INFODESA S. A.

Architecture Framework Marketing Channels Products LOB´s MIS Risk Treasury G/L Finance OLAP or XBRL Access XBRL PRESENTATION LAYER DMj DMk XBRL Instances PROPAGATION LAYER Instance Management Corporate DW DW Extension Taxonomies DTS Acquisition TRANSFORMATION LAYER SORz Core SOR Marketing Channels Products LOB´s SORx MIS Risk Copyright © 2005, INFODESA S. A. SORy Treasury G/L Finance

Thanks for your attention INFODESA S. A. Avenida Cerro del Águila, 1 28700 S. Sebastián de los Reyes Madrid Tlf. 91 655 95 50 Fax 91 676 34 48 infodesa@infodesa. es www. infodesa. es Copyright © 2005, INFODESA S. A.