HypGetRowItems
Describes the Oracle Smart View for Office VBA function, HypGetRowItems.
Data provider types: Oracle Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
Description
HypGetRowItems() returns the members present for the nth row dimension in the dynamic link query.
Note:
It is assumed that a call has already been made to HypGetSourceGrid to initialize the dynamic link query, which contains the information about the active data provider and the grid on the worksheet.
Syntax
HypGetRowItems(vtRowID, vtDimensionName, vtMemberNames)
ByVal vtRowID As Variant
ByRef vtDimensionName As Variant
ByRef vtMemberNames As Variant
Parameters
vtRowID: The row number n.
vtDimensionName: Output parameter; the nth row dimension name
vtMemberNames: Output parameter; the members for the nth row dimensions
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypGetRowItems Lib "HsAddin" (ByVal vtRowID As Variant, ByRef vtDimensionName As Variant, ByRef vtMemberNames As Variant) As Long
Sub Example_HypGetRowItems()
Dim vtGrid As Variant
Dim vtDimName As Variant
Dim vtMembers As Variant
Sts = HypConnect(Empty, "UserName", "Password", "DemoBasic_Connection")
Sts = HypRetrieve(Empty)
Range ("B2").Select
Sts = HypGetSourceGrid (Empty, vtGrid)
Sts = HypGetRowItems(1, vtDimName, vtMembers)
End sub