Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
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. |
HypGetPOVItems(vtDimensionNames, vtPOVNames)
ByRef vtDimensionNames As Variant
ByRef vtPOVNames As Variant
vtDimensionNames: The dimension names in the POV
vtPOVNames: The currently selected member for each dimension in the POV.
Returns 0 if successful; otherwise, returns the appropriate error code.
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