My project is in the process of defining a corporate set of standards for reporting. Our goal is to provide a template for our Accounting, Finance, HR and Inventory departments to use Cognos 8. Currently, we are all operating in silos and are even running varying versions of Cognos. We have one group using Cognos Series 7 where they rely on Impromptu and continually updating an outdated Catalogue, while my group is using Cognos 8.2 and Framework Manager with Report Studio. The other departments are using 8.1 and waiting to upgrade to 8.2.
Our goal is to have one central Data Warehouse for the entire organization and to provide Data Marts for each department. I’m researching Data Mart best practices and wanted to share one of the knowledge sources that I came across. If you’re getting involved with Data Marts then you might enjoy the link below.
http://blogs.ittoolbox.com/dw/design/archives/pt2-what-on-earth-is-a-data-mart-7978
