MEMBER – Outline Members

System
Analytic Architect (IA)
Prefix
MBR
Primary key
OBJ-ID
Fields
13
Updated by
11 programs
Referenced by
6 programs

MEMBER is the Outline Members table in Lawson Analytic Architect (prefix MBR). It is indexed by OBJ-ID (MBRSET1); alternate indexes: MBRSET2, MBRSET3, MBRSET4, MBRSET5, MBRSET6, MBRSET7 and MBRSET8. It is related 1:1 to MBROPTIONS and MEMBER and 1:M to MBROPTIONS. It is updated by IA04.1, IA04.2, IA10.1, IA10.2, IA120, IA15.1, IA300, IAAP.1 and 3 more and referenced by IA115, IA12.1, IA12.2, IAMR.1, IASD.1 and IFEO.1. The table has 13 fields, 8 indexes and 5 documented relations.

About MEMBER

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.

Fields (13)

Column = COBOL field name without the MBR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MBR-OBJ-ID PK
OBJ_ID		Numeric 12The Object Identifier field contains the numeric identifier for the member.IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-DATA-MART-NAME
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-DIM-OBJ-ID
DIM_OBJ_ID		Numeric 12The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-MEMBER-NAME
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-UNARY-OPERATOR
UNARY_OPERATOR		Alpha 1The 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
LAST_UPD_DATE		Numeric 8 (yyyymmdd)The Last Update Date field contains the date the member was last updated.IAAP.1, IAMB.1
MBR-LAST-UPD-TIME
LAST_UPD_TIME		Numeric 6 (hhmmss)The Last Update Time field contains the time the member was last updated.IAAP.1, IAMB.1
MBR-RECORD-OWNER
RECORD_OWNER		Alpha 1The Record Owner field contains the name of the record owner. Valid values are:
  • L Lawson
  • U User
IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-DYNAMIC-CALC
DYNAMIC_CALC		Alpha 1The 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. calculated each time data values are accessed by a user. 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
  • F Dynamic calculation. This member is
  • S Dynamic calculation and store. This
IA04.1, IA04.2
MBR-PARENT-OBJ-ID
PARENT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.IA04.1, IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-GENERATION
GENERATION		Numeric 3Optional. The Generation Reference field contains the Essbase generation reference number for the member. This number is 2 or higher.IA04.2, IA15.1, IAAP.1, IAMB.1, IAMD.1
MBR-IS-SHARED
IS_SHARED		Alpha 1——
MBR-DEFAULT-ALIAS
DEFAULT_ALIAS		DerivedThe Default Alias field contains the default alias table's alias name, if one exists. Otherwise, the Default Alias table name contains the member name.—

Indexes (8)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MBRSET1OBJ-IDPrimaryIA04.1, IA04.2, IA12.1, IA12.2, IA120, IA300, IAMD.1, IAMR.1 +1 more
MBRSET2DATA-MART-NAME, MEMBER-NAMEKeyChangeIA04.1, IA04.2, IA10.1, IA10.2, IA115, IA12.1, IA12.2, IA15.1 +6 more
MBRSET3DATA-MART-NAME, DIM-OBJ-ID, LAST-UPD-DATE, LAST-UPD-TIME, OBJ-IDKeyChange, SubsetWhere RECORD-OWNER = "L"IA120, IA300
MBRSET4DATA-MART-NAME, DIM-OBJ-ID, MEMBER-NAME, OBJ-IDKeyChangeIA04.2, IA15.1, IAMD.1
MBRSET5DATA-MART-NAME, RECORD-OWNER, MEMBER-NAMEKeyChange—
MBRSET6DATA-MART-NAME, LAST-UPD-DATE, LAST-UPD-TIME, OBJ-IDKeyChange, SubsetWhere RECORD-OWNER = "L"IA300
MBRSET7DATA-MART-NAME, GENERATION, MEMBER-NAMEKeyChange—
MBRSET8DATA-MART-NAME, OBJ-IDSubsetWhere DYNAMIC-CALC = "F" Or DYNAMIC-CALC = "S"IAMR.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Mbr Alias DefMBROPTIONSNot RequiredMBR-OBJ-ID → MBO-MBR-OBJ-ID, Spaces → MBO-ALIAS-TABLE
ParentMEMBERNot RequiredMBR-PARENT-OBJ-ID → MBR-OBJ-ID

One to many (3) — child tables

RelationTableRulesConditionField map
Mbr AliasesMBROPTIONSMBR-OBJ-ID → MBO-MBR-OBJ-ID, "A" → MBO-RECORD-TYPE, → MBO-ALIAS-TABLE, → MBO-INSTANCE-NAME
Mbr UdasMBROPTIONSMBR-OBJ-ID → MBO-MBR-OBJ-ID, "U" → MBO-RECORD-TYPE, → MBO-ALIAS-TABLE, → MBO-INSTANCE-NAME
MbroptionsMBROPTIONSMBR-OBJ-ID → MBO-MBR-OBJ-ID, → MBO-RECORD-TYPE, → MBO-ALIAS-TABLE, → MBO-INSTANCE-NAME

Programs

Updated by (11)

Referenced by (6)