Allocation Configuration Cube

This cube contains the definition of all allocation processes. It consists of the following dimensions:

Batch Procedure Configuration: See article Batch Procedure Configuration Dimension (Profit Center Model).
Profit Center: Unless stated otherwise for specific measures this dimension is not used. Values are stored on the ~ (Not applicable) element. For the content of this dimension see article Profit Center Dimension.
Cost Object: Unless stated otherwise for specific measures this dimension is not used. Values are stored on the ~ (Not applicable) element. For the content of this dimension see article Cost Object Dimension

Elements in the Allocation Configuration_measure dimension consist of the following groups:

Measures on the root level

These are general measures which apply to the allocation step in total

Element	Definition
Allocation Method	Indicates the type of the allocation step to allocate costs between profit centers or cost objects. Valid values are: `Equal-PC-Intra`: Equal distribution to Profit Centers (Intracompany) `Equal-CO-Intra`: Equal distribution to Cost Objects (Intracompany) `Alloc-PC-Intra`: Allocation by Profit Center key (Intracompany) `Alloc-CO-Intra`: Allocation by Cost Object key (Intracompany) `IAA-PC-Intra`: Internal activity allocation by Profit Center service relationships (Intracompany) `IAA-CO-Intra`: Internal activity allocation by Cost Object service relationships (Intracompany) (string)
Procedure Iterations	Indicates the number of times the whole allocation batch procedure should be executed. By default this is 1. Valid values are ordinals in the range 1 to 10. This measure is only valid on the executable procedure level of the `Batch Procedure Configuration` dimension. (string)
Step Iterations	Indicates the number of times a step within the selected allocation method should be executed. By default this is 1. Valid values are ordinals in the range 1 to 10. This measure is only meaningful on the step level of the `Batch Procedure Configuration` dimension. (integer)

Measures in the Primary Cost group

The measures in this group define the values that are allocated through filtering on several dimensions. These are only valid if the allocation method is set to Equal-PC-Intra, Equal-CO-Intra, Alloc-PC-Intra or Alloc-CO-Intra.

Element	Definition
Primary Cost Partner Entity Operator	Defines the nature of the `Primary Cost Partner Entity` filter. Valid values are `equal`: The filter denotes an element name of the dimension. `like`: The filter is a regular expression pattern to match elements of the dimension `inrange`: The filter is a numerical range returning elements greater or equal a minimum value and less or equal a maximum value, e.g. `[1000,2000]` `inAlpharange`: The filter is an alphanumerical range returning elements greater or equal a minimum value and less or equal a maximum value, e.g. `[A1000,A2000]` `Subset`: The filter is a global Subset. (string)
Primary Cost Partner Entity	Filters the values on the `Partner Entity` dimension. The valid values depend on the `Primary Cost Partner Entity Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Primary Cost Profit Center Operator	Defines the nature of the `Primary Cost Profit Center` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Primary Cost Profit Center	Filters the values on the `Profit Center` dimension. The valid values depend on the `Primary Cost Profit Center Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Primary Cost Partner Profit Center Operator	Defines the nature of the `Primary Cost Partner Profit Center` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Primary Cost Partner Profit Center	Filters the values on the `Partner Profit Center` dimension. The valid values depend on the `Primary Cost Partner Profit Center Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Primary Cost Cost Object Operator	Defines the nature of the `Primary Cost Cost Object` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Primary Cost Cost Object	Filters the values on the `Cost Object` dimension. The valid values of this measure depends on the `Primary Cost Cost Object Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Primary Cost Partner Cost Object Operator	Defines the nature of the `Primary Cost Partner Cost Object` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Primary Cost Partner Cost Object	Filters the values on the `Partner Cost Object` dimension. The valid values depend on the `Primary Cost Partner Cost Object Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Primary Cost PC Account	Filters the values on the `PC Account` dimension. Valid values are element names of this dimension. (string)
Primary Cost Percentage	Portion of the values to be allocated. The default is 1 (100%). Valid values are floating point values in the range 0...1. (numeric)

Measures in the Allocation Key group

The measures in this group define the allocation key through which the values are allocated. The allocation key can be percentage values, amounts or non-monetary values. Unless the factors in the key already totalize to 100% the system automatically computes new factors for each share. These are only valid if the allocation method is one of Equal-PC-Intra, Equal-CO-Intra, Alloc-PC-Intra or Alloc-CO-Intra.

Element	Definition
Allocation Key PC Account	This measure is only valid if the allocation method is `Alloc-PC-Intra` or `Alloc-CO-Intra`. Filters the values on the `PC Account` dimension. Valid values are element names of this dimension. (string)
Allocation Key Currency	This measure is only valid if the allocation method is `Alloc-PC-Intra` or `Alloc-CO-Intra`. Filters the values on the `Currency` dimension. Valid values are element names of this dimension (e.g. `LC`). (string)
Allocation Key Filter Type	Filter elements of the allocation dimension (the `Profict Center` dimension if allocation method is `Equal-PC-Intra` or `Alloc-PC-Intra` or the `Cost Object` dimension if allocation method is `Equal-CO-Intra` or `Alloc-CO-Intra`). Valid values are `none`: No additional filter is applied to the allocation dimension. If the allocation method is `Equal-PC-Intra` or `Equal-CO-Intra` all base elements of the dimensions receive an equal share. If the allocation method is `Alloc-PC-Intra` or `Alloc-CO-Intra` all base elements having a factor in the allocation key receive a share proportional to the factor in the key. `dimension`: The elements of the allocation dimension are filtered as specified by `Allocation Key Dimension Filter Operator` and `Allocation Key Dimension Filter`. `picklist`: The elements of the allocation dimension are filtered to all elements having `1` on `Allocation Key Picklist Filter` (string)
Allocation Key Dimension Filter Operator	This measure is only valid if the `Allocation Key Filter Type` measure is set to `dimension`. Defines the nature of the `Allocation Key Dimension Filter`. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Allocation Key Dimension Filter	This measure is only valid if the `Allocation Key Filter Type` measure is set to `dimension`. Filters the values on the allocation dimension (the `Profit Center` or the `Cost Object` dimension). The valid values depend on the `Allocation Key Dimension Filter Operator` measure. (string).
Allocation Key Picklist Filter	This measure is only valid if the `Allocation Key Filter Type` measure is set to `dimension`. Values are stored in the elements of the `Profit Center` (if allocation method is `Equal-PC-Intra` or `Alloc-PC-Intra`) or the `Cost Object` (if allocation method is `Equal-CO-Intra` or `Alloc-CO-Intra`) dimension. Valid values are `0` or `1`. (numeric)

Measures in the Service Relationships group

The measures in this group define the relationships between a provider and a consumer of an internal service. These are often non-monetary values (e.g. hours, number of devices, floor space, etc.) which are cross charged at a service rate. The combination of the service relationship and service rate charged to an internal consumer is known as the Internal Activity Allocation (IAA). The measures in this group are only valid if the allocation method is IAA-PC-Intra or IAA-CO-Intra. When the allocation method is IAA-PC-Intra the provider is the Profit Center and the consumer is the Partner Profict Center dimension. When the allocation method is IAA-CO-Intra the provider is the Cost Object and the consumer is the Partner Cost Object dimension.

Element	Definition
Service Relationships Partner Entity Operator	Defines the nature of the `Service Relationships Partner Entity` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Service Relationships Partner Entity	Filters the values on the `Partner Entity` dimension. The valid values depend on the `Service Relationships Partner Entity Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Service Relationships Profit Center Operator	Defines the nature of the `Service Relationships Profit Center` filter. Valid values are the same as describe above for the `Primary Cost Partner Entity Operator` measure. (string)
Service Relationships Profit Center	Filters the values on the `Profit Center` dimension. The valid values depend on the `Service Relationships Profit Center Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Service Relationships Partner Profit Center Operator	Defines the nature of the `Service Relationships Partner Profit Center` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Service Relationships Partner Profit Center	Filters the values on the `Partner Profit Center` dimension. The valid values depend on the `Service Relationships Partner Profit Center Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Service Relationships Cost Object Operator	Defines the nature of the `Service Relationships Cost Object` filter. Valid values are the same as described above for the `Primary Cost Cost Object Operator` measure. (string)
Service Relationships Cost Object	Filters the values on the `Cost Object` dimension. The valid values depend on the `Service Relationships Cost Object Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Service Relationships Partner Cost Object Operator	Defines the nature of the `Service Relationships Partner Cost Object` filter. Valid values are the same as described above for the `Primary Cost Partner Entity Operator` measure. (string)
Service Relationships Partner Cost Object	Filters the values on the `Partner Cost Object` dimension. The valid values depend on the `Service Relationships Partner Cost Object Operator` measure. When the filter selects consolidated elements the values are taken from their corresponding base elements. (string).
Service Relationships PC Account	Filters the values in the `PC Account` dimension. Valid values are elements named in this dimension. (string)
Service Relationships Percentage	Portion of the values to be cross charged. The default is 1 (100%). Valid values are floating point values in the range 0...1. (numeric)
Service Relationships Filter Type	Filter elements of the cross-charge dimension (the `Profict Center` dimension if allocation method is `IAA-PC-Intra` or the `Cost Object` dimension if allocation method is `IAA-CO-Intra`). Valid values are `none`: No additional filter is applied to the allocation dimension. All base elements having a service relationship in the cross-charge partner dimension (the `Partner Profict Center` dimension if allocation method is `IAA-PC-Intra` or the `Partner Cost Object` dimension if allocation method is `IAA-CO-Intra`) receive a share proportional to the factor in the key. `picklist`: The elements of the cross-charge dimension are filtered to all elements having `1` on `Service Relationships Picklist Filter` (string)
Service Relationships Picklist Filter	This measure is only valid if the `Service Relationships Filter Type` measure is `dimension`. Values are stored on the elements of the `Profit Center` (if allocation method is `IAA-PC-Intra`) or the `Cost Object` (if allocation method is `IAA-CO-Intra`) dimension Valid values are `0` or `1`. (numeric)

Measures in the Service Rate group

The measures in this group define the service rates. for the Internal Activity Allocation (IAA). The measures in this group are only valid if the allocation method is IAA-PC-Intra or IAA-CO-Intra.

Element	Definition
Service Rate PC Account	Account holding the service rate. The service rate must be stored on the base elements of the provider of the allocation dimension (`Profit Center` if allocation method is `IAA-PC-Intra` or `Cost Object` if allocation method is `IAA-CO-Intra`). The rate should be stored on the `~` (Not applicable) element of the partner allocation dimension (`Partner Profit Center` if allocation method is `IAA-PC-Intra` or `Partner Cost Object` if allocation method is `IAA-CO-Intra`) Valid values are elements of the `PC Account` dimension. (string)
Service Rate Currency	Filters the values on the `Currency` dimension. Valid values are element names of this dimension (e.g. `LC`). (string)

Measures in the Secondary Cost group
The measures in this group define the accounts in which to store the results of the allocation. This can be two separate accounts for the discharged and the charged amount or a single account used for both.

Element	Definition
Secondary Cost PC Account Discharge	Account to store the discharged amount. Valid values are base elements of the `PC Account` dimension. (string)
Secondary Cost PC Account Charge	Account to store the charged amount. Valid values are base elements of the `PC Account` dimension. (string)

Updated September 27, 2024