Data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Oracle Hyperion Financial Management (ad hoc only), Oracle Hyperion Enterprise® (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