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 AC87.1 CXA1.1 HC01.1 HC02.1 GL87.1 GL88.1 POA1.1 SAA1.1 WOA1.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY MBR-OBJ-ID Numeric 12 AC87.1 CXA1.1 Member Object The Object Identifier field contains GL87.1 GL88.1 Identifier the numeric identifier for the member. HC01.1 HC02.1 POA1.1 SAA1.1 WOA1.1 MBR-APPLIC-NAME Alpha 8 (Lower Case) AC87.1 CXA1.1 Application Name The Application Name is the name of the GL87.1 GL88.1 application that describes the database HC01.1 HC02.1 names it contains. This user-defined POA1.1 SAA1.1 name can contain up to eight characters. WOA1.1 The first letter of the name must be capitalized. MBR-DATABASE-NAME Alpha 8 (Lower Case) AC87.1 CXA1.1 Database Name The Database Name is the name of the GL87.1 GL88.1 database that is stored within the OLAP HC01.1 HC02.1 application. Each application may POA1.1 SAA1.1 contain more than one database. This WOA1.1 user-defined name can contain up to eight characters. The first letter of the name must be capitalized. MBR-DIM-OBJ-ID Numeric 12 AC87.1 CXA1.1 Dimension Object The Dimension Object Identifier field GL87.1 GL88.1 Identifier contains a unique numeric identifier HC01.1 HC02.1 assigned to the dimension, which POA1.1 SAA1.1 associates this record to the member WOA1.1 records. MBR-MEMBER-NAME Alpha 50 (Lower Case) AC87.1 CXA1.1 Member Name The Member Name field is an override GL87.1 GL88.1 member name for data mart dimensions HC01.1 HC02.1 with no association to a budget POA1.1 SAA1.1 dimension. WOA1.1 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) AC87.1 CXA1.1 Last Update Date The Last Update Date field contains the GL87.1 GL88.1 date the member was last updated. HC01.1 HC02.1 POA1.1 SAA1.1 WOA1.1 MBR-LAST-UPD-TIME Numeric 6 (hhmmss) AC87.1 CXA1.1 Last Update Time The Last Update Time field contains the GL87.1 GL88.1 time the member was last updated. HC01.1 HC02.1 POA1.1 SAA1.1 WOA1.1 MBR-RECORD-OWNER Alpha 1 AC87.1 CXA1.1 Record Owner The Record Owner field contains the GL87.1 GL88.1 name of the record owner. HC01.1 HC02.1 POA1.1 SAA1.1 Valid values are: WOA1.1 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 AC87.1 CXA1.1 Parent Object The Parent Object Identifier field GL87.1 GL88.1 Identifier contains the object identifier of the HC01.1 HC02.1 member parent. POA1.1 SAA1.1 WOA1.1 MBR-GENERATION Numeric 3 AC87.1 CXA1.1 Generation Optional. The Generation Reference GL87.1 GL88.1 Reference Number field contains the Essbase generation HC01.1 HC02.1 reference number for the member. This POA1.1 SAA1.1 number is 2 or higher. WOA1.1 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 APPLIC-NAME KeyChange AC87.1 CXA1.1 DATABASE-NAME HC01.1 HC02.1 MEMBER-NAME GL87.1 GL88.1 POA1.1 SAA1.1 WOA1.1 MBRSET3 APPLIC-NAME KeyChange, Subset DATABASE-NAME Where RECORD-OWNER = "L" DIM-OBJ-ID LAST-UPD-DATE LAST-UPD-TIME OBJ-ID MBRSET4 APPLIC-NAME KeyChange DATABASE-NAME DIM-OBJ-ID MEMBER-NAME OBJ-ID MBRSET5 APPLIC-NAME KeyChange DATABASE-NAME RECORD-OWNER MEMBER-NAME MBRSET7 APPLIC-NAME KeyChange DATABASE-NAME GENERATION MEMBER-NAME MBRSET8 APPLIC-NAME Subset DATABASE-NAME Where DYNAMIC-CALC = "F" OBJ-ID Or DYNAMIC-CALC = "S" MEMBER FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Olapdbm OLAPDBM Required MBR-APPLIC-NAME -> ODB-APPLIC-NAME (ODBSET1) MBR-DATABASE-NAME -> ODB-DATABASE-NAME Parent MEMBER Not Required MBR-PARENT-OBJ-ID -> MBR-OBJ-ID |