HypSetActiveMember
Describes the Oracle Smart View for Office VBA function, HypSetActiveMember.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypSetActiveMember() sets the active member for a given dimension: page, POV, and user variables. Does not apply to row and column dimensions.
Syntax
HypSetActiveMember (vtDimName, vtMember)
ByVal vtDimName As Variant
ByVal vtMember As Variant
Parameters
vtDimName: Input variable; the dimension name whose active member is to be changed or set
vtMember: Input variable; the active member to be set
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 HypSetActiveMember Lib "HsAddin" (ByVal vtDimName As Variant, ByVal vtMember As Variant) As Long
Sub Example_HypSetActiveMember()
sts = HypSetActiveMember("Market", "Washington")
End Sub