Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypGetColItems() returns the members present in the dynamic link query for the nth column dimensions.
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. |
HypGetColItems(vtColID, vtDimensionName, vtMemberNames)
ByVal vtColID As Variant
ByRef vtDimensionName As Variant
ByRef vtMemberNames As Variant
vtColID : The column number n
vtDimensionName: Returns the nth column dimension name
vtMemberNames: Returns members for the nth column dimensions
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypGetColItems Lib "HsAddin" (ByVal vtColID As Variant, ByRef vtDimensionName As Variant, ByRef vtMemberNames As Variant) As Long Sub Example_HypGetColItems() Dim vtGrid As Variant Dim vtDimensionName As Variant Dim vtMembers As Variant Sts = HypConnect(Empty, "UserName", "Password", "AnamikaDemoBasic") Sts = HypRetrieve(Empty) Range ("B2").Select Sts = HypGetSourceGrid (Empty, vtGrid) Sts = HypGetColItems(1, vtDimensionName, vtMemberNames) End sub