GLIADIM – Financial Analyzer Dimensions

System
General Ledger Setup (IF)
Prefix
GID
Primary key
DATA-MART-NAME
Fields
13
Updated by
2 programs
Referenced by
3 programs

GLIADIM is the Financial Analyzer Dimensions table in Lawson General Ledger Setup (prefix GID). It is indexed by DATA-MART-NAME (GIDSET1). It is updated by GLDM.1 and GLDX.1 and referenced by GLDE.1, GLOP.1 and IFBC.1. The table has 13 fields, 1 index and 0 documented relations.

About GLIADIM

The Financial OLAP Dimensions data file stores the definition of each dimension that has been defined by GL87.1 (Financial OLAP Dimensions).

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
GID-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.GLDM.1, GLDX.1
GID-APPLIC-TYPE
APPLIC_TYPE		Alpha 3The Application Type file stores the names of the Lawson applications that can be requested to supply information to the OLAP database. The Lawson applications that are currently OLAP-ready are:
  • FIN Financial Analyzer
  • FND Daily Financial Analyzer
  • SA Sales Analyzer
  • CX Case Cart Analyzer
  • PO Purchasing Analyzer
  • WO Work Order Analyzer
GLDM.1, GLDX.1
GID-ORG-DIMENSION
ORG_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-ACT-DIMENSION
ACT_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-PRD-DIMENSION
PRD_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1
GID-FYR-DIMENSION
FYR_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-SCN-DIMENSION
SCN_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-TYP-DIMENSION
TYP_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-SAC-DIMENSION
SAC_DIMENSION		Alpha 50 (Lower Case)The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.GLDM.1, GLDX.1
GID-CUR-DIMENSION
CUR_DIMENSION		Alpha 50 (Lower Case)—GLDM.1
GID-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).GLDM.1, GLDX.1, GLOP.1
GID-CURRENCY-TYPE
CURRENCY_TYPE		Alpha 1This field identifies the type of currency included. You can select Base currency or Transaction currency. " " = Base
  • T Transaction
GLDM.1, GLOP.1
GID-LEDGER
LEDGER		Alpha 15The name that identifies the strategic ledger. The Ledger information is used to post Strategic ledger data using SL190 (Strategic Ledger Posting) or used for reporting in the OLAP environment using SL87 (Strategic Ledger Data Mart Setup).—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
GIDSET1DATA-MART-NAMEPrimaryGLDE.1, GLDM.1, GLDX.1, GLOP.1, IFBC.1

Programs

Updated by (2)

Referenced by (3)