Data Sets and Business Logic

Be careful building out datasets.  When a business starts growing report requirements multiple datasets will be needed to fulfill these requirements.  A challenge is building the business logic into all datasets in which the business logic affects.  If the new\updated logic is not maintained across all datasets your reports will be off.

I think it may be challenging for non-IT people to see this or challenging for IT people to explain the impact of changing business rules and processes.  Ah….good old Change Management not only across IT systems, but business processes.