HypGetActiveMember

Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise

Description

HypGetActiveMember () returns the active member name for the given dimension. The active member for page dimensions, POV dimensions, and user variables can be retrieved on ad hoc or form worksheets. Row and column dimensions are not returned.

Syntax

HypGetActiveMember (vtDimName, vtMember)

ByVal vtDimName As Variant

ByRef vtMember As Variant

Parameters

vtDimName: Input variable; the dimension name whose active member must be retrieved.

vtMember: Output variable; the active member name returned.

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.

Example

This example assumes that the worksheet is connected and has a grid.

Public Declare Function HypGetActiveMember Lib "HsAddin" (ByVal vtDimName As Variant, ByRef vtMember As Variant) As Long
Sub GetActiveMemberName()
sts =  HypGetActiveMember("Market", vtMem)
End Sub