bsp_DI_ConvertHierarchyLabelColumnToMemberId
更新： 2009-04-30
This Transact-SQL procedure converts labels to MemberIDs for a specified hierarchy.
Syntax
[ @RC = ] dbo.bsp_DI_ConvertHierarchyLabelColumnToMemberId
@DimensionName = N'model_site_label:dimension_label' ,
@HierarchyTableName = N'hierarchy_table_name'
[,[ @OverwriteExistingData = ] N'T' | N'F ]
Arguments
- @DimensionName = N'model_site_label:dimension_label'
The fully qualified name of the dimension. dimension_name is nvarchar(128). It has no default.
- @TableName = N'hierarchy_table_name'
The name of the label-based hierarchy table (H_*_label). hierarchy_table_name is nvarchar(128). It has no default.
[ @OverwriteExistingData = ] N'T' | N'F'
Indicates whether to overwrite existing data. T | F is nchar(1). The default is 'T'.If you mistakenly overwrite data, synchronize the data in 规划业务建模器 and run this stored procedure again with F as a parameter.
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
The example shows the conversion of labels in a label-based hierarchy to MemberIDs for hierarchy table H_Account_DetailAcct. The parameter, ASH_Corporate:Account, represents the model site label and the dimension label. The resulting table is populated with MemberId values that are based on the table H_Account_DetailAcct_Label.
USE [Alpine_Ski_House_StagingDB]
GO
DECLARE @return_value INT
EXEC @return_value = [dbo].[bsp_DI_ConvertHierarchyLabelColumnToMemberId]
@DimensionName = N'ASH_Corporate:Account',
@HierarchyTableName = N'H_Account_DetailAcct',
@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.