HypPivotToGrid

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

Description

HypPivotToGrid() moves the selected dimension and members from the POV to the spreadsheet grid.

Syntax

HypPivotToGrid (vtSheetName, vtDimensionName, vtSelection)

ByVal vtSheetName as Variant

ByVal vtDimensionName as Variant

ByVal vtSelection as Variant

Parameters

vtSheetName: For future use. Currently the active sheet is used.

vtDimensionName: Currently selected dimension from the toolbar.

vtSelection: Range object which 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 HypPivotToGrid Lib “HsAddin” (By Val vtSheetName As Variant, ByVal vtDimensionName as Variant, ByVal vtSelection as Variant) As Long

Sub DoPivotGrid()
X=HypPivotToGrid(Empty, “Product”, RANGE("E6"))
If X = 0 Then
   MsgBox("Pivot to grid successful.")
Else
   MsgBox("Pivot to grid failed.")
End If
End Sub