bsp_DI_ValidateMeasureGroupForModel
Actualizado: 2009-04-30
This Transact-SQL procedure validates the data for all the measure groups in a specified model.
Syntax
[ @RC = ] dbo.bsp_DI_ValidateMeasureGroupForModel
@ModelName = 'model_site_label:model_label'
[,[@IncludeAnnotation = ] N'T' | N'F']
Arguments
- @ModelName = '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.
- [ @IncludeAnnotation = ] N'T' | N'F'
Indicates if annotation 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.
Permissions
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.
Example
This example shows the validation of data in all measure group tables that are in the fully qualified model name, ASH_Corporate:External Corp Reporting.
USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[bsp_DI_ValidateMeasureGroupForModel]
@ModelName = N'ASH_Corporate:External Corp Reporting',
@IncludeAnnotation = N'F'
SELECT 'Return Value' = @return_value
GO
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.