Allocation Configuration Cube
Return to Profit Center Model Overview.
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 totalElement
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 toEqual-PC-Intra
,Equal-CO-Intra
,Alloc-PC-Intra
orAlloc-CO-Intra
.Element
Definition
Primary Cost Partner Entity Operator
Defines the nature of the
Primary Cost Partner Entity
filter. Valid values areequal
: The filter denotes an element name of the dimension.like
: The filter is a regular expression pattern to match elements of the dimensioninrange
: 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 thePrimary 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 thePrimary Cost Partner Entity Operator
measure. (string)Primary Cost Profit Center
Filters the values on the Profit Center
dimension. The valid values depend on thePrimary 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 thePrimary 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 thePrimary 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 thePrimary 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 thePrimary 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 thePrimary 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 thePrimary 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 ofEqual-PC-Intra
,Equal-CO-Intra
,Alloc-PC-Intra
orAlloc-CO-Intra
.Element
Definition
Allocation Key PC Account This measure is only valid if the allocation method is Alloc-PC-Intra
orAlloc-CO-Intra
. Filters the values on thePC 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
orAlloc-CO-Intra
. Filters the values on theCurrency
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 isEqual-PC-Intra
orAlloc-PC-Intra
or theCost Object
dimension if allocation method isEqual-CO-Intra
orAlloc-CO-Intra
). Valid values arenone
: No additional filter is applied to the allocation dimension. If the allocation method isEqual-PC-Intra
orEqual-CO-Intra
all base elements of the dimensions receive an equal share. If the allocation method isAlloc-PC-Intra
orAlloc-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 byAllocation Key Dimension Filter Operator
andAllocation Key Dimension Filter
.picklist
: The elements of the allocation dimension are filtered to all elements having1
onAllocation Key Picklist Filter
(string)Allocation Key Dimension Filter Operator This measure is only valid if the Allocation Key Filter Type
measure is set todimension
. Defines the nature of theAllocation Key Dimension Filter
. Valid values are the same as described above for thePrimary Cost Partner Entity Operator
measure. (string)Allocation Key Dimension Filter This measure is only valid if the Allocation Key Filter Type
measure is set todimension
. Filters the values on the allocation dimension (theProfit Center
or theCost Object
dimension). The valid values depend on theAllocation Key Dimension Filter Operator
measure. (string).Allocation Key Picklist Filter This measure is only valid if the Allocation Key Filter Type
measure is set todimension
. Values are stored in the elements of theProfit Center
(if allocation method isEqual-PC-Intra
orAlloc-PC-Intra
) or theCost Object
(if allocation method isEqual-CO-Intra
orAlloc-CO-Intra
) dimension. Valid values are0
or1
. (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 isIAA-PC-Intra
orIAA-CO-Intra
. When the allocation method isIAA-PC-Intra
the provider is theProfit Center
and the consumer is thePartner Profict Center
dimension. When the allocation method isIAA-CO-Intra
the provider is theCost Object
and the consumer is thePartner 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 thePrimary Cost Partner Entity Operator
measure. (string)Service Relationships Partner Entity Filters the values on the Partner Entity
dimension. The valid values depend on theService 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 thePrimary Cost Partner Entity Operator
measure. (string)Service Relationships Profit Center Filters the values on the Profit Center
dimension. The valid values depend on theService 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 thePrimary 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 theService 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 thePrimary Cost Cost Object Operator
measure. (string)Service Relationships Cost Object Filters the values on the Cost Object
dimension. The valid values depend on theService 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 thePrimary 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 theService 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 isIAA-PC-Intra
or theCost Object
dimension if allocation method isIAA-CO-Intra
). Valid values arenone
: No additional filter is applied to the allocation dimension. All base elements having a service relationship in the cross-charge partner dimension (thePartner Profict Center
dimension if allocation method isIAA-PC-Intra
or thePartner Cost Object
dimension if allocation method isIAA-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 having1
onService Relationships Picklist Filter
(string)Service Relationships Picklist Filter This measure is only valid if the Service Relationships Filter Type
measure isdimension
. Values are stored on the elements of theProfit Center
(if allocation method isIAA-PC-Intra
) or theCost Object
(if allocation method isIAA-CO-Intra
) dimension Valid values are0
or1
. (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 isIAA-PC-Intra
orIAA-CO-Intra
.
Measures in the Secondary Cost groupElement
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 isIAA-PC-Intra
orCost Object
if allocation method isIAA-CO-Intra
). The rate should be stored on the~
(Not applicable) element of the partner allocation dimension (Partner Profit Center
if allocation method isIAA-PC-Intra
orPartner Cost Object
if allocation method isIAA-CO-Intra
) Valid values are elements of thePC 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)
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 November 4, 2024