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

IFEO.1

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 Member Object Identifier	Numeric 12 The 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 Element: 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 Dimension Object Identifier	Numeric 12 The 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 Element: 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 Element: Unary Operator	Alpha 1 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 Element: Last Update 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 Element: Last Update Time	Numeric 6 (hhmmss) The Last Update Time field contains the time the member was last updated.	IAAP.1 IAMB.1
MBR-RECORD-OWNER Element: Record Owner	Alpha 1 The 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 Element: Dynamic Calculation	Alpha 1 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	IA04.1 IA04.2
MBR-PARENT-OBJ-ID Parent Object Identifier	Numeric 12 This 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 Reference Number	Numeric 3 Optional. 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 Element: Is Shared	Alpha 1
MBR-DEFAULT-ALIAS Element: Default Alias	Derived 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

MEMBER FILE RELATIONS

ONE TO ONE RELATIONS

MEMBER FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.