Updated: 2009-04-30

The PerformancePoint data integration process moves data from a separate staging database to an application database in Planning Server, and then loads data into a model from which users work.

• Data integration overview

• Data integration configurations

• Step 1: Creating the staging database

• Step 2: Synchronizing the staging database

• Step 3: Populating the staging database

• Step 4: Validating data in the staging database

• Step 5: Loading data from staging to application database

• Scriptable data integration

• Troubleshoot data integration

The following are two video demonstrations of data integration presented by Forrest Dermid, one of Microsoft's senior technical solutions professionals.

• Demo about how to load dimension and hierarchy data from AdventureWorks

• Demo about how to prepare label-based measure group data

Download this book

See Also