Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLIADIM


                              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