HypSetPOVItems

Data source types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)

Description

HypSetPOVItems() sets the POV dimensions for the dynamic link query.

Note:

This function is used specifically with dynamic link views, as described in VBA Functions and Dynamic Link Views.

Syntax

HypSetPOVItems (ppMemberList())

ParamArray ppMemberList() As Variant

Parameters

ppMemberList: The list of desired POV items in the form Dimension#Current Member.

Return Value

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

Example

Declare Function HypSetLinkMacro Lib "HsAddin" (ByVal vtMacroName As Variant) As Long

Sub Macro()
   Dim vtGrid as Variant
   Sts = HypConnect(Empty, "system", "password", "MyDemoBasic")
   Sts = HypRetrieve(Empty)
   Range (“B2”).Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypSetPOVItems ("Scenario#Scenario", "Measures#Measures")
End sub