更新: 2009-04-30

This Transact-SQL procedure creates a label-based hierarchy table for a specified hierarchy.


[ @RC = ] dbo.bsp_DI_CreateHierarchyLabelTable
@DimensionName = N'model_site_label:dimension_label' ,
@HierarchyTableName = N'hierarchy_table_name' 
[, [@IncludeExistingData = ] N'T' | N'F']


  • **@DimensionName** = N''model_site_label:dimension_label'
    Identifies the fully qualified name of the dimension. model_site_label:dimension_label is nvarchar(128). It has no default.
  • **@HierarchyTableName** = N'hierarchy_table_name'
    Identifies the name of the hierarchy table (H_). hierarchy_table_name is nvarchar(128). It has no default.
  • [ **@IncludeExistingData** = ] N'T' | N'F'
    Indicates whether to include existing data in the table. 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 and explicit execute permissions on the database object.


The example shows the creation of a label-based hierarchy table for H_Account_DetailAcct. The parameter, ASH_Corporate:Account, represents the model site label and dimension label. The resulting hierarchy table is H_Account_DetailAcct_Label.

USE [Alpine_Ski_House_StagingDB]
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_CreateHierarchyLabelTable]
     @DimensionName = N'ASH_Corporate:Account',
     @HierarchyTableName = N'H_Account_DetailAcct',
     @IncludeExistingData = N'T'
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.