Mapping Entry Sheets to Extension

The Mapping sheet should use exactly the same elements as defined on the Extension sheet. However, abstracts and some dimensional elements (ItemTypes Abstract, Table, and Domain) may never be used. The line item elements will be referenced in the ElementName column and axis and member elements will be referenced in columns Axis and AxisMember if the line item belongs to a table.

Maximum of two empty rows are allowed between the mapping rows. If you want to insert more empty rows, remember to comment them by inserting "/*" to the first column. If you want to quickly "comment" the rest of the sheet, you can add 3 empty rows to the position where you want to start this.

Single cells on entry sheets may be tagged to all elements used for tagging.  These cells may, however, be merged cells. A fact row on the Mapping sheet is connected to a cell on an entry sheet with a cell reference. The cell reference may start with a plus sign (e.g. "=+'My entry sheet'!A1") as is usually the case when a reference is done using the plus key.

Textblock type elements may be tagged to an area, which must consist of full rows of an entry sheet (also called block tagging). Supported functions are ISREF and CONCAT. Multiple areas may be tagged to same element. An example of ISREF and multiple areas: =ISREF(area1)&ISREF(area2)&ISREF(area3). Example of CONCAT and multiple areas: =CONCAT(area1;area2;area3).

The block tag areas may be nested, i.e., area inside another area, and even several layers of nesting are possible. The areas must not include partially same rows, for example areas consisting of rows 1–4 and 4–9 of the same sheet are not allowed (row 4 in both areas). It is also recommended that the nested areas would not start or end in the same row; in these cases the opening and ending tags might be in incorrect order in the xHTML. As a result the content gets "switched", or a syntax error of type "tag mismatch" is created to the file.

Marking up a figure on the entry sheet by creating a cell reference from Mapping sheet to the entry sheet (also called 'tagging')

Marking up (tagging) a named area on the entry sheet using ISREF function