Google
 

Friday, July 25, 2008

Norm's PerformancePoint Server Blog : New Planning Data Migration Tool !

 

PerformancePoint Server 2007 Planning Data Migration Tool

There are two primary steps to a Migration, with many tedious “sub-steps”. 

The First step in the process is to Migrate the Application, this part of the process migrates:

  • Security roles
  • Structural metadata: all model site, model, dimension, and member set definitions
  • Data Sources and Data Destinations
  • Calculation rules and any associated job templates
  • Form templates
  • Calendar

The Second, (more tedious), step is to Migrate the Data, which accomplishes migrating the following:

  • Dimension and hierarchy data
  • Fact data and annotations
  • Associations

The “PerformancePoint Server 2007 Planning Data Migration Tool” automates the Second set of steps, the “Data Migration” portion.  The full manual process, (which requires the user to have intricate knowledge of the application), is documented in the TechNet Documentation located here:

  1. Preparing the Staging DB on the Source Server: http://technet.microsoft.com/en-us/library/bb838747.aspx
  2. Loading the Migrated Application on the Target Server: http://technet.microsoft.com/en-us/library/bb838692.aspx

Norm's PerformancePoint Server Blog : New Planning Data Migration Tool !

No comments: