Use the DATACOPY command to create a block for each existing block, and then perform calculations on the new blocks. For example:
DATACOPY Sales -> Actual TO Sales -> Budget; DATACOPY Expenses -> Actual TO Expenses -> Budget; FIX(Budget) (Sales = Sales -> Actual * 1.1; Expenses = Expenses -> Actual * .95;) ENDFIX
Essbase creates blocks that contain the Budget values for each corresponding Actual block that exists. After the DATACOPY commands are finished, the remaining part of the script changes the values.
Using DATACOPY works well in these situations:
There is a mathematical relationship between values in existing blocks and their counterparts created by the DATACOPY.
For example, in the preceding example, the Budget values can be calculated based on the existing Actual values.
None of the blocks that are copied contain only #MISSING values.
If #MISSING values exist, blocks are written that contain only #MISSING values. Unneeded #MISSING blocks require Essbase resource and processing time.