bsp_DI_ConvertLabelColumnToMemberIDForModel
업데이트: 2009-04-30
This Transact-SQL procedure converts all label-based tables that are associated with a model to ID-based tables.
Syntax
[ @RC = ] dbo.bsp_DI_ConvertLabelColumnToMemberIdForModel
@ModelName = N'model_site_label:model_label'
[,[ @OverwriteExistingData = ] N'T' | N'T']
[,[ @IncludeValidation = ] N'T' | N'T']
[,[ @IncludeAnnotation = ] N'T' | N'T']
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.
[ @OverwriteExistingData = ] N'T' | N'F'
Indicates whether to overwrite existing data in the table. T or F is nchar(1). The default is 'T'.If you mistakenly overwrite data, synchronize the data in Planning Business Modeler and then run this stored procedure again with F as a parameter.
- [ @IncludeValidation = ] N'T' | N'F'
Indicates whether to validate data when you finish converting the tables in the model. T or F is nchar(1). The default is 'F'.
- [ @IncludeAnnotation = ] N'T' | N'F'
Indicates if annotations are included as part of measure group table conversion. 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 the conversion of a label-based table back to an ID-based table in preparation for loading to the application database.
USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_ConvertLabelColumnToMemberIDForModel]
@ModelName = N'Ash_Corporate:Corporate Costs',
@OverwriteExistingData = N'T',
@IncludeValidation = N'T'
.....@IncludeAnnotation = N'T'
GO
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.