GLIADIM FILE
Financial Analyzer Dimensions
The Financial OLAP Dimensions data file stores the definition of each
dimension that has been defined by GL87.1 (Financial OLAP Dimensions).
REFERENCED BY
GLDE.1 GLOP.1 IFBC.1
UPDATED BY
GLDM.1 GLDX.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GID-DATA-MART-NAME Alpha 20 (Lower Case) GLDM.1 GLDX.1
Element: Data Mart Name
GID-APPLIC-TYPE Alpha 3 GLDM.1 GLDX.1
Element: Application TyThe 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
GID-ORG-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization The Organization Dimension Name field
Dimensioin Name contains the user-defined name for the
Organization dimension. This name can
contain up to 30 characters of any kind.
GID-ACT-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization
Dimensioin Name
GID-PRD-DIMENSION Alpha 50 (Lower Case) GLDM.1
Organization
Dimensioin Name
GID-FYR-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization
Dimensioin Name
GID-SCN-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization
Dimensioin Name
GID-TYP-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization
Dimensioin Name
GID-SAC-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Organization
Dimensioin Name
GID-CUR-DIMENSION Alpha 50 (Lower Case) GLDM.1
Element: Cur Dimension
GID-CURRENCY-CODE Alpha 5 GLDM.1 GLDX.1
Element: Currency Code This field contains the company base GLOP.1
currency code established in Company
(GL10.1 ).
GID-CURRENCY-TYPE Alpha 1 GLDM.1 GLOP.1
Element: Currency Type This field identifies the type of
currency included. You can select Base
currency or Transaction currency.
" " = Base
T = Transaction
GID-LEDGER Alpha 15
Element: Ledger The 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).
GLIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIDSET1 DATA-MART-NAME GLDE.1 GLDM.1
GLDX.1 GLOP.1
IFBC.1
GIDSET2 APPLIC-TYPE KeyChange
DATA-MART-NAME
|