You are processing a form with two
axes and would like to define the first column. To do so, position
the cursor on the column you want to define and double-click with
the left mouse button.
Next, decide whether you want to define the element from
nothing (choose Characteristics or Key figures) or
copy an element from a form with one axis (choose Predefined
If you choose Characteristics, the system displays a list
of characteristics you can choose from. Select as many as you wish
from this list. As you continue defining your form, the system will
ask you to specify a characteristic, an predefined element or a
formula for each column you define. The key figures will go in the
If you choose Key figures, the system displays a list of
key figures to choose from. As you continue defining your form, you
will need to specify a key figure, a predefined element or a
formula for each column you define.
In this example we will choose Key figures.
The next dialog box contains a list of all the characteristics
which you can use to define the columns. If you choose a key figure
(such as Trade balance 1) whose currency is dependent
on a certain characteristic (such as Company), the
system automatically selects that characteristic. You can select as
many entries as you wish.
In the next dialog box, you need to enter the characteristic
values you want to use to define the characteristics. You can also
use variables instead of specifying individual values. To do this,
position the cursor on the desired field and choose Variable
on/off. The system will automatically place a selected checkbox
before that field, and the field length will change. If you want to
use a global variable, you can display possible entries using
If you want to use a local variable, you also need to begin the
variable name with $. Otherwise the system will recognize
the variable as a global variable and check to make sure that it
exists. If you wish to enter fixed characteristic values
immediately, you can enter single values or an interval of values.
You can also enter a number of values or intervals by choosing the
You must specify a single value for a characteristic
which determines the currency of a selected value field. You are
not allowed to enter an interval.
If you change a characteristic value which you already entered,
you can update the text display using Refresh. Using
Delete you can remove one of the characteristics.
In the next dialog box, enter three texts to described the
element. If you are defining a new element, the system proposes the
text of the from-value of the first characteristic as a default.
You can later define which text should be displayed using the menu
option Text length (Format®All
columns®Text length...). If you
defined a variable for the characteristic value, it makes sense to
define one for the text here as well.
When you define the second element and later ones in the same
axis, the first dialog box lets you decide whether you want to
define the element using characteristics and their values or using
a formula. If you choose Formula, the system takes you to
the formula editor, where you can define the formula using the
other elements of that axis and specially defined cells.
If you define more than one element with a key figure whose
currency is determined by the value of a characteristic, you can
enter a different value of that characteristic in each element.
That way you can display different currencies next to each other in
the same report.
You maintain the rows in the same manner. Row, column and cell
processing are described in detail under Defining Elements.