Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
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. |
HypGetRowItems(vtRowID, vtDimensionName, vtMemberNames)
ByVal vtRowID As Variant
ByRef vtDimensionName As Variant
ByRef vtMemberNames As Variant
vtRowID: The row number n.
vtDimensionName: Output parameter; the nth row dimension name
vtMemberNames: Output parameter; the members for the nth row dimensions
Returns 0 if successful; otherwise, returns the appropriate error code.
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