CopyData

Copies data from one set of cells to another. All cells that intersect the specified source dimension members are copied to the cells that intersect the specified target members.

Syntax

<HFMwData>.CopyData bstrSourceScenario, bstrDestScenario, bstrSourceYear, bstrDestYear, bstrSourcePeriods, bstrDestPeriods, bstrView, bstrEntities, bstrAccounts, vbClearInputValueID, vbClearNoneValueID, vbCopyDerived, vbCopyCellText, vbEnableDetailedLogging, dFactor, lEnumUpdateMode, bstrLogFileName

Argument

Description

bstrSourceScenario

The label of the source Scenario dimension member.

Input argument. String subtype.

bstrDestScenario

The label of the destination Scenario dimension member.

Input argument. String subtype.

bstrSourceYear

The label of the source Year dimension member.

Input argument. String subtype.

bstrDestYear

The label of the destination Year dimension member.

Input argument. String subtype.

bstrSourcePeriods

The label of the source Period dimension member.

Input argument. String subtype.

bstrDestPeriods

The label of the destination Period dimension member.

Input argument. String subtype.

bstrView

The label of the source and destination View dimension member.

Input argument. String subtype.

bstrEntities

The label of the source and destination Entity dimension member.

Input argument. String subtype.

bstrAccounts

The label of the source and destination Account dimension member.

Input argument. String subtype.

vbClearInputValueID

Specifies whether cells for the <Entity Currency> Value dimension member are to be included in the source and target cells. Pass TRUE to include these cells, FALSE otherwise.

Input argument. Boolean subtype.

vbClearNoneValueID

Specifies whether cells for the [None] Value dimension member are to be included in the source and target cells. Pass TRUE to include these cells, FALSE otherwise.

Input argument. Boolean subtype.

vbCopyDerived

Specifies whether derived source data is to be copied to the destination cells as stored input. Pass TRUE to copy derived source data, FALSE otherwise.

Input argument. Boolean subtype.

vbCopyCellText

Specifies whether the source cells’ cell text descriptions are to be copied to the target cells. Pass TRUE to include the cell text descriptions, FALSE otherwise.

Input argument. Boolean subtype.

vbEnableDetailedLogging

Specifies whether to include details in the log file. Pass TRUE to include details, FALSE otherwise.

Input argument. Boolean subtype.

dFactor

The factor by which the copied data is to be multiplied before it is placed in the target cells. To copy the data without changing it, pass 1.

Input argument. Double subtype.

lEnumUpdateMode

A flag that specifies the update mode. Pass one of the following values:

  • 0 = Replace mode: existing data in all specified cells is cleared, then the data is copied. However, if the connected user does not have full access rights to all specified cells, none of the data is copied.

  • 1 = Merge mode: if a cell contains data, and the corresponding cell to be copied also contains data, the existing data is replaced. However, if a cell to be copied does not contain data, then the existing data is preserved.

  • 2 = Accumulate mode: if a cell contains data, the data in the cell to be copied is added to the existing data.

  • 3 = Replace with Security mode: existing data is cleared in all specified cells to which the user has full access rights, then the data is copied. Cells to which the user lacks full access are ignored.

Input argument. Long subtype.

bstrLogFileName

The name of the log file.

Input argument. String subtype.