Data provider types: Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Oracle Hyperion Financial Management (ad hoc only), Oracle Hyperion Enterprise® (ad hoc only)
HypSetPOVItems() sets the POV dimensions for the dynamic link query.
Note: | It is assumed that a call has already been made to HypGetSourceGrid to initialize the dynamic link query, which contains the information about the active data provider and the grid on the worksheet. |
HypSetPOVItems (ParamArray MemberList())
ParamArray MemberList() As Variant
ParamArray MemberList(): The list of desired POV items in the form Dimension#Current Member
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypSetPOVItems Lib "HsAddin" (ParamArray MemberList() As Variant) As Long Sub Example_HypSetPOVItems() Dim vtGrid As Variant Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic") Sts = HypRetrieve(Empty) Range ("B2").Select Sts = HypGetSourceGrid (Empty, vtGrid) Sts = HypSetPOVItems ("Scenario#Scenario", "Measures#Measures") End sub