How can you trust the numbers in your BI report if you don’t know where they came from or how they were computed? Compliance requirements (such as Sarbanes-Oxley and Basel II) mandate that organizations be held accountable for their financial information. As a result, the need to trace data to its origin is now a critical BI function. IBM® InfoSphere™ Metadata Workbench is one of the product that I use quite often. It provides this Web-based data lineage.
I was working with a customer that used datastage as ETL tool and SAP BW as Business Warehouse. We performed well except for importing, viewing and displaying data lineage over the SAP Business Warehouse metadata. The data lineage was not seen as this challenge is all pervasive – “Every data source, BI tool, and ETL tool contains its own metadata, and they do not talk to one another”. We enabled and demonstrated the import of the SAP cube metadata using metabrokers and bridges.
InfoSphere Metadata Workbench helped support of information governance by providing reporting and traceability on InfoSphere data movement, modeling and business intelligence applications, as required by regulations such as the Sarbanes-Oxley Act and Basel II. This helped the IT staff understand the lineage of data from where the data is used all the way to where it originated from and all the transformations that has happened to it in between.