Skip to content

Edit Fields ​

New ​

With the New menu, new fields can be added to the consolidation.

new

New Dimension ​

Adds a dimension-field from the associated table of the consolidation.

new-dimension

New Number ​

Adds a number-field from the associated table of the consolidation.

new-number

New Text ​

Adds a text-field from the associated table of the consolidation.

new-text

New Time Conversion ​

If the table of the consolidation uses fixed dimensions (date or time), a conversion dimension can be used. E.g. the tables contains the month dimension, the year dimension can be used for the query. The month-items are automatically converted into years.

new-time-conversion

New Calculation ​

Adds a calculated field (number or text). These fields are calculated when retrieving the data. A visual script is used for the calculation.

new-calculation

New Series ​

Opens the assistant to create a series.

new-series

Copy ​

Copies a field.

copy

Delete ​

Deletes a field.

First, Up, Down and Last ​

Moves a field.