Data provider types: Essbase
HypIsAncestor() checks whether the specified member is the ancestor of another specified member.
HypIsAncestor(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 HypIsAncestor Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtMemberName As Variant, ByVal vtAncestorName As Variant) As Variant Sub Example_HypIsAncestor Dim b as Variant b = HypIsAncestor (Empty, "Year", "Jan") End sub