HypIsDescendant
Describes the Oracle Smart View for Office VBA function, HypIsDescendant.
Data provider types: Oracle Essbase
Description
HypIsDescendant() checks if the specified member is the descendant of another specified member.
Syntax
HypIsDescendant(vtSheetName, vtMemberName, vtAncestorName)
ByVal vtSheetName As Variant
ByVal vtMemberName As Variant
ByVal vtAncestorName As Variant
Parameters
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.
Return Value
Returns a variant in which -1 is true, 0 is false; otherwise, returns the appropriate error code.
Example
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