Reconcile Copy
Use this command to copy non-zero data in the Data Server repository from one symbol to another, and to specify that the copy reconciles the target symbol to the source symbol.
Use this command to directly manipulate data in the Data Server repository, based on an intersection of data specified. Reconcile Copy does not overwrite existing non-zero data in the target area unless there is non-zero data in the source area for that data. When copying data from a parent symbol to a child symbol, the data is copied even if the parent symbol is a virtual parent.
If a user has any symbol access that is read-only in the area defined by the lock to which the command pertains, the command is allowed to continue and all read-only symbols are ignored (not copied). If you try to copy to an area that is read-only, an error message appears.
Reconcile Copy differs from the Copy Data command in that it performs the following actions:
| Action | Description |
|---|---|
If the data does not exist in database... |
it submits the data |
If the data does exist in the database, and the value is the same... |
no submission occurs |
If the data does exist in the database, and the value is not the same... |
it submits the new value |
If the database has a data intersection not referenced in the file... |
it submits a zero |
Syntax
RECONCILE COPY FROM DimName SourceSymName TO TargetSymName [DataType] USING dataspec.lvdsp
where:
- DimName is a dimension containing the symbols.
- SourceSymName is a symbol whose data you want to copy.
- TargetSymName is a symbol that will contain the copied data.
- DataType can be one of the following:
Value Description PARENT
To copy data from (UP + AP) to UL table. The PARENT option does not copy the rollup value of a carryforward parent.
If SourceSymName is a virtual parent, the value of the source symbol is recalculated before copying it.
LEAF
To copy data from UL to UL table.
CALCLEAF
To copy data from (UC + UL + AC + AL) to UL table.
CTA
To copy data from (UT, AT) to (UT, AT) table.
ADJUSTEDLEAF
To copy data from (UL + UA) to UL table.
dataspec.lvdsp is the name of a DataSpec file.
The following table explains the abbreviations in the DataType parameters:
| Parameter | Description |
|---|---|
U |
unadjusted |
A |
adjusted |
C |
calculated |
L |
leaf |
P |
parent |
T |
CTA |
+ |
add value for the identical coordinate |
, |
the corresponding table (for example, unadjusted to unadjusted) |
Syntax example
CREATE LOCK USER USING CopyNI.lvdsp "Copy plan income" RECONCILE COPY FROM TIMEPER A0312 TO P0401 CALCLEAF USING CopyNI.lvdsp DELETE LOCK USER USING CopyNI MATCH