My users want to be able to apply an approval process to dimensional data.
Crucially they want the original version of the record to remain live until the change is approved.
I know that I can add an "approved" flag to the record and have this managed by a workflow, however with this technique the non-approved version of the record would be picked up when, say, SSAS processes.
Does MDS support approved and non-approved views of rows?
NB The data set in question is pretty large - we don't want to be creating seperate MDS Versions each time a change is made, unless there's a way to manage this efficiently.
When picking up data for SSAS processing, how are you doing it? If you are using the EntityMembersGet API you can use the SearchTerm property on MembersGetCriteria to filter out unapproved members based on the attribute value. If you are using a subscription
view, you can apply the same filter when selecting values from the view.
Let me know if this helps.
Arunjeet Singh (Microsoft SQL Server Master Data Services)
Wednesday, February 01, 2012 7:11 AM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.