About Data Movement jobs

In PerformancePoint Planning Business Modeler, a Data Movement job copies specified data from one model to another.

To perform the tasks in a Data Movement job, Planning Business Modeler requires a formal association between the two models. The association defines specific mappings between dimensions and members in the source model, and the dimensions and members in the destination model. For a roadmap of the process that is required to use an association, see How do I use an association to copy data between models?

To run an association in a Data Movement job, a person who is assigned to a Data Administrator role must first include the rule set in a Data Movement job template. Then, the administrator can run the job, or can assign the job to a specific user. For information about how to create a job template, see Create a job template. You can run, but cannot create, a Data Movement job from PerformancePoint Add-in for Excel.

Note: You cannot run two instances of a Data Movement job at the same time. To do so may cause both job instances to fail.

Properties for a Data Movement job

When you create a Data Movement job template, you must set values for the following job-specific properties.

Job property

Setting

Source Model Site

Specify the name of the model site that contains the source model. This value determines the available options for Source Model and Target Model Site.

Source Model

Specify the name of the model from which data will be copied. Note that this model must belong to the Source Model Site.

Target Model Site

Specify the name of the model site that contains the destination model. This value determines the available options for Target Model.

Target Model

Specify the name of the destination model to which data will be copied. Note that this model must belong to the Target Model Site.

Association

Specify the name of the association that is created between the source model and the target model.

Existing Data

Select Append to add new data, Scoped Replacement to refresh existing data, or Full Replacement to replace existing data with new data.

Validate

Select True to validate data integrity. Select False to indicate no validation.

Refresh Model Data

Select True to reprocess the destination model data after the association runs successfully. Select False to indicate that no reprocessing is required.

For information about how to run this job, see Define or schedule a job task.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×