HypGetPOVItems

Describes the Oracle Smart View for Office VBA function, HypGetPOVItems.

Data provider types: Oracle Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)

Description

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

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

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 appropriate error code.

Example

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

Sub Example_HypGetPOVItems()
   Dim vtGrid As Variant
   Dim vtDimNames As Variant
   Dim vtPOVNames As Variant
   Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic")
   Sts = HypRetrieve(Empty)
   Range ("B2").Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypGetPOVItems (vtDimNames, vtPOVNames)
End sub