locked
MDS Action -- Discard changes? RRS feed

  • Question

  • When a record fails validation, the default setting is to keep the changes. If you are using MDS for reference data and someone tries to make an invalid change and they don't remember what the previous value was or they just don't fix the record then any views that utilize the ValidationStatus column will drop the newly failed records that may have previously been fine.

    For reference data this isn't good. You can't just have records drop out of your reference set because a validation failed, you should only have the attempted change drop out.

    I've looked but there doesn't seem to be a "Discard changes" action in the business rules. Is there another way to do this?

    This is in 2012

    Thursday, August 8, 2013 8:50 PM

Answers

  • MDS does not directly support a publishing model of "last known good" version for each entity member.  It also doesn't support type2 Slowly-Changing Dimensions. 

    To implement these patterns it's common to create a separate database on the MDS back-end server to publish your entities.  You would run a frequent job to perform a TSQL MERGE from the subscription view to the target table.  This also enables you to publish only the important (canonical) attributes of an entity.  You can map (code/name) to other column names and omit attributes used for data stewardship, like approval status and change date, etc.  And it gives you very fine-grain control over the performance of your reference data lookups.

    David


    David http://blogs.msdn.com/b/dbrowne/



    Thursday, August 8, 2013 10:03 PM