HypGetSourceGrid
Describes the Oracle Smart View for Office VBA function, HypGetSourceGrid.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypGetSourceGrid() creates a query from the source grid for the dynamic link query.
This function applies to both static and dynamic link views.
Before you run HypGetSourceGrid, a connected grid must exist on the active worksheet and a valid data cell must be selected.
Syntax
HypGetSourceGrid(vtSheetName, vtGrid)
ByVal vtSheetName As Variant
ByRef vtGrid 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.
vtGrid: The grid XML returned
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 Example_HypGetSourceGrid()
Dim vtGrid As Variant
Range ("B2").Select
Sts = HypGetSourceGrid (Empty, vtGrid)
End sub