If you haven't bought a BI tool yet, it's probably worth waiting for SQL Server "Yukon" to be released in Q3 of this year because a BI tool from Microsoft is going to be integrated with Analysis Services. Why pay for the same functionality twice ?
Whatever "gaps" are in the Microsoft product can be filled in by purchasing tools from Cognos, Business Objects, Microstrategy, etc.