European XBRL Reporting Entities handbook

From XBRLWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 18:42, 17 June 2013 (edit)
Pieter.Maillard (Talk | contribs)
(XBRL: Extensible Business Reporting Language)
← Previous diff
Revision as of 18:57, 17 June 2013 (edit)
Pieter.Maillard (Talk | contribs)
(XBRL: Extensible Business Reporting Language)
Next diff →
Line 448: Line 448:
Such a representation of information is human-readable. However, it is not ideal for machine interpretation, as the data is contextualised by its layout on the page, rather than in a consistently structured manner.. Thus, we ask “How can we structure this information so that it can be transmitted and interpreted consistently?” For the purpose of this example, we’ll focus on the “Eligible Capital” line, highlighted in yellow in the above example. Such a representation of information is human-readable. However, it is not ideal for machine interpretation, as the data is contextualised by its layout on the page, rather than in a consistently structured manner.. Thus, we ask “How can we structure this information so that it can be transmitted and interpreted consistently?” For the purpose of this example, we’ll focus on the “Eligible Capital” line, highlighted in yellow in the above example.
 +
A first step would be to '''tag''' the amount of Eligible Capital in a way that it is '''directly linked to the concept''' of Eligible Capital: A first step would be to '''tag''' the amount of Eligible Capital in a way that it is '''directly linked to the concept''' of Eligible Capital:
Line 470: Line 471:
==XBRL Introduction== ==XBRL Introduction==
-XBRL, or e'''X'''tensible '''B'''usiness '''R'''eporting '''L'''anguage, is a communication standard developed in order to simplify the exchange of business and financial data.<br />+XBRL, or e'''X'''tensible '''B'''usiness '''R'''eporting '''L'''anguage, is a communication language developed for the standardised exchange of business and financial data.<br />
-XBRL normalises the '''format''' of data (via the use of XML techniques) en the '''validation''' of data (via XBRL taxonomies).<br />+XBRL normalises the '''format''' of the data (via the use of XML techniques) and the '''validation''' of data (via XBRL taxonomies).<br />
<center> <center>
Line 478: Line 479:
<br /> <br />
- +The interaction between taxonomies and instance documents is explained further in this document.
-XBRL also provides among others:<br />+XBRL also provides:<br />
:* Standard validation rules (mathematical and logical rules) :* Standard validation rules (mathematical and logical rules)
:* The use of label linkbases (which allows multi-lingual taxonomies) :* The use of label linkbases (which allows multi-lingual taxonomies)
-:* The possibility to provide rendering+:* Mechanisms for defining a human-readable rendering
:* Standard toolset which allow to work with XBRL :* Standard toolset which allow to work with XBRL
-During the following chapters XBRL is explained more elaborately. Try to give an insight in the following points:+During the following chapters XBRL is explained more elaborately. Topics covered:
:* XBRL Taxonomies :* XBRL Taxonomies
:* The extensibility of XBRL :* The extensibility of XBRL
Line 495: Line 496:
==XBRL Taxonomies== ==XBRL Taxonomies==
-An XBRL Taxonomy is the set of definitions of the concepts of a certain business domain. XBRL taxonomies are a collection of taxonomy schemas and linkbases.+An XBRL Taxonomy defines the concepts of a certain business domain and the relationships between them. XBRL taxonomies are a collection of taxonomy schemas and linkbases.
===Schemas=== ===Schemas===
-Based on XML Schema, a taxonomy schema defines business concepts with their most basic properties.+Based on XML Schema, a taxonomy schema defines business concepts and their basic properties.
-'''Each business concept is represented by an element of a schema.''' As a result, each business concept will have a qualified name (i.e. namespace plus local name). As previously explained, this will allow unique identification of the specific concept.+'''Each business concept is represented by an element in a schema.''' As a result, each business concept will have a qualified name (i.e. namespace plus local name). As previously explained, this will allow unique identification of the specific concept.
-All basic properties of a concept are expressed as element attributes. The values of these properties will determine how the concept is representing facts in an XBRL report. The most common properties are:+All basic properties of a concept are expressed as element attributes. The values of these properties determine how the concept will be used to represent concept values, known as “facts” in an XBRL report. The most common properties are:
-:* Data type: the type of value (monetary, value, percentage, text ...) that the can be assigned to the concept. Predefined XBRL types can be used or new ones can be defined (via the use of XML Schema). +:* Data type: the type of value (monetary, value, percentage, text ...) that can be assigned to the concept. Predefined XBRL types can be used, or new ones can be defined using of XML Schema).
:* Period type: generally, two period types are used in XBRL: :* Period type: generally, two period types are used in XBRL:
:** Instant: used for expressing facts which refer to a certain moment in time (e.g. an amount on a balance sheet) :** Instant: used for expressing facts which refer to a certain moment in time (e.g. an amount on a balance sheet)
-:** Duration: used for expressing facts which refer to a time interval (e.g. the amount of revenue for a certain period)+:** Duration: used for expressing facts which refer to a time interval (e.g. the revenue for a certain period)
In addition to these predefined properties, the flexibility of XBRL allows the creation of taxonomy-specific properties In addition to these predefined properties, the flexibility of XBRL allows the creation of taxonomy-specific properties
===Linkbases=== ===Linkbases===
-Linkbases permit the creation of relationships between elements and relationships between resources. A resource can be, for example, the name of a concept in specific language or a reference to a paragraph of a legal document.+Linkbases are used to define relationships between elements and relationships between resources. A resource can be, for example, the name of a concept in specific language or a reference to a paragraph of a legal document.
-These relationships are defined by using the XLink standard. Each link has a specific role. XBRM defines a set of predefined roles that are grouped into linkbases. Among these predefined roles are:+ 
-:* Label linkbase: assigns names to the concepts, which are defined in a schema per different language. Within each language, the same element can be called in different ways, depending on the context in which it is used.+These relationships are defined using the XLink standard. Each link has a specific “role”. XBRL defines a set of predefined roles that are grouped into linkbases. Linkbases in common use are:
-:* Reference linkbase: allow the inclusion of references to specific regulations. This can be the whole text of the regulation, or only a reference towards it.+:* Label linkbase: Used to assign labels to concepts defined in a schema. Multiple labels, perhaps in different languages or for different purposes (e.g. ''“Documentation”'', ''“Period Start”'', ''“Short Label”''), can be assigned to each concept.
-:* Presentation linkbase: establishes relationship lines between the elements defined in the schema. This is generally used as a graphical guide for filing XBRL reports, since the concepts can be represented in a tree structure. +:* Reference linkbase: Used to link concepts to references to specific regulations. This could be the whole text of the regulation, or only a reference to the full text.
-:* Definition linkbase: sets relationships between concepts, such as dependencies (e.g. if concept A is reported in a document, concept B must be reported as well).This also includes dimensional relationships, which will be discussed in a later chapter. +:* Presentation linkbase: Used to establish hierarchical relationships between the concepts defined in a schema. The presentation linkbase is generally used as a graphical guide for filing XBRL reports, since concepts can be displayed in a tree structure which matches the presentation relationships defined.
-:* Calculation linkbase: sets aggregation relationships between different elements. For example: concept A may be calculated as the sum of A1, A2, A3 ... These aggregations can be modified with specific weights in order to obtain more complex arithmetic operations. +:* Definition linkbase: Originally planned for defining simple validation relationships between concepts, such as dependencies (e.g. if concept A is reported in a document, concept B must be reported as well), the definition linkbase is more commonly used to define dimensional relationships according to the Dimensions 1.0 specification, which will be discussed in a later chapter.
 +:* Calculation linkbase: Used to define simple aggregation relationships between different elements. For example: concept A may be calculated as the sum of A1, A2, A3 ... These aggregations can be modified with specific weights in order to obtain more complex arithmetic operations.
==Extensibility== ==Extensibility==
-XBRL is extensible by design. The original authors of XBRL were aware of the complexity and diversity of business reporting all over the world. As result, XBRL was designed to be a flexible language in order to suit as much users as possible. Existing XBRL taxonomies can thus be extended with additional concepts or new relationships.+XBRL is extensible by design. The original authors of XBRL were aware of the complexity and diversity of business reporting all over the world. As result, XBRL was designed to be a flexible language in order to suit as many use-cases as possible. In addition to the extensible nature of the language itself, taxonomies (schemas) can be extended with additional concepts and new relationships.
-The idea of extending a taxonomy is to build upon an existing taxonomy, while incorporating additional information. For example, a taxonomy which defines concepts as defined by an international standard can be extended in order to be adapted to local regulations. +The idea behind extending a taxonomy is to build upon an existing taxonomy, and the concepts and relationships it defines, to incorporate additional information. For example, a taxonomy which defines concepts relating to an international standard can be extended in order to better define the information required by local regulators.
-To enable these extensions, the XBRL standard allows that a new taxonomy imports one or multiple existing taxonomies. Besides from the imported taxonomies, the resulting new taxonomy may also include new concepts and create additional relationships between (new or existing) concepts.+Taxonomy extensions can be created by importing one or multiple existing taxonomies (using XML Schema’s ‘import’ as described in section5.2.1.7). In addition to the concepts and relationships defined in the imported taxonomies, the resulting new taxonomy may also include new concepts and relationships between (new or existing) concepts.
<center>[[Image:Extensibility.jpg]]</center> <center>[[Image:Extensibility.jpg]]</center>
Line 532: Line 534:
==Dimensions== ==Dimensions==
===The multidimensional data model=== ===The multidimensional data model===
-Multidimensional data model are characterized by simplifying the analysis of business information. Analytical processing, which is also known as OLAP (Online Analytical Processing), is widely used across the software industry for a number of years.+Multidimensional data models are known for their use in the analysis of business information. Such analytical processing, known as ‘OLAP’ (Online Analytical Processing), has been widely used across the software industry for a number of years.
-The basic elements of this model are metrics, dimensions, domains and hypercubes. The metrics represent ways of measuring business operations. Examples of dimensions are time, a product line, or clients. The set of possible values within a dimension is called a domain.+The basic elements of this model are: metrics, dimensions, domains and hypercubes. Metrics represent primary business concepts (line items, or ‘primary items’). Dimensions represent ways to break down the data, examples of dimensions include: Time, product line, clients, geography. The set of possible values within a dimension is called a domain.
-The values (also known as facts) that are reported within a dimensional model will always relate to a specific set of dimensional values. For example, revenues are 100.000€ (metric) for ACME Company (Company dimension) for the year 2012 (time dimension).+The reported values within a dimensional model (also known as facts) will always relate to a specific set of dimensional values. For example, revenue (metric) is 100.000€ for ACME Company (Company dimension) for the year 2012 (time dimension).
-The elements that make up the domain of dimension are usually ordered hierarchically. For example, the domain for the customer dimension can be divided into large companies, medium-sized companies and small companies.+The elements that make up the domain of dimension are often ordered hierarchically. For example, the domain for the customer dimension could be divided into large companies, medium-sized companies and small companies.
The same domain can be used in different dimensions. For example, the representation of a bank transfer can include a dimension indicating the country of origin as well as a dimension indicating the destination country. The values that these two dimensions can take are identical: the country domain. The same domain can be used in different dimensions. For example, the representation of a bank transfer can include a dimension indicating the country of origin as well as a dimension indicating the destination country. The values that these two dimensions can take are identical: the country domain.
-The set of possible combinations of dimension values for a given metric is called a hypercube. The name hypercube comes from the fact that multidimensional models are usually represented in a multidimensional matrix. +The set of possible combinations of dimension values for a given metric is called a hypercube. The name hypercube comes from the common representation of a multidimensional model:
<center>[[Image:Dimensionality.jpg]] <center>[[Image:Dimensionality.jpg]]
Line 545: Line 547:
===XBRL dimensions=== ===XBRL dimensions===
-The XBRL Dimensions specification is an official recommendation standard since September 2006. This extension to the XBRL standard allows for valid combinations for dimensions on a primary item and defines elements of these domains. This information is expressed in the taxonomy via a new set of arcs in the definition linkbase.+The XBRL Dimensions specification has been at the official recommendation level as a standard since September 2006. This extension to the XBRL standard allows the definition of valid combinations of dimensions to further contextualise a reported primary item value, and defines elements of these domains. This information is expressed in the taxonomy via relationships in the definition linkbase.
-XBRL dimensions can be distinguished into two types, depending on how their domain is defined:+There are two types of XBRL dimensions:
-Explicit dimensions are dimension whose elements (and hierarchy) are listed explicitly.+ 
-Typed dimensions are dimensions whose elements are not predefined. This kind of dimension is used when it is not possible to define the possible values beforehand. For example, the ISBN code of a book could be used as a typed dimension.+:*Explicit dimensions are dimensions whose domain is defined by ‘domain member’ elements are listed explicitly (and perhaps arranged into a hierarchy, as with the large, medium and small company example in 6.5.1).
-One characteristic of the dimensions specification is that it allows the definition of invalid dimension combinations. For example, a taxonomy has two dimensions: fruit & colour. The taxonomy can thus indicate that some combinations of dimension values are not allowed (for example: "banana" & "red").+:*Typed dimensions are dimensions whose elements are not predefined. These dimensions are used when it is not possible to define explicit values, but a possible range, instead.. For example, the 10-digit ISBN code of a book could be defined as a typed dimension with a domain restricted to a string matching the following pattern: ^ISBN\s(?=[-0-9xX ]{13}$)(?:[0-9]+[- ]){3}[0-9]*[xX0-9]
 + 
 +One characteristic of the dimensions specification is that it allows taxonomies to define invalid dimension combinations. For example, a taxonomy has two dimensions: fruit & colour. The taxonomy can thus indicate that some combinations of dimension values are not allowed (for example: "banana" & "red").
 + 
The dimension specification is a major contribution to the XBRL standard, as it allows an intuitive representation of business information. The dimension specification is a major contribution to the XBRL standard, as it allows an intuitive representation of business information.
==Formulas== ==Formulas==
-The XBRL Formula specification is an official recommendation standard since June 2009. The main goal of the XBRL Formula specification is to provide validation capabilities not present in the base specification (XBRL 2.1). +The XBRL Formula specification has been at the official recommendation level as a standard since June 2009. The main goal of the XBRL Formula specification is to provide validation capabilities not present in the base specification (XBRL 2.1).
The Formula Specification supports the creation of expressions (using XPath) that can be applied to XBRL instances. XBRL Formulas can be used to validate the information within an instance document. For example, The Formula Specification supports the creation of expressions (using XPath) that can be applied to XBRL instances. XBRL Formulas can be used to validate the information within an instance document. For example,
-XBRL Formulas can also be used to calculate new XBRL facts in a new instance (output instance). This output instance can represent many kinds of derived data, such as transformations or determination of ratios. +XBRL Formulas can also be used to calculate new XBRL facts in a new instance (output instance). This output instance can be used to represent many variations on the data derived from an instance, such as transformations or determination of ratios.
==XBRL Reporting: Instance document structure== ==XBRL Reporting: Instance document structure==
-After explaining all the various components of XBRL, which explain how XBRL works, it might be interesting to explain how XBRL is reported. The illustrated example of chapter 6.1.1 already gave an indication of how reported data looks in the XBRL format. In this chapter the structure of an XBRL document, also called instance document, will be explained.+After explaining all the various components of XBRL, which explain how XBRL works, it might be interesting to explain how XBRL is reported. The illustrated example of chapter 6.1.1 has already indicated how reported data is represented in the XBRL format. In this chapter, the structure of an XBRL document, also called an instance document, will be explained.
XBRL instance documents do not have an elaborate predefined tree structure as may be the case in some XML schemas. All elements of an instance document reside directly within the major <xbrl> root node. Nevertheless, some components can always be found in an XBRL instance. XBRL instance documents do not have an elaborate predefined tree structure as may be the case in some XML schemas. All elements of an instance document reside directly within the major <xbrl> root node. Nevertheless, some components can always be found in an XBRL instance.
These components will be explained into more detail with the use of an example instance document. These components will be explained into more detail with the use of an example instance document.
===XBRL root node, namespaces and schemaRef=== ===XBRL root node, namespaces and schemaRef===
-Every XBRL instance document starts with the XML declaration, followed with the <xbrl> root node. Directly in the XBRL root node follows the declaration of all namespaces used in the instance document. As can be seen in the example below, 11 namespaces are declared. All subsequent elements that are within the instance document are directly within <xbrl> root node. +Every XBRL instance document starts with the XML declaration, followed by the <xbrl> root node. Within the root node, namespaces used in the instance document can be declared. In the example below, 11 namespaces have been declared. All subsequent elements in the instance document are directly below the <xbrl> root node.
<code> <code>
Line 586: Line 591:
</code> </code>
-The first element shown in the above example is the link:schemaRef element, which indicates the entry point for the XBRL taxonomy in scope for this instance document. In the example above, the relevant taxonomy entry point is "t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd" (corresponding to the Balance Sheet table of the Belgian Finrep report). If this instance document is to be tested for XBRL validity, it will be according to this XBRL taxonomy. +The first element shown in the above example is the link:schemaRef element, which indicates the location of the entry point for the XBRL taxonomy against which this instance document is expected to be valid. In the example above, the relevant taxonomy entry point is "t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd" (corresponding to the Balance Sheet table of the Belgian Finrep report). For this instance document to be XBRL valid, it will have to valid against the definitions in t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd.
===Contexts and units=== ===Contexts and units===
After these first general elements, the contexts and units are defined. After these first general elements, the contexts and units are defined.
Contexts give additional information to reported data, like: Contexts give additional information to reported data, like:
-Related timing of the reported data. This can be a period (duration) or a moment of time (instant).+Related timing of the reported data. This can be a period (duration) or a moment in time (instant).
Identification of the reporting entity Identification of the reporting entity
-Dimensional information. If the reported data is linked to a combination of a primary concept and dimensional values, the dimensional definition will be included in the context+Dimensional information. If the reported data is linked to a combination of a primary concept and dimensional values, the dimensional definition will need to be included in the context.
-Units indicate in what metric the reported data is expressed. This can be a currency, as is the case in the example below, or not.+ 
 +To fully contextualise a numeric fact in an instance, it must be associated with a unit. Units indicate in what measure the reported data is expressed. This could, for example, be a currency (as below).. Other examples of unit are ‘percentage’, ‘pure’ (no unit), ‘earnings per share’.
<code> <code>
Line 640: Line 646:
</code> </code>
-In the example above, 3 contexts are defined, with the following id's:+In the example above, 3 contexts are defined, with the following ID's:
:* I-2007-12-Belgium :* I-2007-12-Belgium
:* I-2007-12-OtherEMU :* I-2007-12-OtherEMU
Line 647: Line 653:
===Facts and primary concepts=== ===Facts and primary concepts===
-The most important elements of an XBRL instance document are the reported data, also called facts. Data from a report is represented via the use of a combination of primary concept and contextual information:+The reported data in an XBRL instance document are known as ‘facts’. A fact is reported by referring to its primary concept (defined by the taxonomy) and references to its contextual information defined by a context element, a unit element and a number of other attributes depending on the data type of the concept being reported.
<code> <code>
Line 674: Line 680:
</code> </code>
-All the information which was defined previously is used in this part. Namespaces are used for precise element definitions of the primary concepts. Contexts and units are used to give contextual information to the reported numbers.+This example illustrates several of the ideas presented earlier in this document: Namespaces prefixes are used, along with element names to reference the element definitions of the primary concepts. Contexts and units references are used to give contextual information to the reported numbers.
 +The instance document ends with the closing tag of the main <xbrl> root node.
-The instace document ends with the closing tag of the main <xbrl> root node. 
==Validation of XBRL reports== ==Validation of XBRL reports==
-One of the fundamental processes of information handling within XBRL is the validation of instance documents. The goal of the validation process is the ensure consistency of the reported information according to the different rules imposed by the XBRL standard and by the XBRL taxonomy in scope.+One of the fundamental processes required in the handling of XBRL data is the validation of instance documents. The goal of the validation process is the ensure consistency of the reported information according to the different rules imposed by the XBRL standard and by the referenced XBRL taxonomy.
-The validation process contains the following steps:+The validation process involves the following steps:
:* XML validation: an XBRL document must be a well-formed XML document :* XML validation: an XBRL document must be a well-formed XML document
:* XML Schema validation: an XBRL document must be valid according the Schema defined by the taxonomy (its structure, data types, etc.) :* XML Schema validation: an XBRL document must be valid according the Schema defined by the taxonomy (its structure, data types, etc.)
:* XBRL validation structure. Some rules which are not covered by the taxonomy's schema validation are defined by the XBRL specification. For example, a monetary concept must be accompanied by a unit. :* XBRL validation structure. Some rules which are not covered by the taxonomy's schema validation are defined by the XBRL specification. For example, a monetary concept must be accompanied by a unit.
:* Validation rules: an XBRL taxonomy can contain certain restrictions defined within the taxonomy linkbases (such as the calculation linkbase). :* Validation rules: an XBRL taxonomy can contain certain restrictions defined within the taxonomy linkbases (such as the calculation linkbase).
-:* Dimensional validation: reported information needs to be adapted to the dimensional constraints imposed by the taxonomy. A dimension my not take values that are nit in the domain, or a metric may not be reported for an invalid combination of dimensions+:* Dimensional validation: reported information needs to be valid against the dimensional constraints imposed by the taxonomy. A dimension may not take values that are not specified in its domain, o a metric may not be reported for an invalid combination of dimensions
:* Formula validation: if the taxonomy contains XBRL formulas, the reported information may be assessed according to the formulas defined in the taxonomy :* Formula validation: if the taxonomy contains XBRL formulas, the reported information may be assessed according to the formulas defined in the taxonomy
-All these validation steps are generally executed by specific XBRL software.+ 
 +All validation steps are generally executed by specific XBRL software.
=Further Reads= =Further Reads=

Revision as of 18:57, 17 June 2013

CEN Workshop Agreement

Status: Working Group Working Draft

CEN WS XBRL Experts: Pieter Maillard (Aguilonius), Pablo Navarro (Atos)

Editing rules

Editorial comments should be highlighted as follows: A comment

Text or rules in discussion (white): Some text

Text or rules already aligned (green): Some text

Text or rules to be deleted (red): Some text

Text to be delivered (blue): Some text

Contents




Foreword


This document is a working document.
This document has been prepared by CEN/WS XBRL, the secretariat of which is held by NEN.
This document is a working document.



Introduction

The set of recommendations included in this document aim to facilitate the implementation of European National Supervisors to adopt XBRL in any of the reporting frameworks. The following chapters will provide guidance on the use, understanding, preparation, and extension of their filings in eXtensible Business Reporting Language (XBRL).

This guidance is in the form of notes in association with the pertaining requirements clause and uses the terms “should” (recommendation), “may” (allowance) and “can” (possibility). Organizations wishing to implement this CWA would be expected to consider all recommendations where the term “should”is used.




Scope

COREP, FINREP (and Solvency II or other future) XBRL taxonomies are offered to European regulators for national implementation. The first releases (2006) of the COREP and FINREP XBRL frameworks have proven that a standardized technical roll-out package is needed to increase the adoption rate and avoid implementation variances, which have a detrimental effect on the overall cross-border effectiveness of using one reporting standard. This roll-out guide tries as well to promote the economies of scale of a better adoption.

This CWA have divided the work/deliveries in two difference parts:

i) An XBRL supervisory roll-out guide: this is oriented towards national regulators on how to implement, extend and manage XBRL taxonomies
ii) An XBRL handbook for declarers: this is a roll-out guide or reference handbook would give a general introduction to XBRL and serve as a help to preparers of XBRL (reporting entities)


The scope of the current document is on the second part of the CWA; the XBRL handbook for declarers.


In this general guide to XBRL, the following subjects will be addressed:

- An introduction to XBRL from a declarers' perspective

- The basics of XML, the main building block of XBRL, will be explained. Various XML components will be introduced

- An introduction to XBRL. In this chapter, XBRL is introduced and various topics are addressed: XBRL taxonomies, extension, XBRL dimensions, Formulas, the structure of an instance document, the validation of XBRL

Normative references

The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) applies.


- XBRL 2.1

- XBRL Dimensions 1.0

- XBRL Registry specification 1.0

- XBRL Formula specification 1.0

Symbols and Abbreviations

For the purposes of this document, the following abbreviations are applicable:

W3C: World Wide Web Consortium

XBRL: eXtensible Business Reporting Language

XML: eXtensible Markup Language

How to start with XBRL from the declarer's perspective

XBRL stands for eXtensible Business Reporting Language. It is a language for the electronic communication of business information, providing major benefits in the preparation, analysis and communication of business information. It offers cost savings, greater efficiency and improved accuracy and reliability to all those involved in supplying or using business information.

The popularity of XBRL as a communication standard is growing as it is adopted by more and more regulators around the world. Entities reporting information to regulators might initially see XBRL as another reporting burden. However, XBRL provides many benefits for the declarer as well. All organisations can use XBRL to save costs and improve efficiency in handling business and financial information. Because XBRL is extensible and flexible, it can be adapted to a wide variety of different requirements. All participants in the financial information supply chain can benefit, whether they are preparers, transmitters or users of business data.

There are large number of software tools for creating, manipulating and analysing XBRL, most of which hide all the technical details involved in the expression of XBRL data. To this end, a user doesn't need to understand or even see the XBRL itself. However, a basic understanding of the basic components of XBRL can allow the user to better grasp the potential benefits.

The ambition of this document is to explain the foundations of the XBRL standard. Although these aspects might seem technical at first, all topics will be addressed in a general, comprehensible way.


This section is further being elaborated during the Workshop with the input from the other project teams.

XML and XBRL: Introduction to the technological building blocks

This chapter aims to present an overview of the basic technologies that underpin XBRL in order to obtain a better understanding of this reporting language. Since XBRL is built upon the XML language, the this chapter focuses on the basics of the XML standard, in particular the XML components which are also used by XBRL.

XML

XML, or eXtensible Markup Language, is a W3C standard1 which enables the representation of structured data in the form of flat text. This simple and flexible text format is both machine readable and human readable. The XML specification, which is a derivative of SGML2 , uses elements and attributes to structure content. Although originally designed for the publication of information, XML is increasingly important in facilitating a wide range of electronic communications.

In the chapters below, we'll elaborate on the following topics:

  • XML as a markup language
  • How XML can be used to structure information
  • The main components of an XML document
  • Namespaces and prefixes
  • Unicode
  • The benefits of XML


1 The standard can be found at http://www.w3.org/TR/2008/REC-xml-20081126/ 2 SGML (or Standard Generalized Markup Language) is an ISO-standard technology for defining generalized markup languages for documents. SGML itself descends from GML (Generalized Markup Language), which is developed by IBM in the 1960s.


XML as a markup language

Simply put, one can say that XML is a flexible language for expressing structured information in a machine-readable format. Content is "marked-up" using "tags" as in the example below. XML is commonly referred to as a markup language for this reason. The XML below represents a list of books:

   <book>On the Road</book>
   <book>The Catcher in the Rye</book>
   <book>The Hobbit</book>
   <book>The Name of the Rose</book>

The name of each book is delimited by two tags. The first tag contains an identifier enclosed in angle-brackets (<book>), indicating the beginning of a field. The second tag is equal to the first, but also contains a closing bracket (</book>), which indicates the end of a field. As a result, the content of each element of <book> is delimited by the opening and closing tags. With this method, a system that processes this information can easily identify the subject and aim of the provided information.

XML structures

The previous example used only a single element <book>. The XML information model, however, is hierarchical: an element can contain other elements, which in turn can also contain other elements. This is illustrated by the following example:


<library>  
  <book>
    <title>On the Road</title>
    <author>Jack Kerouac</author>
  </book>
  <book>
  <book>
    <title>The Catcher in the Rye</title>
    <author>J. D. Salinger</author>
  </book>
  <book>
  <book>
    <title>The Name of the Rose</title>
    <author>Umberto Eco</author>
  </book>
  <book>
</library>


In the example above, the "library" element contains a set of "book" elements. Each of these "book" elements contains a "title" and an "author" element.

Components of an XML document

The most important components of an XML documents are the elements. Elements are defined by their name (e.g. "book" above), their content (the value between the angled brackets, which can be null) and an indefinite number of attributes. The example below shows an element with two attributes:

 <element attribute1="attr-value1" attribute2="attr-value2">content</element>

An XML document may start with an XML declaration, where the XML version is identified (typically 1.0) as well as the character encoding. This is followed by the first element. This element is called root element. This will have a number of undetermined "child" elements.

 <?xml version="1.0" encoding="UTF-8"> 
<library>
<!-- other items -->
</library>

The example above shows an XML document which uses version 1.0, has UTF-8 encoding and has "library" as the root element.

The XML specification defines an XML document as a text that is well-formed, i.e., it satisfies a list of syntax rules provided in the specification1. This list is lengthy, but some key points are:

  • Only properly encoded legal Unicode characters are allowed.
  • None of the special syntax characters such as "<" and "&" can appear except when performing their markup-delineation roles.
  • The begin, end, and empty-element tags that delimit the elements are correctly nested, with none missing and none overlapping.
  • The element tags are case-sensitive; the beginning and end tags must match exactly.
  • There is a single "root" element that contains all the other elements.

It is also possible to include comments in XML documents. These comments are not processed by applications and allow the inclusion of clarifications in the text document when deemed appropriate. Comments begin with the characters "<!-" and end with the characters "->".


1 http://www.w3.org/TR/2008/REC-xml-20081126/#sec-well-formed

Namespaces

The naming scheme described above is limited, as it can lead to ambiguity between elements which use the same name. Consider the following two examples:

 <?xml version="1.0" encoding="UTF-8"> 
<library>
<book author="J.R.R. Tolkien" language="English">The Lord of the Rings</book>
<book author="Molière" language="French">Tartuffe</book>
</library>


 <?xml version="1.0" encoding="UTF-8"> 
<xml-apps>
<tool name="xmlstarlet" language="c"/>
<tool name="trang" language="java"/>
<tool name="xmldiff" language="python"/>
</xml-apps>

The first document contains a representation of a collection of books and the second describes three XML applications. Both make use of the attribute “language”, but the meaning of “language” is different in each case: In the first example the language attribute means the human language of the book; in the second example the language attribute means the programming language of the application.

A human would have little difficulty in distinguishing the use of the same attribute in different contexts. However, for a machine to process the information automatically, ambiguities must be avoided.

XML namespaces are used for providing unique element names and attributes in an XML document. A namespace defines a grouping of concepts. Within a namespace, each concept is identified uniquely by its local name. Globally, each concept is identified uniquely by its local name plus the identifier of its namespace. Local name and namespace identifier together form a ‘Qualified Name’, or QName. The two previous examples could thus be represented as follows:


NamespaceLocal NameDescription
LiteratureLanguageLanguage, speech
Computer SciencesLanguageProgramming language


But how can we ensure that there is no naming conflict at the namespace level? How can we ensure, for example, that there cannot be different interpretations of the namespace "literature"? The unique identification of a namespace is achieved by using a URI (Unique Resource Identifier).

The following is an example of a URI which could be used a namespace:

            http://www.acme.org/products


The fundamental idea behind a namespace is that it incorporates an internet domain as part of its identifier. The use of namespaces allows the definition of unique concepts. This is in an important aspect of the XBRL standard

Namespaces and prefixes

For readability purposes, XML documents can assign each namespace to a ‘prefix’ (usually a short string). After declaring a prefix for a namespace, all full namespace identifiers can be replaced by the declared prefixes. The association between a prefix and its corresponding namespace is usually set at the root node. The association of a prefix and a namespace is done using a special attribute: xmlns:[prefix]="Namespace". This is illustrated by the example below:

    <?xml version="1.0" encoding="UTF-8">
<bk:book-collection xmlns:bk="http://www.book.org">
<bk:book author="Norman Davies" language="English">Europe: A History</bk:book>
<bk:book author="Homeros" language="Greek">Ilias</bk:book>
<bk:book author="Jonathan Litell" language="French">Les Bienveillantes</bk:book>
</bk:book-collection>

In the above example, ‘xmlns:bk=http://www.book.org”’ binds http://www.book.org to the prefix "bk". Once the namespace is bound, the prefix “bk” can be used in its place, so the element "bk:book" has "book" as its local name and "http://www.book.org" as its namespace.

UNICODE

Unicode is a standard for the representation of text expressed in most of the world's writing systems. Unicode can be used to represent any character in English, Spanish, Greek or any other western language, Chinese, Cyrillic, Hebrew, Arabic, Mongolian, Ethiopian and many others. Unicode was originally developed by a consortium of companies including Apple, Microsoft, IBM, Xerox, HP and Adobe in order to obtain a universal character set. It is now integrated in almost all modern operating systems as well as technological languages like XML, Java, or the Microsoft .Net Framework. Unicode can be implemented by different character encodings. One of the most commonly used encodings is UTF-8 (which is also compatible with the older ASCII code).

Thanks to the use of Unicode, XML allows the representation of text in any language.

XML Benefits

The previous sections have introduced the main elements of the XML syntax. XML is a markup language which can be used to describe data structures in a machine-readable format.

The benefits of XML are among others:

  • A language readable by humans as well as machines
  • It is self-contained. An XML document not only describes the data values, but also its structure and the naming of the fields
  • Its hierarchical structure allows the representation of virtually any data structure in a simple way
  • It is platform-independent. XML documents can be used on any operating system and with any programming language
  • The use of a strict syntax leads to an efficient processing by tools

XML is used at the core of all information exchange over the internet

XML Schema

An XML schema is a collection of XML definitions. These definitions, called schema components, describe the allowed structure and content of an XML document by providing restrictions to the XML syntax itself. The rules defined by an XML schema determine the validity of an XML document using that schema.

XML Schema Components

A schema defines the elements and attributes that make up an XML document. Elements and attributes are defined by stating their name and the possible values they can take (their “type”). Attributes can only be of simple type, while elements can also be of complex type. A complex type allows the specification of an element's valid attributes and specifies complex content: elements that are composed of other elements. An element identified as a simple type cannot contain other elements.

In addition, other auxiliary components exist that, although not directly used in XML documents, can be used in a schema (or in other schemas extending the schema). Auxiliary components include type definitions, groups of elements and groups of attributes.

Predefined types

One of the main features of an XML Schema is that a broad set of types are incorporated by default. These predefined types can in turn be divided into “primitives” and “derivatives”. Derived types are those whose definition is based on another type. Primitive types are the most basic types defined by the specification: these definitions do not depend on other types.

Among the primitive types of the XML Schema are: the string type (a string of characters), the Boolean type (a type with only 2 logical values: true of false), the decimal type (a decimal number with an arbitrary precision), the duration type (represents an extension of time) and the time type (represents a time of the day).

Among the derived types of the XML Schema are: the normalizedString type (a string of characters which cannot contain carriage return, new line or tab), the positiveInteger type (integer number values larger than zero), the negativeInteger type (integer number values smaller than zero).

All of these types are defined in the namespace of the XML Schema. As a result, the types will appear with their corresponding prefix (usually "xs"). For example: "xs:string", "xs:integer", …

Besides these predefined types, XML Schema allows for the creation of many more in order to meet any number of arbitrary requirements.

Extension of simple types

Simple types do not contain XML structures. The possible values for simple types can thus be expressed by a sequence of flat characters. Existing simple types can serve as a basis for the creation of new simple types or can be used in complex types.

Simple types are most commonly extended through the use of a restricting mechanism, via the declaration of properties (facets) to impose limits on the extended base type. For example, if the base type is xs:integer, minimum and maximum values can be defined in order to define a new type.

The properties that can be applied to an extended simple type depend on the base that being extended. For example, the number of digits of a numeric type can be limited, a date can have a maximum value or a regular expression can be applied to a string.

Extension of types: attribute declaration

XML Schema allows the extension of attributes of extended types (simple types do not have any attributes). Conversely; the use of attributes can also be restricted.

Unlike elements, attributes cannot be repeated within the same element. The order in which they are declared in an element is also irrelevant. An XML Schema however, can control whether their use is mandatory, optional or prohibited.

Sometimes it is useful to allow attributes in XML documents that are not defined in the schema. In this case, the component "xs:anyAttribute" is used. This component can be accompanied by a namespace attribute limiting the number of attributes that can be used in the XML document. This is widely used in XBRL, providing flexibility to the schema.

Extension of types: composition of elements

The extension of simple types is not sufficient to express the all possible data structures in XML. In order to express nested element structures, we need to compose elements within the schema.

In the following example, the contents of root element "library" may contain the "book" or "audiocd". The elements of type "book" can in turn contain a pair of singles ("title" and "author"), not following a predetermined order. The elements of type "audiocd" contains a list of elements "track-title" and "track-duration" which contains the title information and its duration for each track on the CD:


  <?xml version="1.0" encoding="UTF-8">
  <library>	
     <book>
        <author>Hilary Mantel</author>
        <title>Wolf Hall</title>
     </book>
     <book>
        <title>Raghuram Rajan</title>
        <author>Fault Lines</author>
     </book>
     <audiocd album="Kind Of Blue">
        <track-title>So What</track-title>
        <track-duration>9</track-duration>
        <track-title>Freddie Freeloader</track-title><
        <track-duration>10</track-duration>
        <track-title>Blue In Green</track-title>
        <track-duration>5</track-duration><
     </audiocd>
  </library>

There are three mechanisms in an XML Schema that can be used to define compositional relationships: "sequence", "choice" and "all":

  • Sequence: indicates that the content of a type is an ordered list of elements. In the example shown above, "audiocd" contains elements "track-title" and "track-duration"
  • Choice: allows the choice of a component from an available list. In the above example, "library" can be expressed as a "choice" of the elements "book" and "audiocd".
  • All: allows the creation of an unordered list or set. Unlike "sequence", "all" does not establish an order. In the above example, "book" consists of the elements "title" and "author" without a predetermined order.

This can be schematically represented in the following illustration:

Image:CWA3CompositionOfElements.jpg


The above example would thus be defined as follows using XML Schema:

<?xml version="1.0" encoding="UTF-8">
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" >
  <xs:element name="library">
     <xs:complexType>
        <xs:choice maxOccurs="unbounded">
           <xs:element name="book">
              <xs:complexType>
                 <xs:all>
                    <xs:element name="title">
                    <xs:element name="author">
                 </xs:all>
              </xs:complexType>	
           </xs:element>
           <xs:element name="audiocd">
              <xs:complexType>
                 <xs:sequence maxOccurs="unbounded">
                    <xs:element name="track-title">
                    <xs:element name="track-duration">
                 </xs:sequence>
              </xs:complexType>
           </xs:element>
        </xs:choice>
     </xs:complexType>
  </xs:element>
</xs:schema>

As explained in the previous chapters, the prefix "xs:" points to the namespace "http://www.w3.org/2001/XMLSchema". The number of repetitions or cardinality of the elements can be controlled by the attributes "minOccurs" and "maxOccurs". The combination of these attributes with different elements can result in more complex schemas.


ID and IDREF attribute types

A number of specific attribute types, which exist in XML Schema, are particularly significant in XBRL. These attribute types are ID and IDREF. The value assigned to an ID type attribute can't be repeated within the same XML document. As a result, an ID type attribute uniquely identifies each element within the same document. In the example below, the ISBN attribute has been defined in the corresponding XML schema as an ID type attribute:

  <?xml version="1.0" encoding="UTF-8">
  <library>
     <book ISBN="ISBN-0-262-56099-2">It's not about the Bike</book>
     <book ISBN="ISBN-0-262-56099-2">The Pillars of the Earth</book>
     <book ISBN="ISBN-0-569-00108-8">A History of the World in 100 Objects</book>
  </library>

According to XML Schema rules, this example is invalid, because there are two books with the same ID. The attribute type IDREF is a reference to another ID. In other words, an attribute of IDREF type must contain the value of an ID which already exists in the document. This is illustrated in the example below, where a new attribute called "sequel-of" is an IDREF:

  <?xml version="1.0" encoding="UTF-8">
  <library>
     <book ISBN="ISBN-0-262-56099-2">The Fellowshiop of the Ring</book>
     <book ISBN="ISBN-0-311-57018-9" sequel-of=" ISBN-0-262-56099-2">The Two Towers</book>
     <book ISBN="ISBN-0-569-00108-8" sequel-of=" ISBN-0-311-57018-9">The Return of the King</book>
  </library>

Groups of attributes and elements

In some cases, a number of attributes are used repeatedly in elements of a schema. In that case, a group of attributes can be used: it is the group that is referenced in the element declaration. Similarly, elements can also be declared as a group of content types. For example, the "choice" type refers to a group of elements, which enable the selection of any element defined in that group.

Importing and including schemas

XML schemas can import or include other schemas. Doing this allows the use of components (elements, types, attributes and groups) defined in other schemas. When the imported schema belongs to a different namespace import is used ("xs:import") . If the namespace is the same, "include" is used ("xs:include").

The use of import and include means that schemas can be easily extended. This simplifies the definition of a new schema, since existing definitions can be imported. This is used extensively in the XBRL standard.

XML Schema benefits

The use of XML Schema simplifies information processing. Some of the benefits of XML Schema:

  • A Schema document defines a common structure. As a result, automated processing of this document is streamlined.
  • Adequacy checks can be performed using market tools (validators), instead of custom development. This improves quality as well as reducing the development time of new applications
  • Reuse of market software. Besides validators, a large number of existing tools also make use of XML Schemas. For example: exhibit generators, database extraction & storage utilities, publishers, ...
  • Development can be based on the data types associated with components, instead of the components themselves. This makes developments more flexible and makes it more likely that code will be reused.
  • Reuse of global definitions. Via the use of namespaces and the import of existing schemas, concepts defined by different organisations can be reused.

XLink

XML Linking Language or XLink is a standard defined by the W3C that creates and describes cross-references between resources or fragments of XML documents. For example, XLink allows the creation of links which are similar to hyperlinks.

Technological components used by XML and by XBRL

This section describes some technologies which, while not part of the current version of the XBRL standard, allow generic XML document processing, and therefore can also be used for XBRL processing.

XPath

XPath is a language that enables the selection of fragments in an XML document. It also allows basic manipulation of strings, numbers and logical expressions. XPath uses a compact syntax, resembling in some ways the syntax used by old operating systems to identify a file or a set of files (but replaces directories with XML tree nodes) Below are some examples of XPath:

XPath ExpressionResult
/library/author/bookselects all books of the library
/library/author[@name="JRR Tolkien"]/bookselects all books authored by JRR Tolkien
/count(library/author[@name="JRR Tolkien"]/book)returns the number of books authored by JRR Tolkien
/library/author[@name="JRR Tolkien"]/book [last()]selects the last book authored by JRR Tolkien
//@ISBNselects the ISBN attribute value of any XML tree node

XPath is perhaps more important for its use as part of other standards like XSLT or XQuery, than use on its own.

XSLT

XSLT (or Extensible Stylesheet Language Transformations) is a language for transforming XML documents. It uses a scheme of pattern matching: the user defines a set of patterns (defined in XPath) and results. When an XSLT processor locates a fragment that fits one of these patterns, the corresponding result is substituted in the output document. XSLT incorporates additional features such as control structures, defining functions or lookup tables. These additional features make XSLT a powerful language.

The illustration below shows a functional diagram of an XSLT processor:

Image:ProcessingXSLT.jpg


The patterns defined in an XSL sheet and subsequently found in the input document are replaced in the generated output document. XSLT is used in the presentation layer of some web architectures used for transforming XML documents in a presentation format (HTML or XHTML). The National Bank of Belgium, for example, uses XSLT (and related languages) to generate PDF documents from XBRL reports submitted by regulated entities.

XQuery

The previous chapters give the reader a flavour of how XML can be used to represent structured information. There are databases that use XML as an alternative (or complement) to conventional technologies such as relational databases. The need to query XML data thus arises. This is addressed with XQuery, a functional programming language designed to query collected XML data.

XBRL: Extensible Business Reporting Language

The aim of this chapter is to give an explanation of the main features of XBRL as a language for representing business information. The content is intended to be presented a conceptual level (and thus does not go into too much technical detail).

How to structure reporting data?

Before starting to explain XBRL, the advantage of structuring reported data is shown with an example. Reported financial data tend to be represented in a table. For example, the COREP Capital Adequacy table:

Such a representation of information is human-readable. However, it is not ideal for machine interpretation, as the data is contextualised by its layout on the page, rather than in a consistently structured manner.. Thus, we ask “How can we structure this information so that it can be transmitted and interpreted consistently?” For the purpose of this example, we’ll focus on the “Eligible Capital” line, highlighted in yellow in the above example. A first step would be to tag the amount of Eligible Capital in a way that it is directly linked to the concept of Eligible Capital:

<p-ca:EligibleCapital>215</p-ca:EligibleCapital>

Although this tag provides some structural information, contextual information, such as the currency of the value is missing:

<p-ca:EligibleCapital unitRef=”EUR”>215</p-ca:EligibleCapital>

And finally, the reporting period:

<p-ca:EligibleCapital unitRef=”EUR” contextRef=”2012-12-31”>215</p-ca:EligibleCapital>

The above example shows, in a nutshell, how XBRL allows to structure reporting data.

XBRL Introduction

XBRL, or eXtensible Business Reporting Language, is a communication language developed for the standardised exchange of business and financial data.
XBRL normalises the format of the data (via the use of XML techniques) and the validation of data (via XBRL taxonomies).

Image:XBRL-LanguageDiagram.jpg


The interaction between taxonomies and instance documents is explained further in this document. XBRL also provides:
  • Standard validation rules (mathematical and logical rules)
  • The use of label linkbases (which allows multi-lingual taxonomies)
  • Mechanisms for defining a human-readable rendering
  • Standard toolset which allow to work with XBRL
During the following chapters XBRL is explained more elaborately. Topics covered:
  • XBRL Taxonomies
  • The extensibility of XBRL
  • XBRL Dimensions
  • XBRL Formulas
  • XBRL instance documents
  • The validation of XBRL instance documents

XBRL Taxonomies

An XBRL Taxonomy defines the concepts of a certain business domain and the relationships between them. XBRL taxonomies are a collection of taxonomy schemas and linkbases.

Schemas

Based on XML Schema, a taxonomy schema defines business concepts and their basic properties.

Each business concept is represented by an element in a schema. As a result, each business concept will have a qualified name (i.e. namespace plus local name). As previously explained, this will allow unique identification of the specific concept.

All basic properties of a concept are expressed as element attributes. The values of these properties determine how the concept will be used to represent concept values, known as “facts” in an XBRL report. The most common properties are:

  • Data type: the type of value (monetary, value, percentage, text ...) that can be assigned to the concept. Predefined XBRL types can be used, or new ones can be defined using of XML Schema).
  • Period type: generally, two period types are used in XBRL:
    • Instant: used for expressing facts which refer to a certain moment in time (e.g. an amount on a balance sheet)
    • Duration: used for expressing facts which refer to a time interval (e.g. the revenue for a certain period)

In addition to these predefined properties, the flexibility of XBRL allows the creation of taxonomy-specific properties

Linkbases

Linkbases are used to define relationships between elements and relationships between resources. A resource can be, for example, the name of a concept in specific language or a reference to a paragraph of a legal document.

These relationships are defined using the XLink standard. Each link has a specific “role”. XBRL defines a set of predefined roles that are grouped into linkbases. Linkbases in common use are:

  • Label linkbase: Used to assign labels to concepts defined in a schema. Multiple labels, perhaps in different languages or for different purposes (e.g. “Documentation”, “Period Start”, “Short Label”), can be assigned to each concept.
  • Reference linkbase: Used to link concepts to references to specific regulations. This could be the whole text of the regulation, or only a reference to the full text.
  • Presentation linkbase: Used to establish hierarchical relationships between the concepts defined in a schema. The presentation linkbase is generally used as a graphical guide for filing XBRL reports, since concepts can be displayed in a tree structure which matches the presentation relationships defined.
  • Definition linkbase: Originally planned for defining simple validation relationships between concepts, such as dependencies (e.g. if concept A is reported in a document, concept B must be reported as well), the definition linkbase is more commonly used to define dimensional relationships according to the Dimensions 1.0 specification, which will be discussed in a later chapter.
  • Calculation linkbase: Used to define simple aggregation relationships between different elements. For example: concept A may be calculated as the sum of A1, A2, A3 ... These aggregations can be modified with specific weights in order to obtain more complex arithmetic operations.


Extensibility

XBRL is extensible by design. The original authors of XBRL were aware of the complexity and diversity of business reporting all over the world. As result, XBRL was designed to be a flexible language in order to suit as many use-cases as possible. In addition to the extensible nature of the language itself, taxonomies (schemas) can be extended with additional concepts and new relationships.

The idea behind extending a taxonomy is to build upon an existing taxonomy, and the concepts and relationships it defines, to incorporate additional information. For example, a taxonomy which defines concepts relating to an international standard can be extended in order to better define the information required by local regulators.

Taxonomy extensions can be created by importing one or multiple existing taxonomies (using XML Schema’s ‘import’ as described in section5.2.1.7). In addition to the concepts and relationships defined in the imported taxonomies, the resulting new taxonomy may also include new concepts and relationships between (new or existing) concepts.

Image:Extensibility.jpg


Dimensions

The multidimensional data model

Multidimensional data models are known for their use in the analysis of business information. Such analytical processing, known as ‘OLAP’ (Online Analytical Processing), has been widely used across the software industry for a number of years. The basic elements of this model are: metrics, dimensions, domains and hypercubes. Metrics represent primary business concepts (line items, or ‘primary items’). Dimensions represent ways to break down the data, examples of dimensions include: Time, product line, clients, geography. The set of possible values within a dimension is called a domain. The reported values within a dimensional model (also known as facts) will always relate to a specific set of dimensional values. For example, revenue (metric) is 100.000€ for ACME Company (Company dimension) for the year 2012 (time dimension). The elements that make up the domain of dimension are often ordered hierarchically. For example, the domain for the customer dimension could be divided into large companies, medium-sized companies and small companies. The same domain can be used in different dimensions. For example, the representation of a bank transfer can include a dimension indicating the country of origin as well as a dimension indicating the destination country. The values that these two dimensions can take are identical: the country domain. The set of possible combinations of dimension values for a given metric is called a hypercube. The name hypercube comes from the common representation of a multidimensional model:

Image:Dimensionality.jpg

As an example, a three-dimensional hypercube is graphically represented in the figure above.

XBRL dimensions

The XBRL Dimensions specification has been at the official recommendation level as a standard since September 2006. This extension to the XBRL standard allows the definition of valid combinations of dimensions to further contextualise a reported primary item value, and defines elements of these domains. This information is expressed in the taxonomy via relationships in the definition linkbase. There are two types of XBRL dimensions:

  • Explicit dimensions are dimensions whose domain is defined by ‘domain member’ elements are listed explicitly (and perhaps arranged into a hierarchy, as with the large, medium and small company example in 6.5.1).
  • Typed dimensions are dimensions whose elements are not predefined. These dimensions are used when it is not possible to define explicit values, but a possible range, instead.. For example, the 10-digit ISBN code of a book could be defined as a typed dimension with a domain restricted to a string matching the following pattern: ^ISBN\s(?=[-0-9xX ]{13}$)(?:[0-9]+[- ]){3}[0-9]*[xX0-9]

One characteristic of the dimensions specification is that it allows taxonomies to define invalid dimension combinations. For example, a taxonomy has two dimensions: fruit & colour. The taxonomy can thus indicate that some combinations of dimension values are not allowed (for example: "banana" & "red").

The dimension specification is a major contribution to the XBRL standard, as it allows an intuitive representation of business information.

Formulas

The XBRL Formula specification has been at the official recommendation level as a standard since June 2009. The main goal of the XBRL Formula specification is to provide validation capabilities not present in the base specification (XBRL 2.1). The Formula Specification supports the creation of expressions (using XPath) that can be applied to XBRL instances. XBRL Formulas can be used to validate the information within an instance document. For example, XBRL Formulas can also be used to calculate new XBRL facts in a new instance (output instance). This output instance can be used to represent many variations on the data derived from an instance, such as transformations or determination of ratios.


XBRL Reporting: Instance document structure

After explaining all the various components of XBRL, which explain how XBRL works, it might be interesting to explain how XBRL is reported. The illustrated example of chapter 6.1.1 has already indicated how reported data is represented in the XBRL format. In this chapter, the structure of an XBRL document, also called an instance document, will be explained. XBRL instance documents do not have an elaborate predefined tree structure as may be the case in some XML schemas. All elements of an instance document reside directly within the major <xbrl> root node. Nevertheless, some components can always be found in an XBRL instance. These components will be explained into more detail with the use of an example instance document.

XBRL root node, namespaces and schemaRef

Every XBRL instance document starts with the XML declaration, followed by the <xbrl> root node. Within the root node, namespaces used in the instance document can be declared. In the example below, 11 namespaces have been declared. All subsequent elements in the instance document are directly below the <xbrl> root node.

  <?xml version="1.0" encoding="UTF-8">
  <xbrl> 
     xmlns="http://www.xbrl.org/2003/instance"
     xmlns:d-Regions-be="http://www.c-ebs.org/eu/fr/esrs/finrep/d-Regions-be/2008-01-01"   
     xmlns:d-sc-be="http://www.c-ebs.org/eu/fr/esrs/corep/2006-07-01/d-sc-be-2006-07-01"   
     xmlns:ifrs-gp="http://xbrl.iasb.org/int/fr/ifrs/gp/2006-08-15" 
     xmlns:iso4217="http://www.xbrl.org/2003/iso4217"   
     xmlns:link="http://www.xbrl.org/2003/linkbase" 
     xmlns:p-FINREP="http://www.c-ebs.org/eu/fr/esrs/finrep/p-FINREP/2008-01-01"   
     xmlns:xbrldi="http://xbrl.org/2006/xbrldi"   
     xmlns:xbrli="http://www.xbrl.org/2003/instance"   
     xmlns:xlink="http://www.w3.org/1999/xlink"  
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
     <link:schemaRef xlink:type="simple" 
        xlink:href="http://www.c-ebs.org/eu/fr/esrs/finrep/t-FINREP-be/BalanceSheet/2008-01-01/t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd"/>
     ...
  </xbrl>

The first element shown in the above example is the link:schemaRef element, which indicates the location of the entry point for the XBRL taxonomy against which this instance document is expected to be valid. In the example above, the relevant taxonomy entry point is "t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd" (corresponding to the Balance Sheet table of the Belgian Finrep report). For this instance document to be XBRL valid, it will have to valid against the definitions in t-FINREP-be-2008-01-01-T01-BalanceSheet.xsd.

Contexts and units

After these first general elements, the contexts and units are defined. Contexts give additional information to reported data, like: Related timing of the reported data. This can be a period (duration) or a moment in time (instant). Identification of the reporting entity Dimensional information. If the reported data is linked to a combination of a primary concept and dimensional values, the dimensional definition will need to be included in the context.

To fully contextualise a numeric fact in an instance, it must be associated with a unit. Units indicate in what measure the reported data is expressed. This could, for example, be a currency (as below).. Other examples of unit are ‘percentage’, ‘pure’ (no unit), ‘earnings per share’.

 ...
  <context id="I-2007-12-Belgium">
     <entity>
        <identifier scheme="http://www.swift.com">TESTST04</identifier>
     </entity>
     <period>
        <instant>2007-12-31</instant>
     </period>
     <scenario>
        <xbrldi:explicitMember dimension="d-Regions-be:ByRegionsDimension">d-Regions-be:Belgium</xbrldi:explicitMember>
        <xbrldi:explicitMember dimension="d-sc-be:ScopeDimension">d-sc-be:Consolidated</xbrldi:explicitMember>
     </scenario>
  </context>
  <context id="I-2007-12-OtherEMU">
     <entity>
        <identifier scheme="http://www.swift.com">TESTST04</identifier>
     </entity>
     <period>
        <instant>2007-12-31</instant>
     </period>
     <scenario>
        <xbrldi:explicitMember dimension="d-Regions-be:ByRegionsDimension">d-Regions-be:OtherEMU</xbrldi:explicitMember>
        <xbrldi:explicitMember dimension="d-sc-be:ScopeDimension">d-sc-be:Consolidated</xbrldi:explicitMember>
     </scenario>
  </context>
  <context id="I-2007-12-RestOfTheWorld">
     <entity>
        <identifier scheme="http://www.swift.com">TESTST04</identifier>
     </entity>
     <period>
        <instant>2007-12-31</instant>
     </period>
     <scenario>
        <xbrldi:explicitMember dimension="d-Regions-be:ByRegionsDimension">d-Regions-be:RestOfTheWorld</xbrldi:explicitMember>
        <xbrldi:explicitMember dimension="d-sc-be:ScopeDimension">d-sc-be:Consolidated</xbrldi:explicitMember>
     </scenario>
  </context>
  <unit id="U-Monetary">
     <measure>iso4217:EUR</measure>
  </unit>
 ...

In the example above, 3 contexts are defined, with the following ID's:

  • I-2007-12-Belgium
  • I-2007-12-OtherEMU
  • I-2007-12-RestOfTheWorld

All three contain dimensional information regarding two XBRL dimensions: ScopeDimension and ByRegionsDimension. One unit is defined (U-Monetary), indicating the use of the EURO currency.

Facts and primary concepts

The reported data in an XBRL instance document are known as ‘facts’. A fact is reported by referring to its primary concept (defined by the taxonomy) and references to its contextual information defined by a context element, a unit element and a number of other attributes depending on the data type of the concept being reported.

  <ifrs-gp:CashAndBalancesWithCentralBanks contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">2970321000</ifrs-gp:CashAndBalancesWithCentralBanks>			
     <ifrs-gp:CashAndBalancesWithCentralBanks contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">709174000</ifrs-gp:CashAndBalancesWithCentralBanks>			
     <ifrs-gp:CashAndBalancesWithCentralBanks contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">753252607</ifrs-gp:CashAndBalancesWithCentralBanks>			
     <ifrs-gp:FinancialAssetsHeldForTradingTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">4601911527</ifrs-gp:FinancialAssetsHeldForTradingTotal>			
     <ifrs-gp:FinancialAssetsHeldForTradingTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">29760434449</ifrs-gp:FinancialAssetsHeldForTradingTotal>			
     <ifrs-gp:FinancialAssetsHeldForTradingTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">23396601036</ifrs-gp:FinancialAssetsHeldForTradingTotal>			
     <ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">1364964840</ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal>			
     <ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">231126000</ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal>			
     <ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">1594727199</ifrs-gp:FinancialAssetsDesignatedAsFairValueThroughProfitOrLossTotal>			
     <ifrs-gp:AvailableForSaleFinancialAssetsTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">17399874637</ifrs-gp:AvailableForSaleFinancialAssetsTotal>			
     <ifrs-gp:AvailableForSaleFinancialAssetsTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">29728469000</ifrs-gp:AvailableForSaleFinancialAssetsTotal>			
     <ifrs-gp:AvailableForSaleFinancialAssetsTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">5565266331</ifrs-gp:AvailableForSaleFinancialAssetsTotal>			
     <ifrs-gp:LoansAndReceivablesTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">81536712304</ifrs-gp:LoansAndReceivablesTotal>			
     <ifrs-gp:LoansAndReceivablesTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">54521384945</ifrs-gp:LoansAndReceivablesTotal>			
     <ifrs-gp:LoansAndReceivablesTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">35605182080</ifrs-gp:LoansAndReceivablesTotal>			
     <ifrs-gp:HeldToMaturityInvestmentsTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">345118000</ifrs-gp:HeldToMaturityInvestmentsTotal>			
     <ifrs-gp:HeldToMaturityInvestmentsTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">2503013000</ifrs-gp:HeldToMaturityInvestmentsTotal>			
     <ifrs-gp:HeldToMaturityInvestmentsTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">162337689</ifrs-gp:HeldToMaturityInvestmentsTotal>			
     <ifrs-gp:HedgingAssetsTotal contextRef="I-2007-12-Belgium" decimals="2" unitRef="U-Monetary">5977474</ifrs-gp:HedgingAssetsTotal>			
     <ifrs-gp:HedgingAssetsTotal contextRef="I-2007-12-OtherEMU" decimals="2" unitRef="U-Monetary">145571284</ifrs-gp:HedgingAssetsTotal>			
     <ifrs-gp:HedgingAssetsTotal contextRef="I-2007-12-RestOfTheWorld" decimals="2" unitRef="U-Monetary">178358452</ifrs-gp:HedgingAssetsTotal>
  </xbrl>

This example illustrates several of the ideas presented earlier in this document: Namespaces prefixes are used, along with element names to reference the element definitions of the primary concepts. Contexts and units references are used to give contextual information to the reported numbers. The instance document ends with the closing tag of the main <xbrl> root node.


Validation of XBRL reports

One of the fundamental processes required in the handling of XBRL data is the validation of instance documents. The goal of the validation process is the ensure consistency of the reported information according to the different rules imposed by the XBRL standard and by the referenced XBRL taxonomy.

The validation process involves the following steps:

  • XML validation: an XBRL document must be a well-formed XML document
  • XML Schema validation: an XBRL document must be valid according the Schema defined by the taxonomy (its structure, data types, etc.)
  • XBRL validation structure. Some rules which are not covered by the taxonomy's schema validation are defined by the XBRL specification. For example, a monetary concept must be accompanied by a unit.
  • Validation rules: an XBRL taxonomy can contain certain restrictions defined within the taxonomy linkbases (such as the calculation linkbase).
  • Dimensional validation: reported information needs to be valid against the dimensional constraints imposed by the taxonomy. A dimension may not take values that are not specified in its domain, o a metric may not be reported for an invalid combination of dimensions
  • Formula validation: if the taxonomy contains XBRL formulas, the reported information may be assessed according to the formulas defined in the taxonomy

All validation steps are generally executed by specific XBRL software.

Further Reads

Standards & Specifications

[1] XBRL International - overview of XBRL Specifications: http://www.xbrl.org/SpecRecommendations/

[2] The XBRL 2.1 Specification: http://www.xbrl.org/Specification/XBRL-2.1/REC-2003-12-31/XBRL-2.1-REC-2003-12-31+corrected-errata-2013-02-20.html

[3] The XBRL Dimensions Specification: http://www.xbrl.org/specification/dimensions/rec-2012-01-25/dimensions-rec-2006-09-18+corrected-errata-2012-01-25-clean.html

[4] The XBRL Formula Specification: http://www.xbrl.org/specification/formula/rec-2011-10-24/index-2011-10-24.htm

[5] W3C overview of XML technologies: http://www.w3.org/standards/xml/

[6] W3C Recommendation of XML: http://www.w3.org/TR/REC-xml/

[7] W3C Recommendation of XML Namespaces: http://www.w3.org/TR/REC-xml-names/

[8] W3C Recommendation of XML Schema: http://www.w3.org/TR/xmlschema-1/


General info

[9] http://www.xbrl.org/GettingStarted

[10] http://www.xbrl.org/how-xbrl-works-1

[11] http://www.eurofiling.info/documents/documents_project.shtml

[12] http://www.wikixbrl.info/index.php?title=Main_Page

[13] Debreceny, Roger; Felden, Carsten; Ochocki Bartosz; Piechocki, Maciej; Piechocki, Michal (2009). XBRL for Interactive Data: Engineering the Information Value Chain. Springer, Dordrecht Heidelberg London New York. ISBN 978-3-642-01436-9

Personal tools