Preface: it is almost a secret that Microsoft DB data, sproc results and OLAP cube analysis can be delivered by Cognos 8 inexpensively.
Cognos works well with Microsoft db/sproc/asdb !
The new version has EXPRESS AUTHORING (for the masses) not dissimilar to PIVOT reports/charts.
Also brand new administration GUI interface.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!