Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            APPLICTYPE FILE

                            Application Type

The Data Mart Type (APPLICTYPE) file stores the names of the Lawson
applications that can be requested to supply information to the data mart. The
information in this file comes from IA100 (Data Mart Type Load) or IA01.1
(Data Mart Types).

The Lawson data marts currently available are:

FIN = Financial Data Mart
FND = Daily Reporting Data Mart
AC = Activity Data Mart
CMP = Compensation Data Mart
SA = Sales Performance Data Mart
CX = Case Carts Data Mart
PO = Purchasing Data Mart
WO = Work Order Data Mart

REFERENCED BY

IA05.1    IA05.3    IA10.1    IA10.2    IA11.1    IA11.3
IA120     IA13.1    IA15.1    IA15.4    IA150     IAAP.1
IAPF.1

UPDATED BY

IA01.1    IA01.3    IA100     IASV.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IAA-APPLIC-TYPE      Alpha 3                                     IA01.1  IA01.3
Data Mart Type       The Application Type file stores the        IA100   IASV.1
                     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

IAA-DESCRIPTION      Alpha 30  (Lower Case)                      IA01.1  IA01.3
Description          The Description field contains a            IA100   IASV.1
                     description of the data mart type.

IAA-DEFN-PROGRAM     Alpha 5                                     IA01.1  IA01.3
Definition Program   The Data Mart Setup Program field           IA100   IASV.1
                     contains the name of the program that
                     provides the dimensions, members, and
                     data selection parameters required by
                     the data mart.

IAA-META-PROGRAM     Alpha 6                                     IA01.1  IA01.3
Outline Load Program The Outline Build Program field             IA100   IASV.1
                     contains the name of the program that
                     the Analytic Architect system calls to
                     supply the outline (description of the
                     data) to the data mart. This may be the
                     same program as the data values load
                     program.

IAA-DATA-PROGRAM     Alpha 6                                     IA01.1  IA01.3
Data Values Load     The Data Values Load program is the         IA100   IASV.1
Program              program that the Analytic Architect
                     system calls to supply the data values
                     to the data mart. This may be the same
                     program as the Outline Build program.

IAA-APPLIC-OWNER     Alpha 1                                     IA01.1  IA01.3
Application Owner    The Application Owner field specifies       IA100   IASV.1
                     the owner of the application that is
                     supplying data to the data mart.

                     Valid values are:
                     L = Lawson
                     U = User-defined

IAA-DATA-INC-LOAD    Alpha 1                                     IA01.1  IA01.3
Incremental Data     The Incremental Data Load field             IA100   IASV.1
Load                 specifies whether incremental data loads
                     are allowed for the specified data mart
                     type.

                     Valid values are:
                     Y = Yes
                     N = No

IAA-ALLOW-MOVE       Alpha 1                                     IA01.1  IA01.3
Move Window          The Allow Move field indicates whether      IA100   IASV.1
                     the Outline Dimension Move window is
                     accessible for this data mart type. The
                     Outline Dimension Move window lets you
                     specify the dimension that, in the
                     outline, precedes the dimension that you
                     are moving.

                     Valid values are:
                     Y = Yes
                     N = No; Default value.

IAA-DATA-LOAD-NAME   Alpha 12  (Lower Case)                      IA01.1  IA01.3
Data Source          The Data Source Name field contains the     IA100   IASV.1
                     unique name for the source containing
                     the data values you are loading. You can
                     define multiple data sources for a
                     single data mart. Examples of data
                     sources are programs or rules files.
                     This user-defined name can contain up to
                     12 characters of any kind.

                         APPLICTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAASET1   APPLIC-TYPE   This index is used to                    IA01.1  IA01.3
                                                                 IA05.1  IA05.3
                                                                 IA10.1  IA10.2
                                                                 IA100   IA11.1
                                                                 IA11.3  IA120
                                                                 IA13.1  IA15.1
                                                                 IA15.4  IA150
                                                                 IAAP.1  IAPF.1
                                                                 IASV.1  IASV.2

                         APPLICTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM

                            IAA-APPLIC-TYPE    -> ODB-APPLIC-TYPE
                                                  ODB-DATA-MART-NAME