In the
Function Use
view, determine in which template cells (row/column intersection) a
function can be used.
When arranging functions in sub-environments , the row categories, columns and column types available for you to process depends on the template application you chose. You can choose the template application through your filter entry before creating the function (see the example below and also Editing Functions , section "Creating functions").
See also: Example: Creating a Function .
Overview/All Columns Tabs
Overview / All Columns
: you can use the tab page Overview or All Columns for your entries. In the Overview all the types of template columns are shown; for example, Object, Quantity, Activation, and Allocation Event. A marking applies to all columns of a particular type. All existing columns are shown in All Columns ; for example, Object, Plan Quantity, Plan Activation, Plan Allocation Event, Actual Quantity, Actual Activation, Actual Allocation Event.
In the editing mode: The selection in the
Overview
is valid for the column type (for example
Quantity
). In the
All Columns
tab you can, therefore, edit all available columns with that type (for example if you deselect Plan Qty, the selection of Actual Qty remains).
The selection on the
Overview
tab shows you whether selections on the
All Columns
tab have been made uniformly or not:
Selection on Overview tab ( in editing mode) |
Settings in All Columns |
Tick in white field (changes possible) |
All columns are selected |
Tick in gray field (changes only possible in All Columns tab) |
At least one, but not all columns are selected |
No tick (changes possible) |
No columns are selected |
Column Type
The column type shows you which row categories are available (for example,
Process, Sub-Template, Calculation Row
, and so on). Which column types are available depends on the template application chosen (see example below).
Other Columns
Additional columns (object, quantity, and others): by marking the checkbox, you decide that the functions in these column-row combinations can be chosen.
Filter
By using the icon (Filter) next to a cell, you can activate or deactivate further requirements, and thereby constrain the use requirements:
In the columns for quantities and allocation events you can determine whether a function can be used as a formula component and/or as a parameter.
In the columns for
Object
and
Activation,
you can decide whether the function can be used as a
Column Header
(comparison operand 1),
Column Entry
(comparison operand 2), and/or
Parameter
.
In the editing mode: If you call the filter in the overview tab, you see through the selection of the usage criteria, whether they are uniformly set or not (in the individual columns of the
All columns
tab).
Selection on Overview tab (in editing mode) |
Settings in All Columns |
Tick in white field (changes possible) |
The usage criteria are selected in all columns |
Tick in gray field (changes only possible in All Columns tab) |
Usage criteria selected for at least one, but not all columns |
No tick (changes possible) |
No usage criteria selected |
Switching between Applications
When you display functions, you can switch between the template applications by choosing
Create a function in the subenvironment 101. Various column types and row categories are made available depending on what template application you chose.
Chosen template application |
Column types available |
Row types available |
Cost object/costing COB |
Object, quantity, activation, allocation event |
Process Calculation row (process) Flexible function (process) Cost center / activity type Calculation row (cost center/activity type) |
Cost center/process activity allocation SBP |
Object, quantity/costs, activation |
Process Cost center / activity type Calculation row (process) Calculation row (cost center/activity type) |
Profitability segment PAC |
Object, quantity, activation |
Process Calculation row (process) Flexible function (process) Cost center / activity type Calculation row (cost center/activity type) |