Row versioning and approval process

Question

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.

 

Answer 1

Hi James

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.

Regards

Arun

---

Arunjeet Singh (Microsoft SQL Server Master Data Services)