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 Element: 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 Element: Data Mart Grp	Alpha 12	IA11.1 IA11.3 IASV.1
OLP-PROFILE-NAME Element: 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 Element: Description	Alpha 30 (Lower Case) The Description field contains a description of the profile.	IA11.3
OLP-CALC-OPTION Element: Calc Option	Alpha 1 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	IA11.1 IASV.1
OLP-CALC-SCRIPT Element: 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 Element: Outline Load Option	Alpha 1 The 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 Values Load Option	Alpha 1 The 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 Element: Data Stage Option	Alpha 1 The 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 Element: Active Status	Alpha 1 The Active Status field contains the status of the profile. Valid values are: A = Active I = Inactive	IASV.1
OLP-META-OVERRIDE Element: Outline Override	Alpha 1 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.	IASV.1
OLP-DATA-OVERRIDE Element: Data Values Override	Alpha 1 The 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 Element: Data Values Clear	Alpha 1 The 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 Element: Build Cube Opt	Alpha 1	IA11.3
OLP-PROC-CUBE-OPT Element: Proc Cube Opt	Alpha 1	IA11.3

OLAPPROF FILE INDEX

OLAPPROF FILE RELATIONS

ONE TO ONE RELATIONS

OLAPPROF FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.