|
|
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 NameThis field contains the name of the data
mart.
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 The Accounts Dimension Name field
Dimensioin Name 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
Organization The Period Dimension Name field
Dimensioin Name 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
Organization The Fiscal Year Dimension Name field
Dimensioin Name 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
Organization The Scenario Dimension Name field
Dimensioin Name 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
Organization Optional. The Type Dimension Name field
Dimensioin Name 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
Organization Optional. The Products Dimension Name
Dimensioin 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-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
|
