Example: Creating a Form (EC-EIS / CO-PC)

  1. 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.
  2. 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 element).
  3. 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 rows.

    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.

  4. 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.
  5. 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 F4 . 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 pushbutton More...
  6. 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.

  7. 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.
  8. 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.
  9. 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.

  10. You maintain the rows in the same manner. Row, column and cell processing are described in detail under Defining Elements.