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