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
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
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
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
Data Mart Name IA115 IA12.1
IA12.2 IAMB.1
MBO-UDA-USEAGE Alpha 1 IA12.1
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
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
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, Duplicates
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
|
