DATACOPY

The DATACOPY calculation command copies a range of data cells to another range within the Essbase database.

This command is useful when you must maintain an original set of data values and perform changes on the copied data set.

DATACOPY is commonly used as part of the currency conversion process.

DATACOPY is useful when you need to define multiple iterations of plan data.

To reduce typing, if any dimension(s) represented by the members in mbrName1 are not represented in mbrName2, then by default the same member or members from mbrName1 are assumed to exist in mbrName2 to complete the range. The reverse is not true. Any dimension explicitly represented in mbrName2 MUST be represented by another member of the same dimension in mbrName1.

The ranges specified by both mbrName1 and mbrName2 must be of the same size. The same dimensions represented by the members that make up mbrName1 must also be present in mbrName2.

Syntax

DATACOPY mbrName1 TO mbrName2;

Parameters

mbrName1 and mbrName2: Any valid single member name or member combination.

Notes

The size of the copied dimensions must be equal to the destination (TO) size.
DATACOPY follows the rules for any defined FIX command.
To prevent creation of #MISSING blocks, add the following calculation command to your script:
```
SET COPYMISSINGBLOCK OFF;
```
To use this command with parallel calculation, use FIXPARALLEL...ENDFIXPARALLEL instead of SET CALCPARALLEL.

Example

DATACOPY Plan TO Revised_Plan;