ChartLogic

Calculates an entity’s data for the specified Scenario, Year, Period, and Value dimension members.

Syntax

<HsvCalculate>.ChartLogic lScenario, lYear, lPeriod, lEntity, lParent, lValue, varbForceChartLogic

Argument

Description

lScenario

Long (ByVal). The member ID of the Scenario dimension member.

lYear

Long (ByVal). The member ID of the Year dimension member.

lPeriod

Long (ByVal). The member ID of the Period dimension member.

lEntity

Long (ByVal). The member ID of the Entity dimension member for which the calculation is to be run.

lParent

Long (ByVal). The member ID of the parent entity of the lEntity argument’s entity.

lValue

Long (ByVal). The member ID of the Value dimension member.

varbForceChartLogic

Boolean (ByVal). Specifies whether the calculation should be forced if the entity does not require calculation. Specify TRUE to force the calculation, otherwise FALSE.

Example

This example runs a calculation for the dimension members passed to the user-defined GetMemberID function, which returns their member IDs. (For information on GetMemberID, see the example for GetItemID.) These member IDs are then passed to ChartLogic.

Dim lScen As Long, lYear As Long, lPer As Long
Dim lEnt As Long, lPar As Long, lVal As Long
Dim cCalculate As HsvCalculate
lScen = GetMemberID(DIMENSIONSCENARIO, "Actual")
lYear = GetMemberID(DIMENSIONYEAR, "2000")
lPer = GetMemberID(DIMENSIONPERIOD, "July")
lEnt = GetMemberID(DIMENSIONENTITY, "Connecticut")
lPar = GetMemberID(DIMENSIONENTITY, "UnitedStates")
lVal = GetMemberID(DIMENSIONVALUE, "USD")
Set cCalculate = m_cHsvSession.Calculate
cCalculate.ChartLogic lScen, lYear, lPer, lEnt, lPar, lVal, True