Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPLICTYPE


                            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 40  (Lower Case)                    IA01.1  IA01.3
Element: Description   The Description field contains a          IA100   IASV.1
                       description of the data mart type.

IAA-DEFN-PROGRAM       Alpha 5                                   IA01.1  IA01.3
Element: Definition ProThe 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
Element: Outline Load PThe 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-EDIT-PROGRAM       Alpha 6                                   IA100
Element: Edit 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
Element: Application OwThe 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
Element: 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
Element: 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