SignOff2

Signs off on a process unit and attaches documents.

Syntax

<HsvProcessFlow>.SignOff2 lScenario, lYear, lPeriod, lEntity, lParent, lValue, vbUseAllValueMembers, bstrAnnotation, varabstrPaths, varabstrFiles

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.

vbUseAllValueMembers

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

bstrAnnotation

String (ByVal). The comment for the signoff.

varabstrPaths

String array (ByVal). The paths in which the documents to be attached have been loaded. Folders in the path are delimited by backslashes ( \ ).

This array has a one-to-one correspondence with the varabstrFiles argument’s array of filenames.

varabstrFiles

String array (ByVal). The file names of the documents to attach.

Note:

Files must be loaded in the folder specified by the corresponding item in the varabstrPaths argument’s array, otherwise an error will be thrown.

Example

The following example signs off on a process unit and attaches documents. 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 Signoff2.

Dim lScen As Long, lYear As Long, lPer As Long
Dim lEnt As Long, lPar As Long, lVal As Long
Dim cProcessFlow As HsvProcessFlow, iState As Integer
Dim saPaths(1) As String, saNames(1) As String
lScen = GetMemberID(DIMENSIONSCENARIO, "Budget")
lYear = GetMemberID(DIMENSIONYEAR, "2005")
lPer = GetMemberID(DIMENSIONPERIOD, "October")
lEnt = GetMemberID(DIMENSIONENTITY, "Virginia")
lPar = GetMemberID(DIMENSIONENTITY, "UnitedStates")
lVal = GetMemberID(DIMENSIONVALUE, "USD")
saPaths(0) = "docs"
saPaths(1) = "docs"
saNames(0) = "Audit.txt"
saNames(1) = "Comments.txt"
'g_cSession is an HsvSession object reference
Set cProcessFlow = g_cSession.ProcessFlow
cProcessFlow.SignOff2 lScen, lYear, lPer, lEnt, lPar, lVal, _
  False, "see attached", saPaths, saNames