Excel xbrl mappers l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Excel ↔ XBRL mappers PowerPoint PPT Presentation


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

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.

Download Presentation

Excel ↔ XBRL mappers

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 l.jpg

Excel ↔ XBRL mappers

Steering Committee, 2005-06-03


Why preparing own mapper tools l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

XBRL instance creation: Web based

Internet

Coreptest.xls file

XBRL instance document


Xbrl instance creation application design l.jpg

XBRL instance creation: Application design

Web Server (Apache Tomcat)

http://<server>/corep/

Servlet

JSP

Taxonomies

Hosted by a Supervisor


Retrieval from xbrl instance architecture l.jpg

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 l.jpg

XBRL instance creation: Web based

Internet

Excel file

XBRL instance document


Retrieval from xbrl instance design l.jpg

Retrieval from XBRL instance: Design

Web Server (Microsoft IIS)

http://<server>/corep-printout/

Upload XBRL file

Identify Templates

Use CP04 to convert to Excel

Publish Excel file

Hosted by a Supervisor


Next steps l.jpg

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


Slide12 l.jpg

DEMO

  • short demo of the applications


  • Login