Lawson Insight Technical Documentation

                             POIAATRIB FILE

REFERENCED BY

POAB.1    POAO.1    POAP.1    POAV.1

UPDATED BY

POA5.1    POA5.2    POA5.3    POA5.4    POA2.1    POA2.2
POA2.3    POA2.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PIT-APPLIC-TYPE      Alpha 3                                     POA5.1  POA5.2
Application Type     The Application Type file stores the        POA5.3  POA5.4
                     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

PIT-DATA-MART-NAME   Alpha 20  (Lower Case)                      POA5.1  POA5.2
Data Mart Name                                                   POA5.3  POA5.4

PIT-DIMENSION-NAME   Alpha 50  (Lower Case)                      POA5.1  POA5.2
Dimension Name       The Dimension Name field contains the       POA5.3  POA5.4
                     dimension name that is used by the OLAP
                     database.

                     Valid values are:
                     Year
                     Period
                     Measures
                     Scenario
                     Compton
                     Territory
                     Customer
                     Items

PIT-LAWSON-DIM-NAM   Alpha 20                                    POA5.1  POA5.2
Lawson Dim Nam                                                   POA5.3  POA5.4

PIT-ATTR-LAWSON-NM   Alpha 12                                    POA5.1  POA5.2
Attr Lawson Nm                                                   POA5.3  POA5.4

PIT-ATTR-LVL-NAME    Alpha 12                                    POA5.1  POA5.2
Attr Lvl Name                                                    POA5.3  POA5.4

PIT-ATTRIBUTE-NAME   Alpha 50  (Lower Case)                      POA5.1  POA5.2
Attribute Name                                                   POA5.3  POA5.4

PIT-ATTR-PREFIX      Alpha 2                                     POA5.1  POA5.2
Attr Prefix                                                      POA5.3  POA5.4

                         POIAATRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PITSET1   APPLIC-TYPE
          DATA-MART-NAME
          DIMENSION-NAME
          ATTRIBUTE-NAME

PITSET2   APPLIC-TYPE                                            POA2.1  POA2.2
          DATA-MART-NAME                                         POA2.3  POA2.4
          DIMENSION-NAME                                         POA5.1  POA5.2
          ATTR-LAWSON-NM                                         POA5.3  POA5.4
                                                                 POAB.1  POAO.1
                                                                 POAP.1  POAV.1

PITSET3   APPLIC-TYPE                                            POA5.1  POA5.2
          DATA-MART-NAME                                         POA5.3  POA5.4
          ATTRIBUTE-NAME