GetItemLevel

Returns the level of a given member in the dimension hierarchy.

Note:

Levels are ordered incrementally from the leaf members (level 0) up to the root of the dimension hierarchy.

Syntax

<IHsvTreeInfo>.GetItemLevel lMemberID, plLevel

Argument	Description
lMemberID	Long (ByVal). The member ID of the dimension member.
plLevel	Long. Returns the number that represents the member’s level within the dimension hierarchy.

Example

The following function indicates whether a given Period dimension member is a leaf member.

Function isPeriodLeaf(sMemberName As String) As Boolean
Dim cTreeInfo As IHsvTreeInfo, lMemID As Long, lLevel As Long
'm_cMetadata is an HsvMetadata object reference
Set cTreeInfo = m_cMetadata.Periods
lMemID = cTreeInfo.GetItemID(sMemberName)
cTreeInfo.GetItemLevel lMemID, lLevel
If lLevel = 0 Then
    isPeriodLeaf = True
Else
    isPeriodLeaf = False
End If
End Function