HypGetPOVCount

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

Description

HypGetPOVCount() returns the number of dimensions in the POV from 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

HypGetPOVCount()

Return Value

Returns the number of dimensions in the POV if successful; otherwise, returns the appropriate error code.

Example

Declare Function HypGetPOVCount Lib "HsAddin" () As Long

Sub Example_HypGetPOVCount()
   Dim vtGrid as Variant
   Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic")
   Sts = HypRetrieve(Empty)
   Range ("B2").Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypGetPOVCount ()
End sub