excel xbrl mappers l.
Skip this Video
Download Presentation
Excel ↔ XBRL mappers

Loading in 2 Seconds...

play fullscreen
1 / 12

Excel ↔ XBRL mappers - PowerPoint PPT Presentation

  • Uploaded on

Excel ↔ XBRL mappers. Steering Committee, 2005-06-03. Why preparing own mapper tools?. The COREP taxonomies contain functionality that is new in XBRL and is being included in the specification, i. e. dimensions.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Excel ↔ XBRL mappers' - suzanne

Download Now 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
excel xbrl mappers

Excel ↔ XBRL mappers

Steering Committee, 2005-06-03

why preparing own mapper tools
Why preparing own mapper tools?
  • The COREP taxonomies contain functionality that is new in XBRL and is being included in the specification, i. e. dimensions.
  • Commercial tools that are able to create xbrl instance documents are being upgraded to support dimensions. Our tools are an example of how easy it is.
  • To test the COREP taxonomies tools are needed when creating XBRL instance documents on basis of the COREP templates.
test case creation
Test case creation
  • coreptest.xlt file is used to fill in test data inside the COREP templates on basis of Excel tables.
  • Each user can prepare as many templates as he needs to build up a complete test case.
  • Data can be used for analyses without reference to a special bank or test unit, because the spreadsheet has an anonymous ID.
  • Fernando Wagener (NCB ES)
xbrl instance creation preparations
XBRL instance creation: Preparations
  • To enable the transformation of the Excel test file the formats and all additional sheets have to be removed by running a macro.
  • The file has to be saved on the hard drive.
  • The new created excel file can be uploaded to the mapper application.
xbrl instance creation architecture
XBRL instance creation: Architecture
  • Java based web: standard technology.
  • Uses only free available open source packages.
  • Application can be run on an open source web server called Apache Tomcat.
  • XBRL validation will be included in following phases.
  • The application can be freely used from all over Europe by the internet.
  • Katrin Schmehl (NCB DE)
xbrl instance creation web based
XBRL instance creation: Web based


Coreptest.xls file

XBRL instance document

xbrl instance creation application design
XBRL instance creation: Application design

Web Server (Apache Tomcat)





Hosted by a Supervisor

retrieval from xbrl instance architecture
Retrieval from XBRL instance: Architecture
  • Web Based .NET application. Runs on Microsoft IIS
  • Can run in parallel on the same server with XBRL instance creator
  • XBRL validation is skipped
  • The application can be freely used from all over Europe by the internet.
  • Panagiotis Voulgaris (NCB GR)
xbrl instance creation web based9
XBRL instance creation: Web based


Excel file

XBRL instance document

retrieval from xbrl instance design
Retrieval from XBRL instance: Design

Web Server (Microsoft IIS)


Upload XBRL file

Identify Templates

Use CP04 to convert to Excel

Publish Excel file

Hosted by a Supervisor

next steps
Next steps
  • Integration of a XBRL validator from a software Vendor for testing and presentation purposes
  • Connection to a database to store XBRL instance documents as a whole
  • Test to integrate a Vendor database mapping: All XBRL instance data to be stored into relational database tables
  • short demo of the applications