About synchronizing dimensions and models

You must create a calendar in the current application in 规划业务建模器 before you synchronize data. Creating a calendar populates the Time dimension to which all models refer.

Consider the following when synchronizing models.

• Before you synchronize models save the model site.

• If you synchronize all models, the operation will affect only the models that are owned by the current site.

• If you synchronize all models in a subsite, only fact and reference data will be synchronized. Shared models that are created in another site will be ignored.

• Consider synchronizing models when model structures change.

• Models and related annotation tables are deleted. Synchronization will clean up the staging database of models and the related annotations.

重要：

When the model data volume grows bigger in the application database, the resource cost to synchronize the model also grows. It can be expensive and time-consuming to synchronize the model. To minimize large model data synchronization, skip the Synchronizing operation by only using the Insert operation when making your incremental data load from the source to the Staging database, thereby adding only new data. Do not use the Update or Delete data operation. If you need to use the Update and Delete operations for your incremental data load, you must use the Synchronizing Model operation every time you want to perform incremental model data load. You can skip the Synchronizing operation if your incremental data load for model is set to Insert only (no update and no delete).

To perform synchronization in 规划业务建模器 or by using the 规划命令实用工具, you must be a member of the Data Administrator role. For more information, see Security roles.

To make sure that a table is ready to load, we recommend that you synchronize the table first, even if the table is already in the staging database. Before you load data, do the following:

• Synchronize the dimensions for the related dimension and hierarchy tables.

• Synchronize the model for related measure group and annotation tables.

After you delete dimensions and models, make sure that you completely remove them by synchronizing them in 规划业务建模器.

• **Dimensions, related hierarchy tables, and related nested set tables in the staging base **  To remove these after you delete one or more dimensions in a model site, you must synchronize all dimensions in 规划业务建模器.

• A model and its related tables in the staging area   To remove these after you delete a model in a model site, you must synchronize all models in 规划业务建模器.

For each of these scenarios, the FK_Relationships table is also updated.

To learn more about other tables and columns that are added to the staging database during synchronization, see About the structure of the staging database.

This topic is included in the following downloadable book for easier reading and printing:

• Planning Server Planning and Architecture Guide for PerformancePoint Server 2007

See the full list of available books at Downloadable content for PerformancePoint Planning Server.

其他资源

Step 2: Synchronizing the staging database