HypGetRowItems

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

Description

HypGetRowItems() returns the members present for the nth row dimension in the dynamic link query.

Note:

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

Syntax

HypGetRowItems(vtRowID, vtDimensionName, vtMemberNames)

ByVal vtRowID As Variant

ByRef vtDimensionName As Variant

ByRef vtMemberNames As Variant

Parameters

vtRowID: The row number n.

vtDimensionName: Returns the nth row dimension name.

vtMemberNames: Returns the members for the nth row dimensions.

Return Value

Returns 0 if successful; otherwise, returns the negative error code.

Example

Declare Function HypGetRowItems Lib "HsAddin" (ByVal rowID As Variant, ByRef vtDimensionName As Variant, ByRef vtMemberNames As Variant) As Long

Sub Macro()
   Dim vtGrid as Variant
   Dim vtDimName as Variant
   Dim vtMembers as Variant
   Sts = HypConnect(Empty, "system", "password", "AnamikaDemoBasic")
   Sts = HypRetrieve(Empty)
   Range (“B2”).Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypGetRowItems(1, vtDimName, vtMembers)
End sub