Create New Column Definitions

Here you can edit, delete and copy column definitions and create new column definitions.

Procedure

  1. On the Reports menu, click Create. The Create Reports window opens.
  2. Open the Column Definition tab.
  3. To create a new column definition, click the New button to clear all fields for entry.
  4. In the Code text box, enter a code of maximum four alphanumeric characters.
  5. In the Name - Group and Name - Local text boxes, enter the full name of the column definition in both the group language and the local language.
  6. If you selected Period and Actuality in the Column Definition list box on the Axes tab, enter the period and actuality to be displayed in the report in the Period Formula and Actuality columns.
  7. If the texts do no appear automatically, enter the group and local text explanations of the selected dimensions. To display the text explanations of several dimensions, print the functions as follows: =cc.fPer();=cc.fAct();=cc.fComp(). Up to four text explanations can be displayed under each other on separate rows. For each dimension column the code, name or free text can be entered. Press spacebar on the field to be able to change it.
  8. Repeat steps 6-7 until all columns have been defined.
  9. Click Save.
  10. Click the Go to Layout in Excel button to open the Report Layout Worksheet.

Results

A complete list of all user defined column definitions and their included dimensions with their selected choices can be printed under menu Reports/Definitions.