更新: 2009-04-30

This Transact-SQL procedure validates the data in a specified measure group table.


[ @RC = ] dbo.bsp_DI_ValidateMeasureGroup 
@ModelName = N'model_site_label:model_label' ,
@MeasureGroupTableName = N'measure_group_table_name'
[,[@IncludeAnnotation = ] N'T' | N'F']


  • **@ModelName** = N'model_site_label:model_label '
    The fully qualified identifier for the model consists of model_site_label:model_label and is nvarchar(128). It has no default. No special formatting is required for spaces in labels.
  • **@SourceTable** = N'measure_group_table_name'
    The name of the measure group table (MG_). measure_group_table_name is nvarchar(128). It has no default.
  • [ **@IncludeAnnotation** = ] N'T' | N'F'
    Indicates if annotations are included as part of measure group validation. T or F is nchar(1). The default is 'T'.

Return Value

Returns int value for an error code.


To run this procedure, you must have the fixed database roles of db_datareader and db_datawriter. You must also have explicit execute permissions on the database object.


This example shows the validation of data in measure group table, MG_External Corp Reporting_MeasureGroup_default_partition.

USE [Alpine_Ski_House_StagingDB]
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_ValidateMeasureGroup]
     @ModelName = N'ASH_Corporate:External Corp Reporting',
     @MeasureGroupTableName = N'MG_External Corp',
     @IncludeAnnotation = N'F'
SELECT 'Return Value' = @return_value

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.