Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROFDATREL


                            PROFDATREL FILE

                          Profile Data Source

The Profile Data Sources (PROFDATAREL) file contains information about the
data source that is used with the information transfer profile indicated.

REFERENCED BY

IA120     IA150     IA13.1

UPDATED BY

IA10.1    IA10.2    IA11.1    IA16.1    IASV.1    IASV.2


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PFL-DATA-MART-NAME     Alpha 20  (Lower Case)                    IA11.1  IA16.1
Element: Data Mart NameThis field contains the name of the data  IASV.1
                       mart.

PFL-PROFILE-NAME       Alpha 12  (Lower Case)                    IA11.1  IA16.1
Element: Profile Name  The Profile name field contains the       IASV.1
                       name of the profile that is defined in
                       the IA11.1 (Information Transfer
                       Profiles) form. Each profile name
                       represents a run option that is used
                       when the data mart is updated. Run
                       options include the name of the calc
                       script, the outline load and data values
                       load options no load, incremental or
                       complete), and the names of the outline
                       dimensions to include in the build. This
                       user-defined field can contain up to 12
                       characters.

PFL-DATA-LOAD-NAME     Alpha 12  (Lower Case)                    IA11.1  IA16.1
Element: Data Load NameThe Data Source Name field contains the   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.

                         PROFDATREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PFLSET1   DATA-MART-NAMEKeyChange                                IA10.1  IA10.2
          PROFILE-NAME                                           IA11.1  IA120
          DATA-LOAD-NAME                                         IA150   IA16.1
                                                                 IASV.2

PFLSET2   DATA-MART-NAMEKeyChange                                IA13.1
          DATA-LOAD-NAME
          PROFILE-NAME

                         PROFDATREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Datasource     DATASOURCE   Required

                            PFL-DATA-MART-NAME    -> DAT-DATA-MART-NAME
                            PFL-DATA-LOAD-NAME    -> DAT-DATA-LOAD-NAME

Olapdbm        OLAPDBM      Required

                            PFL-DATA-MART-NAME    -> ODB-DATA-MART-NAME

                         PROFDATREL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapprof       OLAPPROF

                            PFL-DATA-MART-NAME    -> OLP-DATA-MART-NAME
                                                     OLP-DATA-MART-GRP
                                                     OLP-PROFILE-NAME