Working with XBRL Tables

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > XBRL >

Working with XBRL Tables

If your XBRL taxonomy references the table linkbase (see Table Linkbase Specification 1.0), MapForce can be configured to display the node types applicable to the table linkbase (such as tables or breakdowns). This enables you to map data to or from facts displayed in rendered tables.

 

 

To show the "Tables from table linkbase" view on the XBRL component:

1.On the Insert menu, click XBRL Document and browse for the XBRL instance file, see also Adding XBRL Files as Mapping Components.
2.On the root element of the XBRL component, click the Show Context Menu ( XBRLComponentContextMenu ) button, and then Select Structure Views.
3.Select the Tables from table linkbase check box, and click OK.

mf_xbrl_select_views

For information about other views, see Selecting Structure Views.

 

Notes

When reading data from an XBRL component (that is, if the XBRL component is a source component), you can choose any combination of structure views from the context menu XBRLComponentContextMenu. However, when writing data to XBRL, if the Tables from table linkbase view is selected, it is not possible, for technical reasons, to write data to any other view except this one.
The Tables from table linkbase view requires that "Built-in" is set as transformation language (see also Selecting a transformation language).

 

To render information from the table linkbase, MapForce normally uses the structural model, with the following exceptions:

 

Merged rule nodes are visible
Roll-up nodes without siblings do not form a separate hierarchy level.

 

The structural model is one of the three data models defined by the Table Linkbase Specification 1.0, §4. To identify the parts of the structural model referenced by the mapping, MapForce also uses information from the definition model.

 

Since a MapForce component structure is one-dimensional, whereas tables can have up to three dimensions (x, y, z), MapForce displays table dimensions by nesting all breakdowns within each other, in the following default order: z, y, x. As such, the purpose of breakdowns nodes in MapForce is to inform you where each breakdown starts.

 

This section includes instructions on how to work with entities from the table linkbase, as follows:

 

Showing or Hiding Breakdowns
Changing the Order of Breakdowns
Working with Parameters

© 2019 Altova GmbH