Here's a great post on the Office Business Scorecard Manager 2005 blog site about why to use OLAP or SQL Server 2005.  I would add one more reason, which is utilizing a front-end most end-users are familiar with, specifically Excel. 
Sponsor