About performing hierarchy validation
You can use one of the following methods to validate one or more hierarchies before you load data from the staging database to application database:
Validate a single hierarchy by running the Transact-SQL stored procedure, bsp_DI_ValidateHierarchy.
Validate all hierarchies for a given dimension by running the Transact-SQL stored procedure, bsp_DI_ValidateHierarchiesForADimension
For each row that is not valid, the procedure sets the BizSystemFlag column to a 900+ value. The BizSystemErrorDetails column indicates the location of the values to which the error code applies.
If the validation reports errors, you must fix the errors before you load data to the application database. After you fix the errors, reset the BizSystemFlag value to 200, and run the validation procedure again. To learn more about validation errors, see BizSystemFlag errors.
You can decide not to validate data when you load a database by using the 规划命令实用工具 with the /novalidation switch. For more information, see Scriptable data integration.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for PerformancePoint Planning Server.