How How to to integrate integrate XBRL XBRL technology technology in in your your company company with with a a minimal minimal impact impact (Jos (Jos Vilata, Vilata, EDICOM) EDICOM) Objectives To show how we can integrate incoming and outgoing XBRL documents in existing systems with a minimal impact on current applications.
We will develop a mapping that will convert data from two related tables in Microsoft Access to an XBRL instance document using drag-and-drop techniques. Also, we will show EDICOM XBRL tools, web based user tools for managing XBRL instance documents and XBRL taxonomies with a lot of friendly wizards. The scenario Normally well have some existing applications that store the data in some customised format and we will need to transform that data to XBRL documents with minimal impact and cost INTERNAL INTERNAL SYSTEM WITH SYSTEM WITH OWN DATA OWN DATA DO SOMETHING DO SOMETHING TO OBTAIN XBRL
TO OBTAIN XBRL DOCUMENTS DOCUMENTS XBRL XBRL DOCUMENTS DOCUMENTS How can we make this transformation with a minimal impact on our existing systems ? The solution: a mapper A solution to the previous problem is to use a mapping tool like EDICOM EBIMAP XBRL to do that: INTERNAL INTERNAL SYSTEM WITH SYSTEM WITH PROPRIETARY
PROPRIETARY DATA DATA XBRL XBRL DOCUMENTS DOCUMENTS EBIMAP will access the existing data in any format and will convert it to any other format such as XBRL How does the Mapper work ? A Mapper performs data transformations Each transformation consist of : a source data schema, a destination data schema and a set of rules that enables us to convert the original structure into the target (the map). SOURCE DATA
SOURCE DATA STRUCTURE STRUCTURE (TEXT,DB,XML,) (TEXT,DB,XML,) TRANSFORMATION TRANSFORMATION RULES RULES TARGET DATA TARGET DATA STRUCTURE STRUCTURE (XBRL,XML,TEXT, (XBRL,XML,TEXT, DB,ETC.) DB,ETC.) What is a data schema ? A data schema represents the structure of the data that:
We use as the source for the transformation, usually the representation of the company data structure in their own format We use as the target of the transformation. An example: We have created the schema of this Access table in EBIMAP Another schema example: an XBRL taxonomy We will use an example taxonomy that represents the accounting movements of the company: AccountMov XBRL taxonomy as a schema in EBIMAP The XBRL taxonomy is loaded automatically as a data schema Transformation (mapping) The mapping is a set of rules that enables us to convert the original structure into the target To do the mapping we only need to specify the source and target data schema Transformation (mapping) (II)
Usually the mapping is constructed without any coding We link the elements with drag-and-drop techniques Also, we can use a complete scripting language for more complex transformation Result We only need to run the map to see the results of the transformation Integration with current systems One we have seen how we can transform our internal data to XBRL documents, we need to integrate this process in our applications We can choose between: Using API: JAVA, WINDOWS (implements Web Services). Using line commands Public Public Function Function ExecuteEBIMAP(strSourceData ExecuteEBIMAP(strSourceData As As String,
String, strTargetData strTargetData As As String, String, strMapping As String, strFilter As String) strMapping As String, strFilter As String) For For example: example: ExecuteEBIMAP ExecuteEBIMAP (, (, c:\targetDir\,AccountingToXBRL.ma4, c:\targetDir\,AccountingToXBRL.ma4, ) ) In In this this case
case we we only only need need to to fill fill in in the the name name of of the the mapping mapping (AccountingToXBRL) (AccountingToXBRL) and and the target directory where the files resulting from
the transformation will be written. the target directory where the files resulting from the transformation will be written. The The source source data data comes comes from from data data base base and and so so itit is is configured configured in in the the map. map.
Taking XBRL integration one step forward Once our company can manage incoming and outgoing XBRL documents we need to give access to company users of these reports in an easy way EDICOM provides the EBI XBRL EDITION suite to do that. It is composed of: An XBRL taxonomy editor and repository An XBRL instance and taxonomy parser and validator An XBRL instance document data base repository A communication server with multiple protocols (Web services, HTTP, FTP, SMTP, etc.) A specialised security module that enables digital signature and encryption A Web based user interface to easily manage and deploy the XBRL technology in our company EBI XBRL EDITION overview A common EBI XBRL EDITION installation could be as follows:
INTERNAL INTERNAL MANAGEMENT MANAGEMENT SYSTEM SYSTEM INTERNAL INTERNALXBRL XBRL COMPANY COMPANYUSERS USERS WEB SERVICES UNIVERSAL VALIDATOR AND REPOSITORY MANAGER
SECURITY AND COMMUNICATION MODULE WEB USER INTERFACE REPOSITORY OTHER OTHERPARTNERS PARTNERS WEB INTERFACE EXAMPLE The users will access an environment like this: The Theuser usercan canimport, import,export, export,print, print,delete
deleteand andedit editall allthe thedocuments documents depending on the permission he has depending on the permission he has He Hecan cansee seeand andreview reviewall allthe thedocuments documentsthat
thatthe thesystem systemis isprocessing processing automatically automatically All Allthe theenvironment environmentcan canbe becustomised customised(colours, (colours,folders, folders,buttons, buttons,etc.) etc.) XBRL TAXONOMY EDITOR overview The suite provides a web based XBRL TAXONOMY EDITOR
The Theeditor editorhas hasaalot lotof ofuser userhelps helpsand andwizards wizardsto toaid aidin inthe thecreation creationof oftaxonomies taxonomies CONCLUSION We have seen how we can integrate incoming and outgoing XBRL documents in existing systems with a minimal impact on current applications.
We have seen that there are existing tools like EBI XBRL EDITION that help us to do that We have seen that we have tools to deploy XBRL technology in our company in an easy way SO, It It is is time time to to roll roll out out XBRL XBRL technology technology in in our our companies, companies, there there is is no no technical
technical reason reason not not to to do do it it !!! !!! Many thanks !!! Jos Vilata [email protected] www.edicomgroup.com
Umělé srdce Náhrada z Titanu a plastu Externí napájení Abiocor - v klinických testech Již bez externího napájení Plně nahrazuje orgán Pacient s implantátem Abiocor žil 17 měsíců Zemřel na opotřebení membrány Plicní náhrada Nová plně funkční náhrada Ovládaná a...
Ink and paper. Timeline: 4th Century BC (Egypt) 1867 (Typewriter patent-QWERTY) ... History of Office Tools/Innovation. 1960s: Standard pencil and paper, most items hand written. Basic telephone. Standard desk/office space (cubicle farms) Libraries, books, articles, encyclopedias. History of ...
Comparing film and video game reviews: A report using computer-aided text analysis By Ben Gifford Cleveland State University December 7, 2011 Discussion Problems Yoshikoder Sampling Future directions Financial impact of critical reviews Quanitfy differences between critcal essays and reviews More...
Unless contrary NACHA Rule Article 4 rules apply. Probably, as a matter of private contract banks agree to be liable for wrongfully dishonored debits as if they were items and Article 4 applied! Problem 8.9.4.a Cliff pays by POS conversion...
The poem explores power and status. The poet admires Ozymandias. Ozymandias was once a proud, tyrannical ruler. The poem suggests we have all the time in the world. The poem is about legacies and what we leave behind after we...
In order to fuel this idea of national superiority, European powers built up their militaries, looked to expand their empires, and sought exuberant amounts of wealth/resources. Also fueled by propaganda, literature, and other mass media. All this chest-pounding led to...
// Install node location for WiMAX base station, gateways. ... Because the smart meters send the fixed length message to the data center. University of Colorado at Colorado Springs. LAN Simulation Results. ... Presentation of Master's thesis
Ready to download the document? Go ahead and hit continue!