This structure contains information about an outline member.
Type ESB_MBRINFO_T szMember As String * ESB_MBRNAMELEN usLevel As Integer usGen As Integer usConsolidation As Integer fTwoPass As Integer fExpense As Integer usConversion As Integer szCurMember As String * ESB_MBRNAMELEN usTimeBalance As Integer usSkip As Integer usShare As Integer usStorage As Integer usCategory As Integer usStorageCategory As Integer ulChildCount As Long szComment As String * ESB_MBRCOMMENTLEN szDimName As String * ESB_MBRNAMELEN Attribute As Variant IsAttributed As Integer End Type
Data Type | Field | Description |
String * ESB_MBRNAMELEN | szMember | Member name. This field can be set only by the caller when creating the member. |
Integer | usLevel | Level of the member in the outline. This field cannot be modified. |
Integer | usGen | Generation of the member in the outline. This field cannot be modified. |
Integer | usConsolidation | Unary consolidation type. It can be one of the following: ESB_UCALC_ADD ESB_UCALC_SUB ESB_UCALC_MULT ESB_UCALC_DIV ESB_UCALC_PERCENT ESB_UCALC_NOOP |
Integer | fTwoPass | ESB_TRUE if two-pass calculation member |
Integer | fExpense | ESB_TRUE if expense member |
Integer | usConversion | Currency conversion type. This is valid only for members of the Accounts dimension. It can be one of the following: ESB_CONV_NONE ESB_CONV_CATEGORY ESB_CONV_NOCONV |
String * ESB_MBRNAMELEN | szCurMember | If the member is of the Accounts dimension and usConversion is ESB_CONV_CATEGORY, this field defines the currency category. If the member is of the Country Dimension, this field defines the currency name. This field is undefined in all other situations. |
Integer | usTimeBalance | Time balance option. This is valid only for members of the Accounts dimension. It can be one of the following: ESB_TIMEBAL_NONE ESB_TIMEBAL_FIRST ESB_TIMEBAL_LAST ESB_TIMEBAL_AVG |
Integer | usSkip | Time balance skip option. This is valid only for members of the Accounts dimension if usTimeBalance is not equal to ESB_TIMEBAL_NONE. It can be one of the following: ESB_SKIP_NONE ESB_SKIP_MISSING ESB_SKIP_ZEROS ESB_SKIP_BOTH |
Integer | usShare | Share option. It can be one of the following: ESB_SHARE_DATA (default value) ESB_SHARE_DYNCALCSTORE ESB_SHARE_DYNCALCNOSTORE ESB_SHARE_NEVER ESB_SHARE_LABEL ESB_SHARE_SHARE (Valid for level 0 members only) |
Integer | usStorage | Dimension storage type. This field is valid only for dimension members and can be one of the following: ESB_DIMTYPE_DENSE ESB_DIMTYPE_SPARSE |
Integer | usCategory | Dimension category. This field is valid only for
dimensions and attribute members. It can be one of the following: ESB_CAT_ACCOUNTS ESB_CAT_ATTRCALC (for internal use only) ESB_CAT_ATTRIBUTE ESB_CAT_COUNTRY ESB_CAT_CURPARTITION (for non-currency databases only) ESB_CAT_NONE ESB_CAT_TIME (for currency databases only) ESB_CAT_TYPE |
Integer | usStorage Category | Dimension storage category. This field is valid only for dimensions and
attribute members. It is used to optimize the storage types of dimensions when the outline is
configured for automatic optimization. It can be one of the following: ESB_STORECAT_ACCOUNTS ESB_STORECAT_ATTRCALC (for internal use only) ESB_STORECAT_ATTRIBUTE ESB_STORECAT_BUSUNIT ESB_STORECAT_CUSTOMER ESB_STORECAT_DIST ESB_STORECAT_GEOG ESB_STORECAT_MARKET ESB_STORECAT_ORGAN ESB_STORECAT_OTHER ESB_STORECAT_PRODUCT ESB_STORECAT_SCENARIO ESB_STORECAT_TIME ESB_STORECAT_UNITS |
Long | ulChildCount | This field contains the total number of children of the member specified in ESB_MBRNAME_T. |
String * ESB_MBRCOMMENTLEN | szComment | Member comment array. |
String * ESB_MBRNAMELEN | szDimName | Dimension name. |
Variant | Attribute | Attribute value: For an attribute dimension or zero-level (leaf node) attribute member,
one of the following data types:
ESB_ATTRMBRDT_BOOL ESB_ATTRMBRDT_DATETIME ESB_ATTRMBRDT_DOUBLE ESB_ATTRMBRDT_STRING For any attribute member, but not an attribute dimension: ESB_ATTRMBRDT_NONE ESB_ATTRMBRDT_AUTO |
Integer | IsAttributed | Indicates whether the member has attributes associated with it. |