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
GLOP.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
Data Mart Name
GID-APPLIC-TYPE Alpha 3 GLDM.1 GLDX.1
Application Type The 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
Act Dimension The Accounts Dimension Name field
contains the user-defined name for the
Accounts dimension. This name can
contain up to 30 characters of any kind.
GID-PRD-DIMENSION Alpha 50 (Lower Case) GLDM.1
Prd Dimension The Period Dimension Name field
contains the user-defined name for the
Period dimension. This name can contain
up to 30 characters of any kind.
GID-FYR-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Fyr Dimension The Fiscal Year Dimension Name field
contains the user-defined name for the
Fiscal Year dimension. The name can
contain up to 30 characters of any kind.
GID-SCN-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Scn Dimension The Scenario Dimension Name field
contains the user-defined name for the
Scenario dimension. This name can
contain up to 30 characters of any kind.
GID-TYP-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Typ Dimension Optional. The Type Dimension Name field
contains the user-defined name for the
Type dimension. This name can contain up
to 30 characters of any kind.
GID-SAC-DIMENSION Alpha 50 (Lower Case) GLDM.1 GLDX.1
Sac Dimension Optional. The Products Dimension Name
field contains the user-defined name for
the Products dimension. The Products
dimension represents a set of
subaccounts. This set of subaccounts is
defined by the From Subaccount field,
the Through Subaccount Field, and the
Account Group field. This name can
contain up to 30 characters of any kind.
GID-CURRENCY-CODE Alpha 5 GLDM.1 GLDX.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
GID-CURRENCY-TYPE Alpha 1 GLDM.1
Currency Type This field identifies the type of
currency included. You can select Base
currency or Transaction currency.
" " = Base
T = Transaction
GLIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GIDSET1 DATA-MART-NAME GLDM.1 GLDX.1
GLOP.1
GIDSET2 APPLIC-TYPE
DATA-MART-NAME
|
