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 Planning Server 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.
Planning Server performs this validation testing before it loads data from the staging database to the application database. To perform the validation, Planning Server 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 Planning Business Modeler. You can decide not to validate measure group data when you load by using the Herramienta de comando de planeación with the /novalidation switch. For more information see Scriptable data integration.
En esta sección
- 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.