Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypGetActiveMember () returns the active member name of 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.
HypGetActiveMember (vtDimName, vtMember)
ByVal vtDimName As Variant
ByRef vtMember As Variant
vtDimName: Input variable; the dimension name whose active member is to be retrieved
vtMember: Output variable; the active member name returned
Returns 0 if successful; otherwise, returns the appropriate error code.
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 Example_GetActiveMember() sts = HypGetActiveMember("Market", vtMem) End Sub