COPY

You can copy values from one area of a cube to another: for example, the actual figures for one year to the budget for another year. In this example, the actual figures are the source and the budget is the target.

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

Copy - allocation: #C[Tuple]:

A tuple is the address of a specific area of the database. In this case, the tuple is the address of the data which you want to copy. It is recommended that you use unique element names to specify the tuple.

Values that you copy from one area of a cube to another replace existing values.

Examples:

You want to copy the fourth quarter budget for 2008 to the actual results for the same quarter. Select the cell containing the actual figures for the quarter and specify:

#COPY [VERSION].[Budget];[TIME].[All Years].[2008].[Q4_2008]

You want to copy the External Direct Sales fourth quarter budget for 2008 to the Internal Direct Sales first quarter actuals for 2009.

Select the cell containing the Internal Direct Sales 2009 first quarter actual figures and specify:

#COPY [VERSION].[Budget];[INTERCO].[E_Direct];[TIME].[All Years].[2008].[Q4_2008]]