Excel data source driver and XBRL Database: Difference between pages

From XBRLWiki
(Difference between pages)
Jump to navigationJump to search
 
No edit summary
 
Line 1: Line 1:
==Product page==
[[http://www.reportingstandard.com/XBRL_Database.xhtml XBRL Database]]
[[File:XBRLDBIcon.png|none|left|XhBtRmL template language to produce HTML representation of XBRL reports]]
==Description==
==Description==


The Excel Data Source Driver is a configurable generic driver to obtain data from excel files and create XBRL reports inside the automatization framework provided by the XBRL Mapper engine designed by Reporting Standard.
The XBRL Database is a permament repository system implemented using relational databases and the most advanced technologies in order to allow the storage of document level information like XBRL reports, XBRL Taxonomies and XBRL Linkbases along with granular level information as XBRL Fact items, XBRL concept definitions, XBRL Labels, XBRL Resources, XBRL Relationships.


==Editors==
* The storage system allows the storage of everything that is valid XBRL 2.1
* The storage repository accepts information for any existing or new XBRL 2.1 taxonomy
* The storage system allows users to develop complex cross instance document and cross taxonomy information systems


The installation of Reporting Standard Mapper already installs an Excel plug-in that is able to edit the configuration file described in the next section. Advanced users can take advantage of editing the XML configuration files manually or creating their own editing applications.
There is a live demo of the XBRL Database that store all the information published by the SEC here [[http://www.xbrl4.org/regulators/ExploreXBRL.html ExploreXBRL direct link]].


==Configuration file==
For more information about the XBRL Database please contact reporting standard directly by sending an email to info at reportingstandard.com


The configuration file is provided during the driver declaration inside the instance document template file. See [[XBRL Template File#Definition_of_data_sources]] for more information. The driver class is '''com.ihr.xbrl.mapper.source.ExcelDataSource'''
Starting with version 2.6.12 of Reporting Standard S.L. tools, the XBRL Database functionality has been incorporated into XBRLizer and XBRLViewer. Also, a new software component has been created in order to access to information stored in the XBRL Database from Excel formulas.


Sample Excel driver data source declaration:
Now, the XBRL Database can receive XBRL reports from:
<syntaxhighlight lang="xml">
  <datasources>
    <source
      id="source0"
      class="com.ihr.xbrl.mapper.source.ExcelDataSource"
      config="Excel-driver-config.xml"/>
  </datasources>
</syntaxhighlight>


The configuration file must be valid according to a very simple XML Schema that has no namespace and that is published in the following official location <nowiki>http://www.reportingstandard.com/schemas/mapper/XBRLDataSourceExcelMapSchema.xsd</nowiki>
* The XBRL Validation component (server mode) after XBRL 2.1 validation is finished with no errors.
* The XBRL Grab daemon that periodically search for new reports published (We currently support the SEC RSS feed)
* XBRLizer and XBRLViewer, using the File -> XBRL Database -> Store document into the XBRL Database.
* All the components above relays on a API component in the library for storing a DTS into the XBRL Database. That API is available from other applications to use.


Sample configuration file:
The XBRL Database can be used from:
<syntaxhighlight lang="xml">
<!-- Sample configuration file for ExcelDataSource content -->
<XBRLDataSourceExcelMap
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:noNamespaceSchemaLocation
    ="http://www.reportingstandard.com/schemas/mapper/XBRLDataSourceExcelMapSchema.xsd">
  <map>
    <mapId>ifrs-gp_CostOfSales</mapId>
    <cell>CostsSheet!costofsales</cell>
  </map>
  <map>
    <mapId>ifrs-gp_Revenues</mapId>
    <cell>RevenuesSheet!D1</cell>
  </map>
</XBRLDataSourceExcelMap>
</syntaxhighlight>


The example above shows the content of the mapping configuration file. The root element is the '''XBRLDataSourceExcelMap''' element whose content is a set of '''map''' elements. In turn, a '''map''' element is a sequence of two other elements called '''mapId''' and '''cell'''.
* XBRLizer, XBRLviewer and any other API component the File -> Open component has a button to open data from the XBRL Database. The XBRL Database can be used as a proxy for official documents based on the absolute document URI.
* The Excel functions that access information in XBRL reports using filters.
* Any other application trying to load information from SQL to another BI (Business Intelligence) system.


The '''mapId''' element content is a string that corresponds to the mapIdentifier string of existing events [[XBRL Template File#Events]] in the instance document template.
==User data model==
The XBRL Database API provides a mechanism to extend the XBRL data model. This allows developers using Reporting Standard XBRL API to create their own data model and tables on top of the XBRL data model and use them as any other tables in the model.


The '''cell''' element content is a cell reference inside the Excel book. It may have two different formats:
There is more information in the [[How to add classes to the XBRL Database model]] wiki page.
* explicit address to a specific cell using ''sheetname''!''Reference'' where ''Reference'' takes the form for a colum letter followed by the row number, or
* relative address to a specific cell using ''sheetname''!''cellname'' where ''cellname'' is an existing named range in the excel file.


==Navigation==
==Navigate==
[[Main Page]] | [[XBRLmapper]]
[[Main Page]]

Revision as of 15:28, 4 September 2013

Product page

[XBRL Database]

XhBtRmL template language to produce HTML representation of XBRL reports

Description

The XBRL Database is a permament repository system implemented using relational databases and the most advanced technologies in order to allow the storage of document level information like XBRL reports, XBRL Taxonomies and XBRL Linkbases along with granular level information as XBRL Fact items, XBRL concept definitions, XBRL Labels, XBRL Resources, XBRL Relationships.

  • The storage system allows the storage of everything that is valid XBRL 2.1
  • The storage repository accepts information for any existing or new XBRL 2.1 taxonomy
  • The storage system allows users to develop complex cross instance document and cross taxonomy information systems

There is a live demo of the XBRL Database that store all the information published by the SEC here [ExploreXBRL direct link].

For more information about the XBRL Database please contact reporting standard directly by sending an email to info at reportingstandard.com

Starting with version 2.6.12 of Reporting Standard S.L. tools, the XBRL Database functionality has been incorporated into XBRLizer and XBRLViewer. Also, a new software component has been created in order to access to information stored in the XBRL Database from Excel formulas.

Now, the XBRL Database can receive XBRL reports from:

  • The XBRL Validation component (server mode) after XBRL 2.1 validation is finished with no errors.
  • The XBRL Grab daemon that periodically search for new reports published (We currently support the SEC RSS feed)
  • XBRLizer and XBRLViewer, using the File -> XBRL Database -> Store document into the XBRL Database.
  • All the components above relays on a API component in the library for storing a DTS into the XBRL Database. That API is available from other applications to use.

The XBRL Database can be used from:

  • XBRLizer, XBRLviewer and any other API component the File -> Open component has a button to open data from the XBRL Database. The XBRL Database can be used as a proxy for official documents based on the absolute document URI.
  • The Excel functions that access information in XBRL reports using filters.
  • Any other application trying to load information from SQL to another BI (Business Intelligence) system.

User data model

The XBRL Database API provides a mechanism to extend the XBRL data model. This allows developers using Reporting Standard XBRL API to create their own data model and tables on top of the XBRL data model and use them as any other tables in the model.

There is more information in the How to add classes to the XBRL Database model wiki page.

Navigate

Main Page

Retrieved from "https://reportingstandard.com/wiki/index.php?title=Excel_data_source_driver&oldid=348"