LIKE

You can splash values to the children of a consolidated cell in the same proportions as the values of the children of another consolidated cell.

You write the Like command in the target cell. In the command you specify only the dimensions and elements that distinguish the source area of the database from the target area. If the elements belong unambiguously to a specific dimension you need only specify the elements.

In writeback commands, L indicates Like.

LIKE - allocation: #L[value][Tuple]:

A tuple is the address of a specific area of the database. In this case, the tuple is the address of the source area of the database.

Example:

The fourth quarter sales figures for Spain in 2005 are 60. The figures for the individual months are October 10, November 20, and December 30.

To see what effect sales of 600 would have in the first quarter of 2006 in Italy (if distributed in the same proportions as the fourth quarter 2005 sales in Spain), select the cell containing the first quarter sales for Italy and enter this code:

#L 600 [REGION].[All Regions].[Europe].[Spain];[TIME].[All Years].[2005].[2005_Q4]

The first quarter sales for Italy become 600. The figures for the individual months become January 100, February 200, and March 300.