OLAPPROF

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


UPDATED BY
IA10.1 IA10.2 IA11.1 IA11.3 IASV.1 IASV.2
IA16.1 IAPF.1

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OLPSET1 DATA-MART-NAME
DATA-MART-GRP
PROFILE-NAME
KeyChange
IA10.1 IA10.2
IA11.1 IA11.3
IA120 IA150
IA16.1 IAPF.1
IASV.1 IASV.2


OLAPPROF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:49:34 2016

Home
Contact Us



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