generate report from data warehouse

Dear all,

I use sql server 2005 as a data warehouse.

A report get data from this data warehouse. I found that it is very slowly.

How can I tune the sql or give me some advices about generate report from a data

warehouse ?

Thanks you

You should look into creating Analysis Services cubes on your data warehouse, depending on the types of reports you are looking for.|||

Hello. If you are running a relational data warehouse, without any cubes(OLAP), you can find som good advice here: (http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/default.mspx?mfr=true)

, that are still relevant.

HTH

Thomas Ivarsson