Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MBROPTIONS


                            MBROPTIONS FILE

                             Member Options

The Member Options (MBROPTIONS) file contains information about member UDAs
and alias names. This information is applied to the members by the Analytic
Architect system in addition to the information supplied by the data source.
The information in this file comes from IA120 (Data Mart Load) for Lawson
member names, and from IA12.1 (Member UDAs) and IA12.2 (Member Alias) for
user-defined alias names.

REFERENCED BY

IASD.1    IAMR.1

UPDATED BY

IA04.1    IA04.2    IA10.1    IA10.2    IA115     IA12.1
IA12.2    IA15.1    IAMB.1    IASV.2    IA120     IA300
IAMD.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MBO-MBR-OBJ-ID         Numeric 12                                IA04.1  IA04.2
Member Object          The Member Object Identifier field        IA115   IA12.1
Identifier             contains a unique numeric identifier      IA12.2  IAMB.1
                       assigned to a member, which associates    IAMD.1
                       this record to the appropriate MEMBER
                       file record.

MBO-RECORD-TYPE        Alpha 1                                   IA04.1  IA04.2
Element: Record Type   This field identifies the type of         IA115   IA12.1
                       record defined.                           IA12.2  IAMB.1

                       Valid values are:
                       S = Summary
                       D = Detail
                       U = UDA
                       A = Alias Name

MBO-ALIAS-TABLE        Alpha 8  (Lower Case)                     IA04.1  IA04.2
Element: Alias Table   The Alias Table field contains the name   IA115   IA12.1
                       of the table that contains member alias   IA12.2  IAMB.1
                       names. You use the Essbase Application
                       Manager to define alias tables. You can
                       use the Analytic Architect system to
                       define an alias name to associate with a
                       member. These alias names become part of
                       the alias table. The alias table must be
                       defined for a specific application and
                       data mart.

                       This field can be left blank. All
                       member aliases applied to the blank
                       alias table name are associated to the
                       default alias table defined by the data
                       mart.

MBO-INSTANCE-NAME      Alpha 50  (Lower Case)                    IA04.1  IA04.2
Element: Instance Name The Instance Name field contains the      IA115   IA12.1
                       UDA value or alias name, depending on     IA12.2  IAMB.1
                       the record type assigned in the Record
                       Type field.

MBO-DATA-MART-NAME     Alpha 20  (Lower Case)                    IA04.1  IA04.2
Element: Data Mart NameThis field contains the name of the data  IA115   IA12.1
                       mart.                                     IA12.2  IAMB.1

MBO-UDA-USEAGE         Alpha 1                                   IA12.1
Element: UDA Usage     The UDA Usage field contains the value
                       that determines how the UDA is applied
                       to a member and its descendants. This
                       field is not used in release 7.0.7 of
                       the Analytic Architect system.

                       Valid values are:
                       Blank or spaces = Member only; Default.
                       1 = Children only
                       2 = Descendants only
                       3 = Member and children
                       4 = Member and descendants

MBO-RECORD-STATUS      Alpha 1                                   IAMB.1
Element: Record Status The Record Status field is used to
                       temporarily mark a member information
                       record as deleted so that the Analytic
                       Architect system can remove the UDA or
                       alias name from the member. When the UDA
                       or alias name have been deleted, this
                       record is deleted.

                       Valid values are:
                       A = Active; Default value.
                       D = Deleted

MBO-RECORD-OWNER       Alpha 1                                   IA04.1  IA04.2
Element: Record Owner  The Record Owner field contains the       IA115   IA12.1
                       name of the record owner.                 IA12.2  IAMB.1

                       Valid values are:
                       L = Lawson
                       U = User

                         MBROPTIONS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MBOSET1   MBR-OBJ-ID    KeyChange                                IA04.1  IA04.2
          RECORD-TYPE                                            IA120   IA15.1
          ALIAS-TABLE                                            IA300   IAMD.1
          INSTANCE-NAME

MBOSET2   DATA-MART-NAMEKeyChange                                IA10.1  IA10.2
          RECORD-TYPE                                            IA12.1  IAMB.1
          ALIAS-TABLE                                            IAMD.1  IASV.2
          INSTANCE-NAME
          MBR-OBJ-ID

MBOSET3   DATA-MART-NAMEKeyChange, Subset                        IA04.1  IA04.2
          RECORD-TYPE   Where RECORD-TYPE = "A"                  IA115   IA12.2
          ALIAS-TABLE                                            IAMB.1  IASD.1
          INSTANCE-NAME

MBOSET4   MBR-OBJ-ID    KeyChange, Subset                        IA04.1  IA04.2
          ALIAS-TABLE   Where RECORD-TYPE = "A"                  IA115   IA12.2
                                                                 IAMB.1

MBOSET5   DATA-MART-NAMEKeyChange
          RECORD-TYPE
          INSTANCE-NAME
          ALIAS-TABLE
          MBR-OBJ-ID

MBOSET6   DATA-MART-NAMEKeyChange                                IAMR.1
          RECORD-OWNER
          MBR-OBJ-ID
          RECORD-TYPE
          ALIAS-TABLE
          INSTANCE-NAME

                         MBROPTIONS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapuda        OLAPUDA      Required

                            MBO-DATA-MART-NAME    -> UDA-DATA-MART-NAME
                            MBO-INSTANCE-NAME     -> UDA-UDA-NAME