HypGetParent
Describes the Oracle Smart View for Office VBA function, HypGetParent.
Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypGetParent() returns the name of the parent of the specified member.
Syntax
HypGetParent(vtSheetName, vtMemberName, vtParentName)
ByVal vtSheetName As Variant
ByVal vtMemberName As Variant
ByRef vtParentName 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: Input parameter; the member name. Required.
vtParentName: Output parameter; the parent name
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
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