Create Database Cube and Reports

I have a SQL Server 2005 database which a number of reports are generated from. These reports are generated slowly, and the database has been optimised as much as possible (millions of records). I wish to generate a cube to allow: 1. faster generation of the existing reports 2. Analysis of data 3. New data is added to the database continuously, so there should be a facility to update the cube.