HypIsChild
Describes the Oracle Smart View for Office VBA function, HypIsChild.
Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypIsChild() determines whether a member is the child of a specified parent member. HypIsChild checks only for children, not for all descendants.
Syntax
HypIsChild(vtSheetName, vtParentName, vtChildName)
ByVal vtSheetName As Variant
ByVal vtParentName As Variant
ByVal vtChildName 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.
vtParentName: The name of the parent. Required
vtChildName: The name of the child. Required
Return Value
Returns a variant in which -1 is true, 0 is false; otherwise, returns the appropriate error code.
Example
Declare Function HypIsChild Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtParentName As Variant, ByVal vtChildName As Variant) As Variant
Sub Example_HypIsChild
Dim b as Boolean
b = HypIsChild ("Sheet1", "Year", "Qtr1")
End Sub