• 项目

bsp_DI_CreateLabelTableForDimension

更新： 2009-04-30

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

Syntax

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

Arguments

  • @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.

  • [ @IncludeExistingData = ] N'T' | N'F'
    Indicates whether to include existing data in the table. T | 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. In addition, you must have explicit execute permissions on the database object.

Example

This example creates a label-based dimension table, D_Product_Label, for the specified dimension, ASH_Corporate:Product, in the staging database.

USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[bsp_DI_CreateLabelTableForDimension]
     @DimensionName = N'ASH_Corporate:Product',
     @IncludeExistingData = N'T'
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.

另请参阅