Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            DATASOURCE FILE

                              Data Source

The Data Source (DATASOURCE) file contains information about the data source
used for loading the data mart. The information in this file comes from IA13.1
(Data Load Sources).

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DAT-DATA-MART-NAME   Alpha 20  (Lower Case)
Data Mart Name

DAT-DATA-LOAD-NAME   Alpha 12  (Lower Case)
Data Source Name     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.

DAT-DATA-PROGRAM     Alpha 6
Data Load Program    The Data Values Load program is the
                     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.

DAT-DATA-FORMAT      Alpha 1
Data Load Format     The Data Load Format field contains the
                     format of the data source.

                     Valid values are:
                     1 = Program load; Default value.
                     2 = Rules File load

DAT-DATA-PATH-NAME   Alpha 100  (Lower Case)
Data Source File     The Data Source File field contains the
                     name of the data source file.

                     If a data load program has been
                     specified in the Data Load Program
                     field, the output of the data load
                     program is placed in the data source
                     file using the path specified in the CSV
                     Output Path field in IA100 (Data Mart
                     Type Load).

                     If a rules file is used, the source of
                     the data being loaded into the data mart
                     is the data source file. Both the rules
                     file and the data source file must be
                     placed in the $ARBORPATH/app/application
                     name/database path before using IA120
                     (Data Mart Load).

DAT-RULES-FILE       Alpha 100  (Lower Case)
Rules File           The Rules File field contains file name
                     of the rules file to be used by the data
                     mart. If a rules file is used, the data
                     source is the file specified in the Data
                     Source File field. The rules file is
                     responsible for loading the data source
                     file into the data mart. Both the rules
                     file and the data source file must be
                     placed in the $ARBORPATH/app/application
                     name/database path before using IA120
                     (Data Mart Load).

DAT-FILE-FORMAT      Alpha 1
Text File Format     The File Format field contains the
                     value that indicates the layout of the
                     text file when a data load program is
                     used to create a text file.

                     Valid values are:
                     Blank or spaces = Unused. The target
                     destination of the data load program is
                     the data mart.
                     R = CSV file contains Members of a data
                     value defined in a row.
                     P = CSV file contains page and column
                     headers generated by the data load
                     program; Default value.
                     " " = Unused

DAT-DATA-BUILD-DTE   Numeric 8  (yyyymmdd)
Data Load Date       The Data Load Date field contains the
                     most recent date that the OLAP data mart
                     was populated with data values. The date
                     format used is YYYYMMDD.

DAT-DATA-BUILD-TME   Numeric 6  (hhmmss)
Data Load Time       The Data Load Time field contains the
                     most recent time that the OLAP data mart
                     was populated with data values. The time
                     format used is HHMMSS.

                         DATASOURCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DATSET1   DATA-MART-NAMEKeyChange
          DATA-LOAD-NAME

DATSET2   DATA-LOAD-NAMEKeyChange
          DATA-MART-NAME

                         DATASOURCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM      Required

                            DAT-DATA-MART-NAME    -> ODB-DATA-MART-NAME  (ODBSET1)

                         DATASOURCE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Dimdatarel     DIMDATAREL

                            DAT-DATA-MART-NAME    -> DDR-DATA-MART-NAME
                            DAT-DATA-LOAD-NAME    -> DDR-DATA-LOAD-NAME
                                                     DDR-USER-DIM-NAME