Returns the IDs of the submission group and submission phase to which a given cell is assigned.
<HsvProcessFlow>.GetGroupPhaseFromCell lScenario, lYear, lPeriod, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pbstrGroup, pbstrPhase| Argument | Description |
|---|---|
| lScenario | Long (ByVal). The member ID of the process unit's Scenario dimension member. |
| lYear | Long (ByVal). The member ID of the process unit's Year dimension member. |
| lPeriod | Long (ByVal). The member ID of the process unit's Period dimension member. |
| lEntity | Long (ByVal). The member ID of the process unit's child Entity dimension member. |
| lParent | Long (ByVal). The member ID of the process unit's parent Entity dimension member. |
| lValue | Long (ByVal). The member ID of the process unit's Value dimension member. |
| lAccount | Long (ByVal). The member ID of the cell’s Account dimension member. |
| lICP | Long (ByVal). The member ID of the cell’s Intercompany Partner dimension member. |
| lCustom1 | Long (ByVal). The member ID of the cell’s Custom1 dimension member. |
| lCustom2 | Long (ByVal). The member ID of the cell’s Custom2 dimension member. |
| lCustom3 | Long (ByVal). The member ID of the cell’s Custom3 dimension member. |
| lCustom4 | Long (ByVal). The member ID of the cell’s Custom4 dimension member. |
| pbstrGroup | String. Returns the ID of the cell's submission group. |
| pbstrPhase | String. Returns the phase ID of the cell's submission phase. |
The following function obtains the phase ID of the cell's submission phase, then starts the phase with PhasedSubmissionStart2.
Function StartPhasedWorkflow(lScen As Long, lYear As Long, lPer As Long, _
lEnt As Long, lPar As Long, lVal As Long, lAcct As Long, lIcp As _
Long, lC1 As Long, lC2 As Long, lC3 As Long, lC4 As Long, sNote As _
String) As Integer
Dim cProcessFlow As HsvProcessFlow, sGroup As String, sPhase As String
Dim vaPaths As Variant, vaNames As Variant, iState As Integer
'g_cSession represents an HsvSession instance
Set cProcessFlow = g_cSession.ProcessFlow
cProcessFlow.GetGroupPhaseFromCell lScen, lYear, lPer, lEnt, lPar, lVal, _
lAcct, lIcp, lC1, lC2, lC3, lC4, sGroup, sPhase
cProcessFlow.PhasedSubmissionStart2 lScen, lYear, lPer, lEnt, lPar, _
lVal, MEMBERNOTUSED, MEMBERNOTUSED, MEMBERNOTUSED, MEMBERNOTUSED, _
MEMBERNOTUSED, MEMBERNOTUSED, CLng(sPhase), True, False, sNote, _
vaPaths, vaNames, iState
StartPhasedWorkflow = iState
End Function