Monday, September 22, 2014

New XBRL Formula Editor in XMLSpy

I'm very excited about all the new features in XMLSpy 2015, and in particular about the new XBRL Formula Editor, which now lets you build formulas more intuitively using a XBRL Table Linkbase layout preview. The XBRL Table Linkbase specification provides a mechanism for taxonomy authors to define a tabular layout of facts. The resulting tables can be used for both presentation and data entry. In XMLSpy 2015 we use these tables as a way to specify variables in XBRL Formula definitions.

However, XBRL Table Linkbase is a fairly young specification, so not many published XBRL taxonomies include Table Linkbase definitions yet. Please see my previous blog post, where I have demonstrated how to add a Table Linkbase to an existing XBRL extension taxonomy.

Once we have a taxonomy with a Table Linkbase attached to it, we can then proceed to create some assertions or calculations using XBRL Formula Editor. In this video, I will demonstrate how to do this using a recent SEC filing as an example instance:

The new XBRL Formula Editor is one of the many new features introduced in the new Altova version 2015 product line last week, which includes new versions of XMLSpy, MapForce, all the other MissionKit tools, and all Altova server products.

No comments: