|
|
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
AC87.1 CXA1.1 HC01.1 HC02.1 GL87.1 GL88.1
POA1.1 SAA1.1 WOA1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAA-APPLIC-TYPE Alpha 3
Data Mart Type The Application Type file stores the
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)
Description The Description field contains a
description of the data mart type.
IAA-DEFN-PROGRAM Alpha 5
Definition Program The Data Mart Setup Program field
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
Outline Load Program The Outline Build Program field
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
Data Values Load The Data Values Load program is the
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
Application Owner The Application Owner field specifies
the owner of the application that is
supplying data to the data mart.
Valid values are:
L = Lawson
U = User-defined
IAA-META-LOAD-PATH Alpha 2
Outline Load Path The Outline Build Path field specifies
the system responsible for delivering
the outline to the data mart. If IA is
specified, the outline build program
writes the outline to an ISAM file and
the Analytic Architect system builds the
outline using the information in this
file. If AP is selected, the outline
build program builds the outline
directly.
Valid values are:
IA = Analytic Architect system
AP = Data mart outline build program
IAA-META-INC-LOAD Alpha 1
Incremental Outline The Incremental Outline Load field
Build specifies whether incremental outline
builds are allowed for the specified
data mart type.
Valid values are:
Y = Yes
N = No
IAA-DATA-INC-LOAD Alpha 1
Incremental Data The Incremental Data Load field
Load specifies whether incremental data loads
are allowed for the specified data mart
type.
Valid values are:
Y = Yes
N = No
IAA-META-OVERRIDE Alpha 1
Outline Override The Outline Override field specifies
whether the data mart outline can be
overwritten when the data mart is built.
If overrides are allowed, the names of
the outline dimensions that are
specified on the IA11.1 (Data Mart
Profiles) form are the only dimensions
that are updated when the data mart is
built.
Valid values are:
Y = Yes
N = No; Default value.
IAA-DATA-OVERRIDE Alpha 1
Data Values Override This field is not currently being used.
Y = Yes
N = No
IAA-ALLOW-MOVE Alpha 1
Move Window The Allow Move field indicates whether
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)
Data Source The Data Source Name field contains the
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 AC87.1 CXA1.1
HC01.1 HC02.1
GL87.1 GL88.1
POA1.1 SAA1.1
WOA1.1
APPLICTYPE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Olapdbm OLAPDBM
IAA-APPLIC-TYPE -> ODB-APPLIC-TYPE
ODB-APPLIC-NAME
ODB-DATABASE-NAME
|