Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OLAPPROF


                             OLAPPROF FILE

                           Data Mart Profiles

The Information Transfer Profiles (OLAPPROF) file stores the information for
each information transfer profile that is defined by the IA11.1 (Information
Transfer Profiles) program.

REFERENCED BY

IA120     IA150     IA16.1    IAPF.1

UPDATED BY

IA10.1    IA10.2    IA11.1    IA11.3    IASV.1    IASV.2


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

OLP-DATA-MART-GRP      Alpha 12                                  IA11.1  IA11.3
Element: Data Mart Grp                                           IASV.1

OLP-PROFILE-NAME       Alpha 12  (Lower Case)                    IA11.1  IA11.3
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.

OLP-DESCRIPTION        Alpha 30  (Lower Case)                    IA11.3
Element: Description   The Description field contains a
                       description of the profile.

OLP-CALC-OPTION        Alpha 1                                   IA11.1  IASV.1
Element: Calc Option   The Calc Option field determines
                       whether the data mart should be
                       completely calculated (Essbase Calc All)
                       after the outline is built and the data
                       values have been loaded.

                       Valid values are:
                       Y = Yes; Default value.
                       N = No

OLP-CALC-SCRIPT        Alpha 8  (Lower Case)                     IA11.1
Element: Calc Script   The Calc Script field determines how
                       the OLAP data mart is calculated. If a
                       calc script has been defined, type the
                       name of the script in this field. If Y
                       (Yes) is specified in the the Calc All
                       field, the calc script is performed
                       after the data mart has been calculated
                       completely. If N (No) is specifed in the
                       Calc All field, and no calc script is
                       specifed, the data mart is not
                       calculated. To perform the default calc
                       script that is used by the OLAP data
                       mart, leave this field blank.

                       This user-defined field can contain up
                       to eight alphanumeric characters.

OLP-META-DATA-OPT      Alpha 1                                   IA11.1  IA11.3
Element: Outline Load OThe Outline Build field specifies how     IASV.1
                       the outline is built.

                       Value values are:
                       N = No Build
                       I = Incremental Build
                       C = Complete Build; Default value.
                       U = UDAs and Alias Names Only
                       Y = Update

OLP-DATA-LOAD-OPT      Alpha 1                                   IA11.1  IA11.3
Data Values Load       The Data Values Load Option field         IASV.1
Option                 specifies how the data values are loaded
                       into the data mart.

                       Value values are:
                       N = No Load
                       I = Incremental
                       C = Complete; Default value.

OLP-STAGE-OPTION       Alpha 1                                   IA11.1  IASV.1
Element: Data Stage OptThe Data Values Staging Option field
                       determines whether the data mart remains
                       active for users while new data is being
                       loaded. If the stage option is set to Y
                       (Yes), data is loaded in a temporary
                       data mart and copied back to the
                       original data mart upon completion. To
                       stage the data load process, there must
                       be enough disk space to support both the
                       original data mart, as well as the
                       temporary data mart, even though the
                       temporary data mart is deleted after it
                       has been copied back to the original
                       data mart.

                       Valid values are:
                       Y = Yes
                       N = No; Default value.

OLP-ACTIVE-STATUS      Alpha 1                                   IASV.1
Element: Active Status The Active Status field contains the
                       status of the profile.

                       Valid values are:
                       A = Active
                       I = Inactive

OLP-META-OVERRIDE      Alpha 1                                   IASV.1
Element: Outline OverriThe 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.

OLP-DATA-OVERRIDE      Alpha 1                                   IASV.1
Element: Data Values OvThe Data Override field specifies
                       whether the data values can be
                       overwritten when the data mart is
                       loaded.

                       Valid values are:
                       Y = Yes
                       N = No; Default value.

OLP-CLEAR-DATABASE     Alpha 1                                   IA11.1  IASV.1
Element: Data Values ClThe Data Values Clear Option field
                       determines whether the data mart should
                       be cleared prior to updating it. This
                       value does not apply if

                       - the data load option is set to I
                       (incremental load),
                       - the data load option is set to N (no
                       load),
                       - the data values staging option is set
                       to Y (Yes), and
                       - external data sources have been
                       specified.
                       Y = Yes
                       N = No

OLP-BUILD-CUBE-OPT     Alpha 1                                   IA11.3
Element: Build Cube Opt

OLP-PROC-CUBE-OPT      Alpha 1                                   IA11.3
Element: Proc Cube Opt

                         OLAPPROF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OLPSET1   DATA-MART-NAMEKeyChange                                IA10.1  IA10.2
          DATA-MART-GRP                                          IA11.1  IA11.3
          PROFILE-NAME                                           IA120   IA150
                                                                 IA16.1  IAPF.1
                                                                 IASV.1  IASV.2

                         OLAPPROF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Olapdbm        OLAPDBM      Not Required

                            OLP-DATA-MART-NAME    -> ODB-DATA-MART-NAME

                         OLAPPROF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Profdatrel     PROFDATREL

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