GetPhaseSubmissionGridForGivenScenarioPeriod

Returns an array representing the submission groups assigned to the specified combinations of Scenario dimension member, Period dimension members, and submission phases. The input Period member IDs and phase IDs, and the returned submission group IDs, are in arrays that have a one-to-one correspondence.

Syntax

<HsvData>.GetPhaseSubmissionGridForGivenScenarioPeriod lScenario, varalPeriodIDs, varalPhaseIDs, pvarbstrGroupInfo

Argument	Description
lScenario	Long (ByVal). The member ID of the Scenario dimension member.
varalPeriodIDs	Long array (ByVal). The member IDs of the Period dimension members.
varalPhaseIDs	Long array (ByVal). The phase IDs of the submission phases.
pvarbstrGroupInfo	Variant array. Returns the IDs of the submission groups. If no submission group is assigned to a period-submission group combination, the corresponding array item returns an empty string Note: If all submission groups are assigned to a period-submission group combination, the asterisk ( * ) character is returned instead of an ID. The array's subtype is String.

Example

The following function returns the ID of the submission group assigned to a submission phase for a given scenario and period.

Function GetGroupForPhase(lScen As Long, lPer As Long, lPhase As Long) _
   As String
Dim cData As HsvData, laPers(0) As Long, laPhaseId(0) As Long, vaGroup
Set cData = g_cSession.Data
laPers(0) = lPer
laPhaseId(0) = lPhase
cData.GetPhaseSubmissionGridForGivenScenarioPeriod lScen, laPers, _
   laPhaseId, vaGroup
GetGroupForPhase = vaGroup(0)
End Function