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
[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.