Data provider types: Essbase
HypIsDescendant() checks if the specified member is the descendant of another specified member.
HypIsDescendant(vtSheetName, vtMemberName, vtAncestorName)
ByVal vtSheetName As Variant
ByVal vtMemberName As Variant
ByVal vtAncestorName As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtMemberName: The member for which to retrieve information. Required; there is no default value.
vtAncestorName: The name of the ancestor. Required.
Returns a variant in which -1 is true, 0 is false; otherwise, returns the appropriate error code.
Declare Function HypIsDescendant Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtMemberName As Variant, ByVal vtDescendantName As Variant) As Boolean Sub Example_HypIsDescendant Dim b as Boolean b = HypIsDescendant (Empty, "Year", "Jan") End sub