External weighted delta

This allocation mode is similar to External weighted but the target area is also taken into account.

The difference between the current value in the target cell and the sent value is distributed to the base cells according to the values in the source area. That is, the target cell contains the sent value after the operation which is different from Mixed delta.

Example

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Cube" Method="Splashing">
    <Alea:Splashing AllocationMode="External weighted delta" Rounding="true" DecimalPlaces="2" ErrorCorrection="true" Undo="false" DoNotDeleteOnZero="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="Car Tires Winter" />
        <Alea:Element Dimension="PROFIT" Name="Sales Volume" />
      </Alea:CellCoordinates>
      <Alea:CellCoordinates Purpose="Source" Cube="SALES">
        <Alea:Element Dimension="TIME" Name="Q2_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="Car Tires Winter" />
        <Alea:Element Dimension="PROFIT" Name="Sales Volume" />
      </Alea:CellCoordinates>
      <Alea:Value>6000.00</Alea:Value>
    </Alea:Splashing>
  </Alea:Request>
</Alea:Document>

This table lists the elements on the slicer axis used for the example:

Dimension Element name Element caption (if different)
VERSION Budget
INTERCO EI_4001 Distributor 1
UNIT C1101 GENESIS Germany GmbH
PROFIT Sales Volume
CURRTYPE LC Local Currency
LEVEL IFRS

The next two tables show the original state and the results. The element names may be different than the listed element captions. Both states have the same elements on the slicer axis.

This table shows the original state:

2017 Quarter 2 Apr 2017 May 2017 Jun 2017 2017 Quarter 3 Jul 2017 Aug 2017 Sep 2017
Winter Tires 4,829 3,921 908 5,357 600 4,757
W6000 Ultragrip 908 908 367 29 338
W7000 Icetrack 3,921 3,921 503 50 453
W8000 Blizzard 4,486 521 3,966

This table shows the results:

2017 Quarter 2 Apr 2017 May 2017 Jun 2017 2017 Quarter 3 Jul 2017 Aug 2017 Sep 2017
Winter Tires 4,829 3,921 908 6,000 600 5,279 121
W6000 Ultragrip 908 908 488 29 338 121
W7000 Icetrack 3,921 3,921 1,025 50 976
W8000 Blizzard 4,486 521 3,966