The business users of the Business Intelligence environment at D’Ieteren were complaining about poor report performance.
Starting from the specific poor performing reports element61 worked its way through the different layers of the Cognos 8 BI environment all the way to the underlying MS SQL Server database. The output of this exercise was a list of recommendations, such as appropriate hardware sizing, database indexing, etc. D’Ieteren chose to implement those recommendations with the highest Return on Investment. Report performance is now no longer an issue at D’Ieteren.