HypGetParent

Data source types: Essbase

Description

HypGetParent() returns the parent name for the specified member.

Syntax

HypGetParent(vtSheetName, vtMemberName, vtParentName)

ByVal vtSheetName As Variant

ByVal vtMemberName As Variant

ByRef vtParentName As Variant

Parameters

vtSheetName: For future use. Currently the active sheet is used.

vtMemberName: Specify a member name. Required Field.

vtParentName: Output. Contains the parent name on successful execution of the macro.

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 Sample_HypGetParent
   Dim vtParent as Variant
   X = HypGetParent (Empty, "East", vtParent)
End sub