MEMBER FILE
Outline Members
The Member (MEMBER) file contains information about all members in the
Analytic Architect system. The information in this file comes from IA120 (Data
Mart Load) for Lawson member names and from IA04.1 (Member Definition) for
user-defined member names.
UPDATED BY
IAAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MBR-OBJ-ID Numeric 12 IAAP.1
Member Object The Object Identifier field contains
Identifier the numeric identifier for the member.
MBR-DATA-MART-NAME Alpha 20 (Lower Case) IAAP.1
Data Mart Name
MBR-DIM-OBJ-ID Numeric 12 IAAP.1
Dimension Object The Dimension Object Identifier field
Identifier contains a unique numeric identifier
assigned to the dimension, which
associates this record to the member
records.
MBR-MEMBER-NAME Alpha 50 (Lower Case) IAAP.1
Member Name This is an override member name for
Data Mart dimensions with no association
to a Budget dimension.
MBR-UNARY-OPERATOR Alpha 1
Unary Operator The Unary Operator field contains the
unary operator for the member. This
field is not used in release 7.0.7 of
the Analytic Architect system.
MBR-LAST-UPD-DATE Numeric 8 (yyyymmdd) IAAP.1
Last Update Date The Last Update Date field contains the
date the member was last updated.
MBR-LAST-UPD-TIME Numeric 6 (hhmmss) IAAP.1
Last Update Time The Last Update Time field contains the
time the member was last updated.
MBR-RECORD-OWNER Alpha 1 IAAP.1
Record Owner The Record Owner field contains the
name of the record owner.
Valid values are:
L = Lawson
U = User
MBR-DYNAMIC-CALC Alpha 1
Dynamic Calculation The Dynamic Calculation field contains
the value that determines how the member
is calculated.
Valid values are:
~ = Calculated. The member data has
been calculated in advance.
F = Dynamic calculation. This member is
calculated each time data values are
accessed by a user.
S = Dynamic calculation and store. This
member is calculated the first time its
data values are accessed by a user.
Subsequent users of the member data view
data calculated by first user.
" " = Calculated
MBR-PARENT-OBJ-ID Numeric 12 IAAP.1
Parent Object The Parent Object Identifier field
Identifier contains the object identifier of the
member parent.
MBR-GENERATION Numeric 3 IAAP.1
Generation Optional. The Generation Reference
Reference Number field contains the Essbase generation
reference number for the member. This
number is 2 or higher.
MBR-IS-SHARED Alpha 1
Is Shared
MBR-DEFAULT-ALIAS Derived
Default Alias The Default Alias field contains the
default alias table's alias name, if one
exists. Otherwise, the Default Alias
table name contains the member name.
MEMBER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MBRSET1 OBJ-ID
MBRSET2 DATA-MART-NAMEKeyChange IAAP.1
MEMBER-NAME
MBRSET3 DATA-MART-NAMEKeyChange, Subset
DIM-OBJ-ID Where RECORD-OWNER = "L"
LAST-UPD-DATE
LAST-UPD-TIME
OBJ-ID
MBRSET4 DATA-MART-NAMEKeyChange
DIM-OBJ-ID
MEMBER-NAME
OBJ-ID
MBRSET5 DATA-MART-NAMEKeyChange
RECORD-OWNER
MEMBER-NAME
MBRSET6 DATA-MART-NAMEKeyChange, Subset
LAST-UPD-DATE Where RECORD-OWNER = "L"
LAST-UPD-TIME
OBJ-ID
MBRSET7 DATA-MART-NAMEKeyChange
GENERATION
MEMBER-NAME
MBRSET8 DATA-MART-NAMESubset
OBJ-ID Where DYNAMIC-CALC = "F"
Or DYNAMIC-CALC = "S"
MEMBER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iadrill IADRILL Not Required
MBR-OBJ-ID -> IDR-MBR-OBJ-ID (IDRSET2)
MBR-DIM-OBJ-ID -> IDR-DIM-OBJ-ID
Parent MEMBER Not Required
MBR-PARENT-OBJ-ID -> MBR-OBJ-ID
|
