About Data Load jobs
The Data Load job allows data to be synchronized with the staging database or loaded to the application database. This job can be launched, but cannot be created, from PerformancePoint Add-in for Excel.
Templates and properties
If you selected the DimensionLoad template for this job, you must set the following properties to run the job:
Job property name | Description |
---|---|
Model Site |
The model site on which to run the selected data load job. The value that you can select for the remaining properties will vary based on the model site you select here. |
Load Operation |
Select either synchronize or load. |
Target Dimension |
Name of the dimension in the model site for which data is being synchronized or to which data is being loaded. |
Validate |
Select True to indicate that referential integrity validation is performed and only valid data is loaded, False to indicate no validation. This option is only available if you select Load for the Load Operation property. For this option, you may select either True or False. |
Refresh Model Data |
Select True to indicate that model is reprocessed after the data load has run, False to indicate no reprocessing. This is available only if you select Load for the Load Operation property. |
If you selected the ModelLoad template for this job, you must set the following properties to run the job:
Job property name | Description |
---|---|
Model Site |
The model site on which to run the selected data load job. The value that you can select for the remaining properties will vary based on the model site you select here. |
Load Operation |
Select either synchronize or load. |
Target Model |
Name of the model for which data is being synchronized or to which data is being loaded. |
Validate |
Select True to indicate that referential integrity and business validation are performed and only valid data is loaded, False to indicate no validation. This option is only available if you select Load for the Load Operation property. For this option, you may select either True or False. |
Unsigned Values |
Indicates if model data should be converted to unsigned data during the data load. |
Refresh Model Data |
Select True to indicate that model is reprocessed after the data load has run, False to indicate no reprocessing. This is available only if you select Load for the Load Operation property. |