Prepare label-based data for hierarchies
This topic provides instructions for using stored procedures to create label-based tables and converting label-based tables back to ID-based tables. These processes can help you load data from one or many business data sources into an application database.
For each manual process for populating data, data administrators must use their existing tool set. This includes the use of Transact-SQL scripts, SQL Server Integration Services (SSIS) packages, or custom code to populate the staging area database.
The following procedures help you prepare data that is based on labels.
To prepare hierarchy data that has labels
Create a label-based hierarchy table.
For a specified hierarchy, use the bsp_DI_CreateHierarchyLabelTable stored procedure.
For all hierarchies that are in a specified dimension, use the bsp_DI_CreateHierarchyLabelTableForDimension stored procedure.
Populate label-based hierarchy tables with data from the source database or system. This is a manual step.
Convert label-based hierarchy tables to ID-based hierarchy tables.
For a specified hierarchy, use the bsp_DI_ConvertHierarchyLabelColumnToMemberId stored procedure.
For all hierarchies in a specified dimension, use the bsp_DI_ConvertHierarchyLabelColumnToMemberIdForDimension stored procedure.