bsp_DI_CreateLabelTableForMeasureGroup
更新： 2009-04-30
This Transact-SQL procedure creates a label-based table for the specified measure group table.
Syntax
[ @RC = ] dbo.bsp_DI_CreateLabelTableForMeasureGroup
@ModelName = N'model_site_label:model_ label' ,
@MeasureGroupTableName = N'measure_group_table_name'
[,[ @IncludeExistingData = ] N'T' | N'F']
Arguments
- @ModelName = N'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.
- @MeasureGroupTableName = N'measure_group_table_name'
The name of the measure group table (MG_). measure_group_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.
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 how to create a label-based table, MG_Manufacturing_Bike Components_MeasureGroup_default_partition, for data preparation.
USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_CreateLabelTableForMeasureGroup]
@ModelName = N'Manufacturing:Bike Components',
@MeasureGroupTableName = N'MG_Manufacturing_Bike Components_MeasureGroup_default_partition',
@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.