Mixed/Mixed delta

In a standard weighted allocation, the distribution is taken from the target area. In an external weighted allocation, the distribution is taken from a source area.

The mixed allocation mode mixes the distributions provided by those two areas. In addition, it allows an additional source area (driver) to determine the final distribution of values. Neither source can be empty.

Each dimension can be defined as a contributing dimension in one of the sources. The distribution along a contributing dimension is according to the source area. The distribution along a non-contributing dimension is either according to the target area, or it's equal distribution if the target area is empty.

The mixed allocation mode can also be used in delta mode. Here the current values in the target area are not replaced by the distribution of the new target value. Instead, the existing distribution and values are added. That is, the target cell contains the sum of the former value and the sent value after the operation. This is different from External weighted delta.

These limitations apply:

  • No rounding, no error correction, no undo, and no usage of the DoNotDeleteOnZero option.
  • Cube in sources must be the same as in target.
  • For contributing dimensions: No similar splashing such as from one consolidated element in a source to a different one in the target even with a similar structure. For example, Q1 to Q2 is not possible, even though they both contain three children.

Example

Contributing dimensions in the sources are defined by adding the Distribute="true" attribute. Contributing dimensions in the target are determined automatically, including equal distribution on empty targets. Distribute is allowed only once for a dimension, either the first or second source.

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="73" Class="Cube" Method="Splashing">
    <Alea:Splashing AllocationMode="Mixed delta" Rounding="false" ErrorCorrection="false" Undo="false">
      <Alea:CellCoordinates Purpose="Target" Cube="SALES">
        <Alea:Element Dimension="TIME" Name="Q3_2017" />
        <Alea:Element Dimension="VERSION" Name="Budget" />
        <Alea:Element Dimension="CURRTYPE" Name="LC" />
        <Alea:Element Dimension="LEVEL" Name="IFRS" />
        <Alea:Element Dimension="UNIT" Name="C1101" />
        <Alea:Element Dimension="INTERCO" Name="EI_4001" />
        <Alea:Element Dimension="PRODUCT" Name="W7000 Icetrack" Hierarchy="PRODUCT" />
        <Alea:Element Dimension="PROFIT" Name="Sales Volume" />
      </Alea:CellCoordinates>
      <Alea:CellCoordinates Purpose="Source" Cube="SALES">
        <Alea:Element Dimension="TIME" Name="Q3_2017" Distribute="true"  />
        <Alea:Element Dimension="VERSION" Name="Budget" />
        <Alea:Element Dimension="CURRTYPE" Name="LC" />
        <Alea:Element Dimension="LEVEL" Name="IFRS" />
        <Alea:Element Dimension="UNIT" Name="C1101" />
        <Alea:Element Dimension="INTERCO" Name="EI_4002"/>
        <Alea:Element Dimension="PRODUCT" Name="W7000 Icetrack" Hierarchy="PRODUCT" />
        <Alea:Element Dimension="PROFIT" Name="Sales Volume" />
      </Alea:CellCoordinates>
      <Alea:CellCoordinates Purpose="Source" Cube="SALES">
        <Alea:Element Dimension="TIME" Name="07_2016" />
        <Alea:Element Dimension="VERSION" Name="Actual" />
        <Alea:Element Dimension="CURRTYPE" Name="LC" />
        <Alea:Element Dimension="LEVEL" Name="IFRS" />
        <Alea:Element Dimension="UNIT" Name="C1101" />
        <Alea:Element Dimension="INTERCO" Name="EI_4001" />
        <Alea:Element Dimension="PRODUCT" Name="W7000 Icetrack" Hierarchy="PRODUCT" Distribute="true" />
        <Alea:Element Dimension="PROFIT" Name="Sales Volume" />
      </Alea:CellCoordinates>
      <Alea:Value>50</Alea:Value>
    </Alea:Splashing>
  </Alea:Request>
</Alea:Document>

These elements are in the slicer axis for the areas:

  • [VERSION].[Budget]
  • [UNIT].[C1101] (caption: GENESIS Germany GmbH)
  • [PROFIT].[Sales Volume]
  • [CURRTYPE].[Local Currency] (caption: LC)
  • [LEVEL].[IFRS]

All values are displayed with only one decimal.

This table shows the source area:

2017 Quarter 3 Jul 2017 Aug 2017 Sep 2017
[INTERCO].[EI_4002] W7000 Icetrack 4,118.9 50.5 486.3 3,582.1
[INTERCO].[EI_4002] W7000/195 3,743.7 14.9 146.6 3,582.1
[INTERCO].[EI_4002] W7000/205 196.6 18.0 178.6
[INTERCO].[EI_4002] W7000/225 178.7 17.5 161.1

This table shows the driver area (here [VERSION].[Actual] is in the slicer axis instead of [VERSION].[Budget]):

Jul 2016
[INTERCO].[EI_4001] W7000 Icetrack 53.1
[INTERCO].[EI_4001] W7000/195 19.4
[INTERCO].[EI_4001] W7000/205 17.4
[INTERCO].[EI_4001] W7000/225 16.4

This table shows the target area before the operation:

2017 Quarter 3 Jul 2017 Aug 2017 Sep 2017
[INTERCO].[EI_4001] W7000 Icetrack 503.0 49.7 453.2
[INTERCO].[EI_4001] W7000/195 158.5 14.2 144.3
[INTERCO].[EI_4001] W7000/205 160.3 20.2 140.1
[INTERCO].[EI_4001] W7000/225 184.2 15.4 168.8

This table shows the target area after the operation:

Jul 2017 Aug 2017 Sep 2017
[INTERCO].[EI_4001] W7000 Icetrack 553.0 50.4 459.1 43.5
[INTERCO].[EI_4001] W7000/195 176.7 14.4 146.4 15.8
[INTERCO].[EI_4001] W7000/205 176.7 20.4 142.1 14.2
[INTERCO].[EI_4001] W7000/225 199.6 15.5 170.7 13.4

If you completely omit the driver area in the request, using the same original state, the target area would look like this after the operation:

2017 Quarter 3 Jul 2017 Aug 2017 Sep 2017
[INTERCO].[EI_4001] W7000 Icetrack 553.0 50.4 459.1 43.5
[INTERCO].[EI_4001] W7000/195 174.2 14.4 146.1 13.7
[INTERCO].[EI_4001] W7000/205 176.3 20.4 142.0 13.9
[INTERCO].[EI_4001] W7000/225 202.5 15.6 171.0 15.9

You see that values in the row of W7000 Icetrack are the same as when the driver area was used. That is because the addition of the driver area only has effect on the final distribution along the contributing PRODUCT dimension. The source area determines the distribution along the contributing TIME dimension. And the source area is the same in both requests.