HypSetColItems

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

Description

HypSetColItems() sets the members for the nth column dimension for the dynamic link query. If the nth column does not exist, a new column is appended.

Note:

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

Syntax

HypSetColItems (vtColumnID, vtDimensionName, ppMemberList())

ByVal vtColumnID As Variant

ByVal vtDimensionName As Variant

ParamArray ppMemberList() As Variant

Parameters

vtColumnID: The column number n.

vtDimensionName: The dimension name.

ppMemberList: The list of member names.

Return Value

Long. Returns 0 if successful, otherwise, returns the appropriate error code.

Example

Declare Function HypSetColItems Lib "HsAddin" (ByVal vtColID As Variant, ByVal vtDimensionName As Variant, ParamArray MemberList() As Variant) As Long

Sub Macro()
   Dim vtGrid as Variant
   Sts = HypConnect(Empty, "system", "password", "SalesDemoBasic")
   Sts = HypRetrieve(Empty)
   Range (“B2”).Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypSetColItems (1, "Market", "East", "West", "South", 
    "Central", "Market")
End sub