GLIAMXDIM – Fin Analyzer Attribute Dim

System
General Ledger Setup (IF)
Prefix
GLI
Primary key
DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBR
Fields
5
Updated by
3 programs
Referenced by
2 programs

GLIAMXDIM is the Fin Analyzer Attribute Dim table in Lawson General Ledger Setup (prefix GLI). It is indexed by DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBR (GLISET1); alternate indexes: GLISET2. It is updated by IFAS.2, IFOS.1 and IFOS.3 and referenced by IFBA.1 and IFBO.1. The table has 5 fields, 2 indexes and 0 documented relations.

About GLIAMXDIM

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the GLI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GLI-DIMENSION-NAME PK
DIMENSION_NAME		Alpha 50 (Lower Case)The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer ItemsIFAS.2, IFOS.3
#GLI-MX-DIM-TYPE PK
MX_DIM_TYPE		Alpha 10—IFAS.2, IFOS.3
#GLI-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.IFAS.2, IFOS.3
#GLI-LEVEL-NBR PK
LEVEL_NBR		Numeric 3—IFAS.2, IFOS.3
#GLI-MEMBER-NAME SET2
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IFAS.2, IFOS.3

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLISET1
  1. DIMENSION-NAME
  2. MX-DIM-TYPE
  3. MATRIX-CAT
  4. LEVEL-NBR
PrimaryIFAS.1, IFAS.2, IFBA.1, IFBO.1, IFOS.1, IFOS.2, IFOS.3
GLISET2
  1. DIMENSION-NAME
  2. MEMBER-NAME
  3. MX-DIM-TYPE
  4. MATRIX-CAT
  5. LEVEL-NBR
KeyChangeIFAS.2, IFOS.3

Programs

Updated by (3)

Referenced by (2)