ESB_MEMBERINFO_T

This structure contains information about a specific member. Fields in this structure cannot be modified using the VB API. The fields are:

Type ESB_MEMBERINFO_T
   CrMbrName     As String * ESB_MBRNAMELEN
   MbrName       As String * ESB_MBRNAMELEN
   DimName       As String * ESB_MBRNAMELEN
   ParentMbrName As String * ESB_MBRNAMELEN
   ChildMbrName  As String * ESB_MBRNAMELEN
   PrevMbrName   As String * ESB_MBRNAMELEN
   NextMbrName   As String * ESB_MBRNAMELEN
   Description   As String * ESB_DESCLEN
   MbrNumber     As Long
   DimNumber     As Long
   status        As Integer
   Level         As Integer
   Generation    As Integer
   UnaryCalc     As Integer
   MbrTagType    As Integer
   CurrConvert   As Integer
   Attribute     As Variant
   IsAttributed  As Integer
End Type
VB Data TypeFieldDescription
As String * ESB_MBRNAMELENCrMbrNameThe name of the tagged currency database member. For the Time dimension, gives the name of the tagged time member, for the Country dimension, gives the name of the tagged currency member. For the Accounts dimension, gives the name of the tagged category member
As String * ESB_MBRNAMELENMbrNameThe member name
As String * ESB_MBRNAMELENDimNameThe member's dimension name (ESB_MBRNAMELEN)
As String * ESB_MBRNAMELENParentMbr NameThe specified member's parent name or an empty string if the member has no parent
As String * ESB_MBRNAMELENChildMbrNameThe specified member's first child member name
As String * ESB_MBRNAMELENPrevMbrNameThe specified member's previous sibling member name
As String * ESB_MBRNAMELENNextMbrNameThe specified member's next sibling member name
As String * ESB_DESCLENDescriptionThe member description
As LongMbrNumberThe member number
As LongDimNumberThe member's dimension number
As IntegerStatus

The member's share status is derived by performing a logical AND between the contents of this field and each of the constant values of the form ESB_MBRSTS_xxx:

  • ESB_MBRSTS_NOTSET

  • ESB_MBRSTS_NEVER

  • ESB_MBRSTS_LABEL

  • ESB_MBRSTS_REFER

  • ESB_MBRSTS_REFNME

  • ESB_MBRSTS_SHARE

  • ESB_MBRSTS_VIRTSTORE

  • ESB_MBRSTS_VIRTNOSTORE

As IntegerLevelThe member level number (zero-based), counting up from the lowest descendent of the specified member
As IntegerGenerationThe member generation number (one-based), counting down from the specified member's dimension member
As IntegerUnaryCalcThe default unary rollup for this member (one of the constant values of the form ESB_UCAL_xxx). Can be add, subtract, multiply, divide, percent, or none
As IntegerMbrTagTypeA 16 bit mask for member's tagged types (masks are of the form ESB_ATYPE_xxx)
As String *1CurrConvertCurrency Conversion. This field can contain the values ESB_TRUE and ESB_FALSE
As VariantAttributeAttribute value. For an attribute dimension or zero-level (leaf node) attribute member, one of the following data types:

  • Boolean (True|False)

  • Date ("09/19/2006")

  • Double (3.14)

  • String ("Hello")

For any attribute member, but not an attribute dimension:

ESB_ATTRMBRDT_NONE = Everything else including empty.

As IntegerIsAttributedIndicates whether the member has attributes associated with it. (ESB_TRUE if attributes are associated.)