HypGetSourceGrid

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

Description

HypGetSourceGrid() creates a query from the source grid for the dynamic link query.

This function applies to both static and dynamic link views.

Note:

A cell in the grid must be selected before this making this call.

Note:

This function is used specifically with dynamic link views, as described in VBA Functions and Dynamic Link Views.

Syntax

HypGetSourceGrid(vtSheetName, vtGrid)

ByVal vtSheetName As Variant

ByRef vtGrid As Variant

Parameters

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

vtGrid: The grid XML is returned on successful execution.

Return Value

Returns 0 if successful or the appropriate error code otherwise.

Example

Declare Function HypGetSourceGrid Lib "HsAddin" (ByVal vtSheetName As Variant, ByRef vtGrid As Variant) As Long

Sub Macro()
   Dim vtGrid as Variant
   Range ("B2").Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
End sub