HypIsChild

Data source types: Essbase

HypIsChild() checks whether the specified child 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: For future use. Currently the active sheet is used.

vtParentName: The member name of the parent. Required.

vtChildName: The member 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 ParentName As Variant) As Variant

Sub Sample_HypIsChild
   Dim b as Boolean
   b = HypIsChild ("Sheet1", "Year", "Qtr1")
End Sub