Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MEMBER


                              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     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             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
Element: Data Mart NameThis field contains the name of the data  IA15.1  IAAP.1
                       mart.                                     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
Element: 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
Element: Unary OperatorThe 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
Element: Last Update DaThe Last Update Date field contains the
                       date the member was last updated.

MBR-LAST-UPD-TIME      Numeric 6  (hhmmss)                       IAAP.1  IAMB.1
Element: Last Update TiThe Last Update Time field contains the
                       time the member was last updated.

MBR-RECORD-OWNER       Alpha 1                                   IA04.1  IA04.2
Element: 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
Element: Dynamic CalculThe 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          This is the object identifier. It is      IA15.1  IAAP.1
Identifier             used to relate commitments or posted      IAMB.1  IAMD.1
                       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.

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
Element: Is Shared

MBR-DEFAULT-ALIAS      Derived
Element: 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  IFEO.1

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