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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLISET1DIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBRPrimaryIFAS.1, IFAS.2, IFBA.1, IFBO.1, IFOS.1, IFOS.2, IFOS.3
GLISET2DIMENSION-NAME, MEMBER-NAME, MX-DIM-TYPE, MATRIX-CAT, LEVEL-NBRKeyChangeIFAS.2, IFOS.3

Programs

Updated by (3)

Referenced by (2)