HypSetPOVItems

Cloud data provider types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud (ad hoc only)

On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Hyperion Financial Management (ad hoc only)

Description

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.

Syntax

HypSetPOVItems (ParamArray MemberList())

ParamArray MemberList() As Variant

Parameters

ParamArray MemberList(): The list of desired POV items in the form Dimension#Current Member

Return Value

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

Example

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