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
|