HypPivotToPOV
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
HypPivotToPOV() pivots from the grid to the POV.
Syntax
HypPivotToPOV (vtSheetName, vtSelection)
ByVal vtSheetName As Variant
ByVal vtSelection As Variant
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtSelection: The range object that refers to the single cell starting point of the pivot. Orientation is calculated based on the selection.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypPivotToPOV Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelection As Variant) As Long
Sub Example_HypPivotToPOV()
X=HypPivotToPOV(Empty, RANGE("E6"))
If X = 0 Then
MsgBox("Pivot to POV successful.")
Else
MsgBox("Pivot to POV failed.")
End If
End Sub