OLAPPROF – Data Mart Profiles

System
Analytic Architect (IA)
Prefix
OLP
Primary key
DATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME
Fields
15
Updated by
6 programs
Referenced by
4 programs

OLAPPROF is the Data Mart Profiles table in Lawson Analytic Architect (prefix OLP). It is indexed by DATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME (OLPSET1). It is related 1:1 to OLAPDBM and 1:M to PROFDATREL. It is updated by IA10.1, IA10.2, IA11.1, IA11.3, IASV.1 and IASV.2 and referenced by IA120, IA150, IA16.1 and IAPF.1. The table has 15 fields, 1 index and 2 documented relations.

About OLAPPROF

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.

Fields (15)

Column = COBOL field name without the OLP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OLP-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA11.1, IA11.3, IASV.1
OLP-DATA-MART-GRP PK
DATA_MART_GRP		Alpha 12—IA11.1, IA11.3, IASV.1
OLP-PROFILE-NAME PK
PROFILE_NAME		Alpha 12 (Lower Case)The Profile name field contains the 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.IA11.1, IA11.3, IASV.1
OLP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The Description field contains a description of the profile.IA11.3
OLP-CALC-OPTION
CALC_OPTION		Alpha 1The 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
IA11.1, IASV.1
OLP-CALC-SCRIPT
CALC_SCRIPT		Alpha 8 (Lower Case)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.IA11.1
OLP-META-DATA-OPT
META_DATA_OPT		Alpha 1The Outline Build field specifies how 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
IA11.1, IA11.3, IASV.1
OLP-DATA-LOAD-OPT
DATA_LOAD_OPT		Alpha 1The Data Values Load Option field specifies how the data values are loaded into the data mart. Value values are:
  • N No Load
  • I Incremental
  • C Complete; Default value.
IA11.1, IA11.3, IASV.1
OLP-STAGE-OPTION
STAGE_OPTION		Alpha 1The 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.
IA11.1, IASV.1
OLP-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The Active Status field contains the status of the profile. Valid values are:
  • A Active
  • I Inactive
IASV.1
OLP-META-OVERRIDE
META_OVERRIDE		Alpha 1The 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.
IASV.1
OLP-DATA-OVERRIDE
DATA_OVERRIDE		Alpha 1The 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.
IASV.1
OLP-CLEAR-DATABASE
CLEAR_DATABASE		Alpha 1The 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
IA11.1, IASV.1
OLP-BUILD-CUBE-OPT
BUILD_CUBE_OPT		Alpha 1—IA11.3
OLP-PROC-CUBE-OPT
PROC_CUBE_OPT		Alpha 1—IA11.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OLPSET1DATA-MART-NAME, DATA-MART-GRP, PROFILE-NAMEPrimary, KeyChangeIA10.1, IA10.2, IA11.1, IA11.3, IA120, IA150, IA16.1, IAPF.1 +2 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OlapdbmOLAPDBMNot RequiredOLP-DATA-MART-NAME → ODB-DATA-MART-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
ProfdatrelPROFDATRELOLP-DATA-MART-NAME → PFL-DATA-MART-NAME, OLP-PROFILE-NAME → PFL-PROFILE-NAME, → PFL-DATA-LOAD-NAME

Programs

Updated by (6)

Referenced by (4)