About performing dimension data validation
업데이트: 2009-04-30
To perform validation on a single dimension before you load data from the staging database to the application database, run the bsp_DI_ValidateDimension Transact-SQL stored procedure.
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.