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

CB590     IA01.1    IA01.3    IA100     IASV.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IAA-APPLIC-TYPE        Alpha 3                                   CB590   IA01.1
Data Mart Type         The Application Type file stores the      IA01.3  IA100
                       names of the Lawson applications that     IASV.1
                       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)                    CB590   IA01.1
Element: Description   The Description field contains a          IA01.3  IA100
                       description of the data mart type.        IASV.1

IAA-DEFN-PROGRAM       Alpha 5                                   CB590   IA01.1
Element: Definition ProThe Data Mart Setup Program field         IA01.3  IA100
                       contains the name of the program that     IASV.1
                       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                                   CB590   IA01.1
Data Values Load       The Data Values Load program is the       IA01.3  IA100
Program                program that the Analytic Architect       IASV.1
                       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                                   CB590   IA01.1
Element: Application OwThe Application Owner field specifies     IA01.3  IA100
                       the owner of the application that is      IASV.1
                       supplying data to the data mart.

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

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

                       Valid values are:
                       Y = Yes
                       N = No

IAA-ALLOW-MOVE         Alpha 1                                   CB590   IA01.1
Element: Move Window   The Allow Move field indicates whether    IA01.3  IA100
                       the Outline Dimension Move window is      IASV.1
                       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)                    CB590   IA01.1
Element: Data Source   The Data Source Name field contains the   IA01.3  IA100
                       unique name for the source containing     IASV.1
                       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                                            CB590   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