CEBS Data Model
From XBRLWiki
Revision as of 13:18, 3 December 2009 (edit) Katrin (Talk | contribs) (→Measures) ← Previous diff |
Revision as of 13:57, 3 December 2009 (edit) Katrin (Talk | contribs) (→Dimensions) Next diff → |
||
Line 39: | Line 39: | ||
====Dimensions==== | ====Dimensions==== | ||
+ | "By" conditions are called dimensions. Dimensions are views for which data should be stored. | ||
====Domain==== | ====Domain==== |
Revision as of 13:57, 3 December 2009
Contribution dated 2009-11-03
ALL TOPICS ARE STILL ON DISCUSSION!
Contents |
Abstract
This document should help users of the CEBS taxonomie (COREP and FINREP) to understand the Matrix Schemas published on www.eurfiling.info web site. In the following the basic aspects of the mulitdimensional data models are explained.
Multidimensional terminology
Description
Most of the data presented in tables can be divided in different categories or rather breakdowns. In the table below the gross revenue is broken down by product group and country. The information contained is far more detailed as showing only the aggregated sum of gross revenue and allows therefore a more comprehensive analysis. Multidimensionality is widely used for cost accounting and the corresponding supervision.
The table shows a two dimensional view on the data but in fact three dimensions are included.
Measures
The data that is analysed often in aggregations are called maeasures because they are (mostly) numeric values and measureable. Having only gross revenue and a value is not enough to interpret the data so they are analysed by using "by" conditions. Those "by" conditions are reflected in the example above "by" product group and "by" country.
Multidimensional data is often shown as three dimensional cube. The restriction on three dimensions is based on the limitations of the graphical representation.
A cell in the cube corresponds to a cell in the table.
Dimensions
"By" conditions are called dimensions. Dimensions are views for which data should be stored.
Domain
Matrix Schema readme
FINREP Matrix Schema 2.0
This is the working area for Data Model and Matrix Schemas. The original documents are stored at Eurofiling Google Group