MEMBER

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

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-NAME
MEMBER-NAME
KeyChange
IA04.1 IA04.2
IA10.1 IA10.2
IA115 IA12.1
IA12.2 IA15.1
IAAP.1 IAMB.1
IAMD.1 IASD.1
IASV.2 IFEO.1
MBRSET3 DATA-MART-NAME
DIM-OBJ-ID
LAST-UPD-DATE
LAST-UPD-TIME
OBJ-ID
KeyChange, Subset
WhereRECORD-OWNER ="L"
IA120 IA300
MBRSET4 DATA-MART-NAME
DIM-OBJ-ID
MEMBER-NAME
OBJ-ID
KeyChange
IA04.2 IA15.1
IAMD.1
MBRSET5 DATA-MART-NAME
RECORD-OWNER
MEMBER-NAME
KeyChange
MBRSET6 DATA-MART-NAME
LAST-UPD-DATE
LAST-UPD-TIME
OBJ-ID
KeyChange, Subset
WhereRECORD-OWNER ="L"
IA300
MBRSET7 DATA-MART-NAME
GENERATION
MEMBER-NAME
KeyChange
MBRSET8 DATA-MART-NAME
OBJ-ID
Subset
WhereDYNAMIC-CALC ="F"
OrDYNAMIC-CALC ="S"
IAMR.1


MEMBER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:16:28 2016

Home
Contact Us



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