GetTopMemberOfCustomsForAccount

Returns the member IDs of the top members of an account’s Custom dimension hierarchies. In other words, GetTopMemberOfCustomsForAccount returns the member IDs of the Custom dimension members that have been defined as an account’s Custom1TopMember, Custom2TopMember, Custom3TopMember, and Custom4TopMember attributes.

Tip:

To get the label of the Custom dimension member IDs returned, use HFMwDimension.GetMemberLabel.

Syntax

<HFMwAccounts>.GetTopMemberOfCustomsForAccount varabstrAccount, pvarlCusotm1Top, pvarlCusotm2Top, pvarlCusotm3Top, pvarlCusotm4Top

Argument

Description

varabstrAccount

The label of the Account dimension member.

Input argument.

pvarlCusotm1Top

Returns the member ID of the account’s Custom1TopMember attribute.

Input/output argument.

pvarlCusotm2Top

Returns the member ID of the account’s Custom2TopMember attribute.

Input/output argument.

pvarlCusotm3Top

Returns the member ID of the account’s Custom3TopMember attribute.

Input/output argument.

pvarlCusotm4Top

Returns the member ID of the account’s Custom4TopMember attribute.

Input/output argument.

Example

The following function takes an Account member’s label and returns the label of the account’s Custom1TopMember attribute.

Function GetAcctCust1Label(sAcct)
Dim cHFMMetadata, cHFMAccts, cHFMDim, cHFMCust1
Dim lCust1, lCust2, lCust3, lCust4
' cHFMSession is a previously set HFMwSession object
Set cHFMMetadata = cHFMSession.metadata
Set cHFMAccts = cHFMMetadata.accounts
Set cHFMCust1 = cHFMMetadata.custom1
Set cHFMDim = cHFMCust1.dimension
cHFMAccts.GetTopMemberOfCustomsForAccount sAcct, _ 
   lCust1, lCust2, lCust3, lCust4
GetAcctCust1Label = cHFMDim.GetMemberLabel(lCust1)
End Function