GLIADIM

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
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
GLDM.1 GLDX.1
GID-APPLIC-TYPE
Element: Applic Type
Alpha 3
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
GLDM.1 GLDX.1
GID-ORG-DIMENSION
Element: 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
Element: 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-PRD-DIMENSION
Element: 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
GID-FYR-DIMENSION
Element: 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-SCN-DIMENSION
Element: 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-TYP-DIMENSION
Element: 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-SAC-DIMENSION
Element: 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-CUR-DIMENSION
Element: Cur Dimension
Alpha 50 (Lower Case)
GLDM.1
GID-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GLDM.1 GLDX.1
GLOP.1
GID-CURRENCY-TYPE
Element: Currency Type
Alpha 1
This field identifies the type of currency included. You can select Base currency or Transaction currency.
" " = Base
T = Transaction
GLDM.1 GLOP.1
GID-LEDGER
Element: Ledger
Alpha 15
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


File created: Wed Jun 08 20:49:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.