DATAMERGE

The DATAMERGE calculation command for Essbase merges a range of data cells from the current scenario to a baseline target, or to another scenario. This command is useful when, after working on a scenario, you decide to commit the changes.

Syntax

DATAMERGE sourceMbrName targetMbrName [NOCALC] [SBSOURCE|SBTARGET];

Parameters

sourceMbrName

A single sandbox member name or member combination.

targetMbrName

A single sandbox member name.

NOCALC

Keyword indicating that only cells with cell status of INPUT or LOAD should be merged.

SBSOURCE or SBTARGET

Keyword indicating a merge preference:

• SBSOURCE—The default. If merge source and merge target have different values, apply the source value to the target.
• SBTARGET—If merge source and merge target have different values, apply the target value to the source.

Notes

• Use of this command presumes you have created and provisioned a cube for scenario modeling.
• The merge process iterates over all non-missing cells in the source, and checks whether the cell should be copied into the target. The decision depends on the value of the optional SOURCE | TARGET keyword (SOURCE is default). If a cell needs to be merged, Essbase copies the cell's value, transaction ID, and status from the source to the target, and updates the cell status to MERGED.

Example

Fix(@Relative(Colas,0))
DATAMERGE sb1->2016 sb2 NOCALC SBTARGET;
EndFix