bsp_DI_ConvertHierarchyLabelColumnToMemberIdForDimension
更新： 2009-04-30
This Transact-SQL procedure converts a label-based table to an ID-based table for all hierarchies that belong to a specified dimension.
Syntax
[ @RC = ] dbo.bsp_DI_ConvertHierarchyLabelColumnToMemberIDForDimension
@DimensionName = N'model_site_label:dimension_ name_label'
[,[ @OverwriteExistingData = ] N'T' | N'F']
Arguments
- @DimensionTableName = 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.
- [ @OverwriteExistingData = ] N'T' | N'F'
Indicates whether to overwrite 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. You must also have explicit execute permissions on the database object.
Example
This example shows the conversion of label-based data back to ID-based data. The existing dimension tables, associated with dimension D_Entity, are populated with the correct MemberId. The ID-based tables created include the following:
H_Entity_CorpMgmtEnt
H_Entity_DetailEnt
H_Entity_LegalEnt
H_Entity_MfgEnt
H_Entity_ResortEnt
USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_ConvertHierarchyLabelColumnToMemberIdForDimension]
@DimensionName = N'ASH_Corporate:D_Entity',
@OverwriteExistingData = 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.