An interface would be good for stuff like this.
Two approaches exist for converting to label-based tables in preparation for populating PerformancePoint Server measure group tables.
- Use PPS stored procs - more of a production solution
- Use a join with source and staging and pull id's.
Here are the steps from the data integration help.
To prepare and load measure group data that have labels
Create a label-based table
For a specified measure group, use the bsp_DI_CreateLabelTableForMeasureGroup stored procedure.
For all measure group tables in a specified model, use the bsp_DI_CreateLabelTableForModel stored procedure.
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.
About performing measure group validation in a model
You can use one of the following methods to validate measure groups before you load data from the staging database to the application database.
Validate data in a specified measure group by executing the Transact-SQL stored procedure, bsp_DI_ValidateMeasureGroup.
Validate all measure groups for a specified model by executing the Transact-SQL stored procedure, bsp_DI_ValidateMeasureGroupForModel.
Note
If you have questions about the process, don't forget to use the PerformancePoint Server forum. You can also send me a message if you are concerned about if a question is phrased correctly -I'm a writer.
No comments:
Post a Comment