IsCalculated

Returns a Boolean that indicates whether a Custom dimension member’s data is calculated by Financial Management or is manually entered.

Syntax

<HsvCustom>.IsCalculated lItemID, pbIsCalculated

Argument

Description

lItemID

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

pbIsCalculated

Boolean. Returns TRUE if the Custom dimension member’s data is calculated, FALSE if it is manually entered.

Example

The following function indicates whether a given Custom dimension member is calculated. The second argument takes the ID of the Custom dimension; dimension IDs are represented by the HFMConstants type library constants listed in Dimension ID Constants.

Function isCustomMemCalculated(sMem As String, iDim As Integer) _
   As Boolean
Dim cTreeInfo As IHsvTreeInfo, cCustom As HsvCustom
Dim bIsCalc As Boolean
'g_cMetadata is an hsvmetadata object reference
Set cCustom = g_cMetadata.Dimension(iDim)
Set cTreeInfo = g_cMetadata.Dimension(iDim)
lCust = cTreeInfo.GetItemID(sMem)
cCustom.IsCalculated lCust, bIsCalc
If bIsCalc = True Then
    isCustomMemCalculated = True
Else
    isCustomMemCalculated = False
End If
End Function