MBROPTIONS – Member Options

System
Analytic Architect (IA)
Prefix
MBO
Primary key
MBR-OBJ-ID, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAME
Fields
8
Updated by
14 programs
Referenced by
2 programs

MBROPTIONS is the Member Options table in Lawson Analytic Architect (prefix MBO). It is indexed by MBR-OBJ-ID, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAME (MBOSET1); alternate indexes: MBOSET2, MBOSET3, MBOSET4, MBOSET5 and MBOSET6. It is related 1:1 to OLAPUDA. It is updated by IA04.1, IA04.2, IA10.1, IA10.2, IA115, IA12.1, IA12.2, IA12.3 and 6 more and referenced by IAMR.1 and IASD.1. The table has 8 fields, 6 indexes and 1 documented relation.

About MBROPTIONS

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.

Fields (8)

Column = COBOL field name without the MBO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MBO-MBR-OBJ-ID PK
MBR_OBJ_ID		Numeric 12The Member Object Identifier field contains a unique numeric identifier assigned to a member, which associates this record to the appropriate MEMBER file record.IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1, IAMD.1
MBO-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • U UDA
  • A Alias Name
IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1
MBO-ALIAS-TABLE PK
ALIAS_TABLE		Alpha 8 (Lower Case)The Alias Table field contains the name of the table that contains member alias 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.IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1
MBO-INSTANCE-NAME PK
INSTANCE_NAME		Alpha 50 (Lower Case)The Instance Name field contains the UDA value or alias name, depending on the record type assigned in the Record Type field.IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1
MBO-DATA-MART-NAME
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1
MBO-UDA-USEAGE
UDA_USEAGE		Alpha 1The 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
IA12.1
MBO-RECORD-STATUS
RECORD_STATUS		Alpha 1The 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
IAMB.1
MBO-RECORD-OWNER
RECORD_OWNER		Alpha 1The Record Owner field contains the name of the record owner. Valid values are:
  • L Lawson
  • U User
IA04.1, IA04.2, IA115, IA12.1, IA12.2, IAMB.1

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MBOSET1MBR-OBJ-ID, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAMEPrimary, KeyChangeIA04.1, IA04.2, IA120, IA15.1, IA300, IAMD.1
MBOSET2DATA-MART-NAME, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAME, MBR-OBJ-IDKeyChangeIA10.1, IA10.2, IA12.1, IAMB.1, IAMD.1, IASV.2
MBOSET3DATA-MART-NAME, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAMEKeyChange, SubsetWhere RECORD-TYPE = "A"IA04.1, IA04.2, IA115, IA12.2, IA12.3, IAMB.1, IASD.1
MBOSET4MBR-OBJ-ID, ALIAS-TABLEKeyChange, SubsetWhere RECORD-TYPE = "A"IA04.1, IA04.2, IA115, IA12.2, IAMB.1
MBOSET5DATA-MART-NAME, RECORD-TYPE, INSTANCE-NAME, ALIAS-TABLE, MBR-OBJ-IDKeyChange—
MBOSET6DATA-MART-NAME, RECORD-OWNER, MBR-OBJ-ID, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAMEKeyChangeIAMR.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OlapudaOLAPUDARequiredMBO-DATA-MART-NAME → UDA-DATA-MART-NAME, MBO-INSTANCE-NAME → UDA-UDA-NAME

Programs

Updated by (14)

Referenced by (2)