Submit

Submits a process unit.

To attach documents when submitting, use Submit2.

Syntax

<HsvProcessFlow>.Submit lScenario, lYear, lPeriod, lEntity, lParent, lValue, vbUseAllValueMembers, bstrAnnotation, psNewProcessState

Argument

Description

lScenario

The member ID of the process unit's Scenario dimension member.

lYear

The member ID of the process unit's Year dimension member.

lPeriod

The member ID of the process unit's Period dimension member.

lEntity

The member ID of the process unit's child Entity dimension member.

lParent

The member ID of the process unit's parent Entity dimension member.

lValue

The member ID of the process unit's Value dimension member.

vbUseAllValueMembers

Boolean (ByVal). Determines whether process units for Value dimension members related to the lValue member are submitted. Pass TRUE to submit related process units, FALSE to submit only the process unit for the lValue member.

bstrAnnotation

The comment for the submission.

psNewProcessState

Integer. Returns PROCESS_FLOW_STATE_SUBMITTED, which is the level constant for the Submitted level.

This example submits a process unit. The calls to the user-defined GetMemberID function get the process unit’s member IDs; for information on GetMemberID, see the Examples for GetItemID. These member IDs are then passed to Submit.

Dim lScen As Long, lYear As Long, lPer As Long
Dim lEnt As Long, lPar As Long, lVal As Long
Dim cHsvProcessFlow As HsvProcessFlow, iState As Integer
lScen = GetMemberID(DIMENSIONSCENARIO, "Budget")
lYear = GetMemberID(DIMENSIONYEAR, "2000")
lPer = GetMemberID(DIMENSIONPERIOD, "October")
lEnt = GetMemberID(DIMENSIONENTITY, "Connecticut")
lPar = GetMemberID(DIMENSIONENTITY, "UnitedStates")
lVal = GetMemberID(DIMENSIONVALUE, "USD")
'g_cSession is an HsvSession object reference
Set cHsvProcessFlow = g_cSession.ProcessFlow
cHsvProcessFlow.Submit lScen, lYear, lPer, lEnt, lPar, lVal, _ 
  False, "", iState