How do I use an association to copy data between models?

In PerformancePoint Planning Business Modeler, you can define and then use an association to copy data from a source model to a destination model. An association specifies not only the mapping between two models, but also between their dimensions and dimension members. By using an association, you can be very precise about which source data is copied, how the data is aggregated, and to what destination you copy the data. In addition, when you create an association between models, you can use a Data Movement job to update the destination model whenever data in the source model changes.

  How analysts use an association

  • Analysts can use an association to contribute source data to a larger model for reporting or consolidation. For example, a business user might create a local model for analysis and planning, and then provide the outcomes of the analysis to the corporate model.

  • Analysts can use an association to select a segment of a larger model, and then use the segment as a new, self-standing model. For example, a planner might select elements of a corporate model to create a model that represents only a segment of the business. Then, the planner can distribute such segments to the subsidiary divisions that are most concerned with the identified segments.

  • Analysts can use an association to select a segment of a larger model, and then integrate the segments into another large model. For example, a forecaster might create a "what-if" model to determine the impact that a local event might have on the entire company.

Use this procedure as a step-by-step guide to help you create an association, map dimensions and members, and then run the association.

What do you want to do?

Step 1: Prepare to copy the data

Step 2: Configure the model, dimension, and member associations

Step 3: Run the association

Step 1: Prepare to copy the data

Task

Description

Verify user permissions

To define an association, you must have Modeler or Data Administrator permissions at both the source model site and the destination model sites.
To run an association, you must have Data Administrator permissions at both the source model site and the destination model sites.

Determine dimension mappings

Gather detailed information that you can use to specify the mappings between dimension members. For example, identify the specific members and member sets that you want to copy to the destination model. In addition, determine what type of aggregation you want to use between member associations.

Specify models

Identify the source model and destination model that you want to associate. If the destination model does not exist, create a new model.

Share required dimensions

If a single model site owns both the source model and the destination model, PerformancePoint Planning Business Modeler configures dimension sharing automatically.

Otherwise, before you can copy dimensions and dimension members from one model to another, you must configure dimension sharing in the source dimension explicitly. To learn how to do this, see Share a dimension.

Top of Page

Step 2: Configure the model, dimension, and member associations

Task

Description

Open a model

To create dimension and model associations, you must open the model site.

Create the model association

When you configure a model association, you make it possible to associate the model dimensions and dimension members.

Create a dimension association

After you create a model association, you are ready to specify associations between their dimensions.

Top of Page

Step 3: Run the association

Task

Description

Run an association

To run an association, create and configure a data movement job.

Top of Page

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!

×