HypGetColItems

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

Description

HypGetColItems() returns the members present in the dynamic link query for the nth column dimensions.

Note:

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

Syntax

HypGetColItems(vtColumnID, vtDimensionName, vtMembers)

ByVal vtColumnID As Variant

ByRef vtDimensionName As Variant

ByRef vtMembers As Variant

Parameters

vtColumnID: The column number n.

vtDimensionName: Returns the nth column dimension name.

vtMembers: Returns members for the nth column dimensions.

Return Value

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

Example

Declare Function HypGetColItems Lib "HsAddin" (ByVal vtColID As Variant, ByRef vtDimensionName As Variant, ByRef vtMembernames As Variant) As Long

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