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.