Allocation Configuration Cube

image_pdfimage_print

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: 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)
image_pdfimage_print