Translate

Translates an entity’s data from one currency to another for the specified Scenario, Year, Period, and Value dimension members.

Note:

Translate uses the default exchange rates defined for an application. If an application has a translation rule, Translate executes the rule instead of applying the default exchange rates.

Syntax

<HFMwCalculate>.Translate bstrScenario, bstrYear, bstrStartPeriod, bstrEndPeriod, bstrEntity, bstrParent, bstrValue, varbForceTranslate

Argument

Description

bstrScenario

The label of the Scenario dimension member.

Input argument. String subtype.

bstrYear

The label of the Year dimension member.

Input argument. String subtype.

bstrStartPeriod

The label of the first Period dimension member in the range of periods for which the translation is being executed.

Input argument. String subtype.

bstrEndPeriod

The label of the last Period dimension member in the range of periods for which the translation is being executed.

Input argument. String subtype.

bstrEntity

The label of the child Entity dimension member.

Input argument. String subtype.

bstrParent

The label of the bstrEntity argument’s parent.

Input argument. String subtype.

bstrValue

The label of the Value dimension member.

Input argument. String subtype.

varbForceTranslate

Determines whether the translation will be forced. Specify TRUE to force the translation, FALSE otherwise.

Input argument. Boolean subtype.