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.