Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Show:
© 2015 Microsoft