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 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