Prepare label-based measure group data
This topic provides instructions for using stored procedures to create label-based tables and then convert them back to ID-based tables. This process can help you prepare measure group data for loading.
For each manual process, 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 procedure helps you prepare label-based data.
To prepare and load measure group data that have labels
Create a label-based table
Populate label-based measure group tables with data from the source database or system. This is a manual step.
Validate label-based measure group tables and correct any errors by using the bsp_DI_ValidateLabelTable stored procedure.
Repeat step 3 as required until all label-based data is valid.
Convert a label-based measure group table to a MemberID-based table
For a specified label-based measure group table, use the bsp_DI_ConvertLabelColumnToMemberIDForMeasureGroup stored procedure.
For all label-based measure group tables in a specified model, use the bsp_DI_ConvertLabelColumnToMemberIDForModel stored procedure.