Step 5: Loading data from staging to application database

PerformancePoint Server 2007

The final data integration step is to load the data from the staging database to the application database. When you load data, dimension and hierarchy data that has changed in 规划业务建模器 is synchronized from the application database to the staging database.

注意注意:

Dimension and hierarchy data must be loaded before you can load model data.

You must be a member of the Data Administrator role to load data. For more information, see Security roles.

本节内容

About loading dimensions

Important considerations when you load dimension data.

Load dimension data

Learn how to load dimension and hierarchy data.

About loading models

Important considerations when you load model data.

Load model data

Learn how to load model data.

相关章节

Data integration overview

Provides an overview of the architecture of the 规划服务器 data integration system and of the data load processes.

Data integration configurations

Describes different configurations that you can use for security and performance.

Step 1: Creating the staging database

Provides background information about the organization of the staging database, and describes the steps that are required to create it.

Step 2: Synchronizing the staging database

Provides background information about how 规划服务器 synchronizes the structures and data of each database, and describes the steps that are required to perform synchronization.

Step 3: Populating the staging database

Describes how to prepare data and structures for data loading.

Step 4: Validating data in the staging database

Describes the procedures that validate data in the staging database, and describes the steps that are required to run the procedures.

Scriptable data integration

Describes the commands in the 规划命令实用工具 that you can use to write a script that performs data integration steps.

Troubleshoot data integration

Provides detailed reference information about error codes.

显示: