Equal leaves data spreading method

The Equal leaves spreading method distributes a specified value equally across all leaves of a consolidated cell. When you apply this method, you can choose to distribute the value to all leaves of the consolidation or only to those leaves that already contain non-zero values.

In this example, there are several leaves of Year, Argentina with zero values.

If you use the equal leaves method to distribute the value 1200 to all the leaves of Year, Argentina, the result is as follows.

If you initiate the Equal leaves spreading method from a cell identified by more than one consolidated member, the value is distributed to all leaves associated with the cell. For example, say the selected cell is identified by two consolidated members: Year and S Series Sedan.

If you initiate Equal leaves spreading from the highlighted cell, the specified value is distributed to all cells identified by the leaves of Year and the leaves of S Series Sedan. For instance, if you use Equal leaves spreading to distribute the value 1200 to all leaves of the highlighted cell, the result is as follows.

When you initiate Equal leaves spreading from a cell identified by multiple consolidated members, the RAM requirements of the cube can increase significantly. Where more than 10,000 cells are affected by the Equal leaves method, a warning is displayed. In circumstances where more than one million cells are affected, the spreading operation does not execute.

LS*1200