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.
To get the label of the Custom dimension member IDs returned, use HFMwDimension.GetMemberLabel. |
<HFMwAccounts>.GetTopMemberOfCustomsForAccount varabstrAccount, pvarlCusotm1Top, pvarlCusotm2Top, pvarlCusotm3Top, pvarlCusotm4Top
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