Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
Sets the members for the nth row dimension for this dynamic link query. If the nth row does not exist, a new row is appended.
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. |
HypSetRowItems (vtRowID, vtDimensionName, ParamArray MemberList())
ByVal vtRowID As Variant
ByVal vtDimensionName As Variant
ParamArray MemberList() As Variant
vtRowID: The row number n
vtDimensionName: The dimension name
ParamArray MemberList: The list of member names
Long. Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypSetRowItems Lib "HsAddin" (ByVal vtRowID As Variant, ByVal vtDimensionName As Variant, ParamArray MemberList() As Variant) As Long Sub Example_HypSetRowItems() Dim vtGrid As Variant Sts = HypConnect(Empty, "UserName", "Password", "DemoBasic") Sts = HypRetrieve(Empty) Range ("B2").Select Sts = HypGetSourceGrid (Empty, vtGrid) Sts = HypSetRowItems(1, "Product", "100", "200", "300", "400", "Diet", "Product") End sub