Data provider types: Essbase
HypGetParent() returns the name of the parent of the specified member.
HypGetParent(vtSheetName, vtMemberName, vtParentName)
ByVal vtSheetName As Variant
ByVal vtMemberName As Variant
ByRef vtParentName 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: Input parameter; the member name. Required.
vtParentName: Output parameter; the parent name
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypGetParent Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtMemberName As Variant, ByRef vtParentName As Variant) As Long Sub Example_HypGetParent Dim vtParent As Variant X = HypGetParent (Empty, "East", vtParent) End sub