Please enable JavaScript to view this site.

Altova® EBA add-in for Excel, version 2020

Creating a New Report

Entering Data into Three-Dimensional Tables (Z-Axis)

Scroll Home Prev Top Next More

Most of the report tables have only two dimensions: the x-Axis (columns) and the y-Axis (rows). However, there are some tables where you may need to enter data into a third dimension (the z-Axis). An example of such a table is the "F 34.00.c (AE CON)" table available through the entry point AE CON: Asset Encumbrance, Consolidated. This table may need an additional sheet for each currency. As shown below, cell F3 is a drop-down list from where you can select a currency.

inc-xa-eba-z-axis1

In cases such as the one above, you can add a new sheet along the z-Axis (third dimension) of the table, as follows:

 

1.In the Excel ribbon, click the EBA tab.

2.Click the Add New Sheet (z-Axis) button. Note that the commands to insert or delete new z-Axis sheets are enabled only if the table supports adding a z-Axis.

inc-xa-eba-z-axis2

Alternatively, right-click the table in the EBA Filing Pane and select Add New Sheet (z-Axis) from the context menu, for example:

inc-xa-eba-z-axis3

This creates a new sheet that displays the third dimension of the table (z-Axis). The sheet representing the z-Axis always has an indicative name that resembles the original table. In this example, if you select "Euro" as currency, the new sheet is called "F 34.00c (EUR).

 

Data from the third dimension (z-Axis) of a table are displayed as new sheets in Excel. Therefore, three-dimensional tables span across more than one sheet. This is an exception to the rule that one Excel sheet corresponds to one table in the XBRL report. In the XBRL instance, data that belongs to the z-Axis will be, however, correctly reported as part of the same table.

 

When you click a cell that represents z-Axis, all the possible values for the drop-down list are displayed in the Cell tab of the EBA Filing Pane, for example:

inc-xa-eba-z-axis4

 

Deleting z-Axis sheets

You can delete sheets that contain data from the third dimension (z-Axis) in more than one way.

 

1.Select the required sheet (or click the corresponding entry in the "Tables" section of EBA Filing Pane).

2.Do one of the following:

In the EBA tab, click Remove Sheet (z-Axis), or

Right-click the table in the EBA Filing Pane and select Remove Sheet (z-Axis) from the context menu.

inc-xa-eba-z-axis5

© 2019 Altova GmbH