HypGetPOVCount
Describes the Oracle Smart View for Office VBA function, HypGetPOVCount.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Hyperion Financial Management (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