HypGetPOVItems

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

Description

HypGetPOVItems() returns the dimensions in the POV and the currently selected member for each dimension.

Note:

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

Syntax

HypGetPOVItems(vtDimensionNames, vtPOVNames)

ByRef vtDimensionNames As Variant

ByRef vtPOVNames As Variant

Parameters

vtDimensionNames: The dimension names in the POV

vtPOVNames: The currently selected member for each dimension in the POV.

Return Value

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

Example

Declare Function HypGetPOVItems Lib "HsAddin" (ByRef vtDimensionNames As Variant, ByRef vtPOVNames As Variant) As Long

Sub Macro()
   Dim vtGrid as Variant
   Dim vtDimNames As Variant
   Dim vtPOVNames As Variant
   Sts = HypConnect(Empty, "system", "password", "MyDemoBasic")
   Sts = HypRetrieve(Empty)
   Range (“B2”).Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypGetPOVItems (vtDimNames, vtPOVNames)
End sub