Data Warehouse

Have You Built Your Audit Dimension Yet?

One of the most effective tools for managing data quality and data governance, as well as giving business users confidence in the data warehouse results, is the audit dimension. We often attach an audit dimension to every fact table so that business users can choose to illuminate the provenance and confidence in their queries and reports. Simply put, the audit dimension elevates metadata to the status of ordinary data and makes this metadata available at the top level of any BI tool user interface.

via Design Tip #164 Have You Built Your Audit Dimension Yet? – Kimball Group.