Validate measure group data by using business logic

PerformancePoint Server 2007

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

  1. In the SQL Object Explorer, locate the Stored Procedures node under the Programmability node of the staging database.

  2. Right-click dbo.bsp_DI_ValidateMeasureGroupForModel and then click Execute Stored Procedure.

  3. In the Execute Procedure dialog box, enter the name of the model in the Value box for the @ModelName row.

  4. Click OK.

To validate one measure group in a model

  1. In the SQL Object Explorer, locate the Stored Procedures node under the Programmability node of the staging database.

  2. Right-click dbo.bsp_DI_ValidateMeasureGroup and click Execute Stored Procedure.

  3. In the Execute Procedure dialog box, enter the name of the model in the Value box for the @ModelName row.

  4. In the Execute Procedure dialog box, enter the name of the measure group table in the Value box for the @SourceTable row.

  5. Click OK.

显示: