Step 4: Validating data in the staging database

Data validation helps make sure that your data is valid and ready for loading. The following list describes the validations that 规划服务器 performs.

• Make sure that the staging database defines relationships for any foreign keys that are required.

• Make sure that the dimension members and measure groups that are used in associated business rules are in the model.

规划服务器 performs this validation testing before it loads data from the staging database to the application database. To perform the validation, 规划服务器 creates stored procedures that perform the validations in the staging database, and runs those procedures at the appropriate time.

Validation occurs automatically when you load model data from 规划业务建模器. You can decide not to validate measure group data when you load by using the 规划命令实用工具 with the /novalidation switch. For more information see Scriptable data integration.

本节内容

• About performing dimension data validation
  Describes how to validate dimension data with the bsp_DI_ValidateDimension stored procedure.

• About performing hierarchy validation
  Describes how to validate the data in a specified hierarchy with the bsp_DI_ValidateHierarchy stored procedure, or how to validate the data in all hierarchies for a specified dimension with the bsp_DI_ValidateHierarchiesForADimensionstored procedure.

• About performing measure group validation in a model
  Describes how to validate the data in a specified measure group by using the bsp_DI_ValidateMeasureGroup stored procedure, or how to validate the data in all measure groups for a specified model with the bsp_DI_ValidateMeasureGroupForModel stored procedure.

相关章节

• 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 you must follow 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 you must follow to perform synchronization.

• Step 3: Populating the staging database
  Describes how to prepare data and structures for data loading.

• Step 5: Loading data from staging to application database
  Provides background information about dimensions and models, and describes the steps that you must follow to load data.

• 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.