Validate measure group data by using business logic
Two stored procedures are available to validate models: bsp_DI_ValidateMeasureGroupForModel validates the data for all the measure groups in a specified model, and bsp_DI_ValidateMeasureGroup validates the data in a specified measure group.
The following procedures describe how to use these stored procedures to validate data.
To validate all measure groups in a model
In the SQL Object Explorer, locate the Stored Procedures node under the Programmability node of the staging database.
Right-click dbo.bsp_DI_ValidateMeasureGroupForModel and then click Execute Stored Procedure.
In the Execute Procedure dialog box, enter the name of the model in the Value box for the @ModelName row.
Click OK.
To validate one measure group in a model
In the SQL Object Explorer, locate the Stored Procedures node under the Programmability node of the staging database.
Right-click dbo.bsp_DI_ValidateMeasureGroup and click Execute Stored Procedure.
In the Execute Procedure dialog box, enter the name of the model in the Value box for the @ModelName row.
In the Execute Procedure dialog box, enter the name of the measure group table in the Value box for the @SourceTable row.
Click OK.