I'm curious if there is a "best practice" for a slowly changing dimension within DynamicsCRM. Should we use SQL and data tools to monitor our online Dynamics instance to keep track of these values? Or create separate entities in DynamicsCRM that tracks these fields/attributes that we need to see historically (with begin/end dates, etc)?
Any advise or write-ups on the subject would be appreciated. I've struggled finding too terribly much through Google.
*This post is locked for comments