Relative proportional data spreading method

Use the Relative Proportional Spread method to spread values to the leaves of a consolidation cell proportional to the leaves of a reference cell.

The following example demonstrates relative proportional spreading where both the initial cell and the reference cell are in the same cube.

View showing a consolidated value of 100 in the cell identified by 1 Quarter, Brazil.

The reference cell can be located in the cube from which you initiate spreading or in a separate cube. However, the reference cell must share the same consolidations as the cell from which you initiate spreading.

The previous view shows a single consolidated value of 100 in the cell identified by 1 Quarter, Brazil. By looking at the leaves of 1 Quarter, you can see that:

  • Jan contains the value 10, which is 10% of 100
  • Feb contains the value 20, which is 20% of 100
  • Mar contains the value 70, which is 70% of 100

If you initiate relative proportional spreading from 1 Quarter, Argentina and specify a Data Action of Replace when spreading the value 400, the leaves of 1 Quarter, Argentina are populated as proportional to the leaves of 1 Quarter, Brazil:

View showing relative proportional spreading.
  • Jan contains the value 40, which is 10% of 400
  • Feb contains the value 80, which is 20% of 400
  • Mar contains the value 280, which is 70% of 400