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.
REFERENCED BY
IA12.1 IA12.2 IAMR.1 IASD.1 IA115
UPDATED BY
IA04.1 IA04.2 IA10.1 IA10.2 IA120 IA15.1
IA300 IAAP.1 IAMB.1 IAMD.1 IASV.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MBR-OBJ-ID Numeric 12 IA04.1 IA04.2
Member Object The Object Identifier field contains IA15.1 IAAP.1
Identifier the numeric identifier for the member. IAMB.1 IAMD.1
MBR-DATA-MART-NAME Alpha 20 (Lower Case) IA04.1 IA04.2
Data Mart Name IA15.1 IAAP.1
IAMB.1 IAMD.1
MBR-DIM-OBJ-ID Numeric 12 IA04.1 IA04.2
Dimension Object The Dimension Object Identifier field IA15.1 IAAP.1
Identifier contains a unique numeric identifier IAMB.1 IAMD.1
assigned to the dimension, which
associates this record to the member
records.
MBR-MEMBER-NAME Alpha 50 (Lower Case) IA04.1 IA04.2
Member Name This is an override member name for IA15.1 IAAP.1
Data Mart dimensions with no association IAMB.1 IAMD.1
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 IAMB.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 IAMB.1
Last Update Time The Last Update Time field contains the
time the member was last updated.
MBR-RECORD-OWNER Alpha 1 IA04.1 IA04.2
Record Owner The Record Owner field contains the IA15.1 IAAP.1
name of the record owner. IAMB.1 IAMD.1
Valid values are:
L = Lawson
U = User
MBR-DYNAMIC-CALC Alpha 1 IA04.1 IA04.2
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 IA04.1 IA04.2
Parent Object The Parent Object Identifier field IA15.1 IAAP.1
Identifier contains the object identifier of the IAMB.1 IAMD.1
member parent.
MBR-GENERATION Numeric 3 IA04.2 IA15.1
Generation Optional. The Generation Reference IAAP.1 IAMB.1
Reference Number field contains the Essbase generation IAMD.1
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 IA04.1 IA04.2
IA12.1 IA12.2
IA120 IA300
IAMD.1 IAMR.1
IASD.1
MBRSET2 DATA-MART-NAMEKeyChange IA04.1 IA04.2
MEMBER-NAME IA10.1 IA10.2
IA115 IA12.1
IA12.2 IA15.1
IAAP.1 IAMB.1
IAMD.1 IASD.1
IASV.2
MBRSET3 DATA-MART-NAMEKeyChange, Subset IA120 IA300
DIM-OBJ-ID Where RECORD-OWNER = "L"
LAST-UPD-DATE
LAST-UPD-TIME
OBJ-ID
MBRSET4 DATA-MART-NAMEKeyChange IA04.2 IA15.1
DIM-OBJ-ID IAMD.1
MEMBER-NAME
OBJ-ID
MBRSET5 DATA-MART-NAMEKeyChange
RECORD-OWNER
MEMBER-NAME
MBRSET6 DATA-MART-NAMEKeyChange, Subset IA300
LAST-UPD-DATE Where RECORD-OWNER = "L"
LAST-UPD-TIME
OBJ-ID
MBRSET7 DATA-MART-NAMEKeyChange
GENERATION
MEMBER-NAME
MBRSET8 DATA-MART-NAMESubset IAMR.1
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
Mbr Alias Def MBROPTIONS Not Required
MBR-OBJ-ID -> MBO-MBR-OBJ-ID
Spaces -> MBO-ALIAS-TABLE
Parent MEMBER Not Required
MBR-PARENT-OBJ-ID -> MBR-OBJ-ID
MEMBER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mbr Aliases MBROPTIONS
MBR-OBJ-ID -> MBO-MBR-OBJ-ID
"A" -> MBO-RECORD-TYPE
MBO-ALIAS-TABLE
MBO-INSTANCE-NAME
Mbr Udas MBROPTIONS
MBR-OBJ-ID -> MBO-MBR-OBJ-ID
"U" -> MBO-RECORD-TYPE
MBO-ALIAS-TABLE
MBO-INSTANCE-NAME
Mbroptions MBROPTIONS
MBR-OBJ-ID -> MBO-MBR-OBJ-ID
MBO-RECORD-TYPE
MBO-ALIAS-TABLE
MBO-INSTANCE-NAME
|
