Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
HypSetActiveMember() sets the active member for a given dimension: page, POV, and user variables. Does not apply to row and column dimensions.
HypSetActiveMember (vtDimName, vtMember)
ByVal vtDimName As Variant
ByVal vtMember As Variant
vtDimName: Input variable; the dimension name whose active member is to be changed or set
vtMember: Input variable; the active member to be set
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 HypSetActiveMember Lib "HsAddin" (ByVal vtDimName As Variant, ByVal vtMember As Variant) As Long Sub Example_HypSetActiveMember() sts = HypSetActiveMember("Market", "Washington") End Sub