# EsbGetMemberInfo

Description

EsbGetMemberInfo() gets a structure containing information about a specific member in the active database outline.

Syntax

    EsbGetMemberInfo (hCtx, MbrName, MbrInfo)

    ByVal hCtx    As Long
    ByVal MbrName As String
          MbrInfo As ESB_MEMBERINFO_T

Parameters

hCtx | Essbase VB API context handle.
MbrName | Member name.
MbrInfo | Buffer to receive a member information structure.

Return Value

If successful, this function returns a member information structure in pMbrInfo. If the member has no parent, this function returns an empty string in the ParentMbrName field of the ESB_MEMBERINFO_T structure.

Notes

Attributes:

- The ESB_MBRSTS_ATTRIBUTE constant for the Status field of the ESB_MEMBERINFO_T structure indicates that the dimension or member is an attribute dimension or attribute member.
- Two fields of the ESB_MEMBERINFO_T structure are for attributes only:
  - Attribute
  - IsAttributed

Access

This function requires the caller to have access to the database, and to have selected it as their active database using EsbSetActive().

Example

    Declare Function EsbGetMemberInfo Lib "ESBAPIW" (ByVal hCtx As Long,
                                                     ByVal MbrName As String,
                                                           MbrInfo As ESB_MEMBERINFO_T) As Long

    Sub ESB_GetMemberInfo ()
       Dim sts As Long
       Dim MbrName As String
       Dim MbrInfo As ESB_MEMBERINFO_T

       MbrName = "Year"
       '**************************
       ' Get Member Info structure
       '**************************
       sts = EsbGetMemberInfo (hCtx, MbrName, MbrInfo)
    End Sub

See Also

EsbCheckMemberName()
EsbGetMemberCalc()
EsbQueryDatabaseMembers()
EsbSetActive()