bsp_DI_ValidateHierarchy

更新: 2009-04-30

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

Syntax

[ @RC = ] dbo.bsp_DI_ValidateHierarchy 
[ @CurrentSiteName = ] N'current_site_label' ,
@HierarchyTableName = N'hierarchy_table_name'

Arguments

  • [ **@CurrentSiteName** = ] N'current_site_label'
    The label of the current site name. current_site_label is nvarchar(128). It has no default.
  • @HierarchyTableName** = N'hierarchy_table_name'
    The name of the hierarchy table (H_). hierarchy_table_name is nvarchar(128)
    .** It has no default.

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 validation of data in the hierarchy table H_Product_Bicycles.

USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[bsp_DI_ValidateHierarchy]
     @HierarchyTableName = N'H_Product_Bicycles',
     @CurrentSiteName = N'Ash_Corporate'
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.

另请参阅