Data Model and Matrix Schemas
This presentation is the property of its rightful owner.
Sponsored Links
1 / 29

Data Model and Matrix Schemas PowerPoint PPT Presentation


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

Data Model and Matrix Schemas XI European Banking Supervisors XBRL Workshop in Vienna 19th November 2009 Katrin Schmehl Member of CEBS XBRL Network. Agenda. Multidimensional terminology Appliance on FINREP framework Overview on matrix schema. Multidimensionality of data.

Download Presentation

Data Model and Matrix Schemas

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


Data model and matrix schemas

Data Model and Matrix Schemas

XI European Banking SupervisorsXBRL Workshop in Vienna19th November 2009

Katrin Schmehl

Member of CEBS XBRL Network


Agenda

Agenda

  • Multidimensional terminology

  • Appliance on FINREP framework

  • Overview on matrix schema


Multidimensionality of data

Multidimensionality of data

Dimensional view on gross revenue


Multidimensionality of data measures

Multidimensionality of data - Measures

500

Gross revenue

Books

France

product group

500

country

measures

Measures: data mostly in numerical dimensions


Multidimensionality of data dimensions

Multidimensionality of data - Dimensions

500

Gross revenue

Books

France

product group

Other dimensions

country of origin

buying country

country

measures

Dimensions: views or objects for which data should be reported,

specific breakdown of a measure, ie. “by country”


Multidimensionality of data domain

Multidimensionality of data - Domain

500

Gross revenue

country

Books

France

France

Domain

Spain

Austria

Belgium

Sub domain

Germany

Italy

Domain: a set of items that have a specific coherence


Multidimensionality of data domain member

Multidimensionality of data – Domain member

500

Gross revenue

country

Books

France

France

Domain

Spain

Austria

Domain member

Belgium

Germany

Italy

Domain member: a specific member of a domain


Multidimensionality of data data point

Multidimensionality of data – Data point

Dimensional view on gross revenue

634


Multidimensionality of data data point1

gross revenue

product group

News papers

country

Spain

Multidimensionality of data – Data point


Multidimensionality of data data base

Multidimensionality of data – data base

Country

ID

name

Period

ID

year

month

day

Facts

ID_Product group

ID_Country

ID_Period

Gross revenue

Product group

ID

name

Dimensions have the character of keys for multidimensional data


Multidimensionality of data hypercube

Measure

Hypercube

Dimension1

Domain

a

b

c

d

Dimension2

Domain

A

B

C

D

gross revenue

product group

News papers

country

Spain

Multidimensionality of data - Hypercube

product group

country

measure

Hypercube: binds dimensions together in order to build a Cartesian product


Multidimensionality of data sections

Multidimensionality of data - sections

Dimensional view on gross revenue

by November 2009


Multidimensionality of data definition of sections

Multidimensionality of data – definition of sections

Dimensional views on gross revenue

Cartesian product

16 Combinations of one member of product group with one member of country

12 Combinations of one member of product group with one member of country and one member of book category


Multidimensionality of data definition of sections1

Multidimensionality of data – definition of sections

Same section (same extended link role)

Cartesian product defined by a hypercube

All

Set of

combinations

16 Combinations of one member of product group with one member of country

All

Set of

combinations

12 Combinations of one member of product group with one member of country and one member of book category

VALIDATION!

The intersection of both sets is null  no combination is allowed.


Multidimensionality of data definition of sections2

Multidimensionality of data – definition of sections

Different sections (different extended link roles)

Cartesian product defined by a hypercube

All

Set of

combinations

16 Combinations of one member or product group with one member of country

All

Set of

combinations

12 Combinations of one member or product group with one member of country and one member of book category

VALIDATION!

The union of both sets  every combination is allowed.


Agenda1

Agenda

  • Multidimensional terminology

  • Appliance on FINREP framework

  • Overview on matrix schema


Finrep data model measures and dimensions

FINREP Data model – measures and dimensions


Finrep data model measures and dimensions1

FINREP Data model – measures and dimensions

measures

dimension

dimension

dimension


Finrep data model definition of sections

FINREP Data model – definition of sections

Section 1

Section 2

Section 3


Finrep data model definition of sections1

FINREP Data model – definition of sections

Section 4


Finrep data model common elements

FINREP Data model – Common elements

  • Data points are repeated

    • Identification should be the same !

      • same primary

      • same dimensions

      • same dimension members

CONSISTENCY

STABILITY


Finrep data model movement tables

FINREP Data model – Movement tables

  • Data refers

    • to an instant in time (opening balance and closing balance)

    • to a duration in time (variations in time)

  • Possible solutions

    • Two primaries (two dimensions)

    • Primaries in the columns

    • Primaries in the rows

CONSISTENCY

STABILITY


Agenda2

Agenda

  • Multidimensional terminology

  • Appliance on FINREP framework

  • Overview on matrix schema


Matrix schema what is a matrix schema

Matrix schema – What is a matrix schema?

  • Representation of the multidimensional structure of XBRL taxonomies in Microsoft Excel

  • Generated by a reverse-engineering process of the Bank of Italy

  • Initially designed for reviewing COREP and FINREP taxonomies

    • Does XBRL match the business requirements?

  • Matrix schemas are used since several years in the CEBS XBRL Network

?

XBRL taxonomy

Matrix schema


Matrix schema how is it now used

Matrix schema – How is it now used?

FINREP tables

Data classification

?

XBRL taxonomy

Matrix schema


Matrix schema how should it be read

Matrix schema - How should it be read?

measures

reference to sub domains


Matrix schema the domain sub domain list

Matrix schema – The domain / sub domain list


Matrix schema the advantages

Matrix schema – The advantages

  • Easy to read and understand (in comparison to XBRL)

  • Very compact format

  • Eases the review process for the data classification

  • Shows the matching between business requirements and the data model to be implemented

    • Tool for quality assurance

  • Prospects: Consolidated matrix schema approach


Data model and matrix schemas

www.c-ebs.org

www.eurofiling.info

Katrin Schmehl

E-mail: [email protected]

The XBRL Network of the


  • Login