更新: 2009-04-30

This Transact-SQL procedure validates the data in a specified dimension.


[ @RC = ] dbo.bsp_DI_ValidateDimension 
[ @DimensionName = ] N'model_site_label:dimension_label',
[ @CurrentSiteName = ] N'current_site_name'


  • [ **@DimensionName** = ] N'model_site_label:dimension_label'
    The fully qualified name of the dimension. model_site_label:dimension_label is nvarchar(128). It has no default.
  • [ **@CurrentSiteName** = ] N'current_site_name'
    The label of the current site name. current_site_name is nvarchar(128). It has no default.

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.


The current model site name is the context in which you are validating a dimension. If you are validating a dimension from the model subsite, resortmgt, and you try to delete a row where the RowID is equal to 0 (root site) or subsite (greater than 0), validation will give you an error.


This example shows the dimension, Product, represented by label name, validated.

USE [Alpine_Ski_House_StagingDB]
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_ValidateDimension]
     @DimensionName = N'Ash_Corporate:Product',
     @CurrentSiteName = N'Ash_Corporate'
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.