Reporting Services process Analysis Services cube with 100% load

Hi all,

I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2.

I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.

When I build Reporting Services project with same cubes as data sources

(on same computer), CPU was increased to 100% for more than 30 minutes

(process msmdsrv.exe) ... and I interpurt it.

Transfer projects to Windows 2003 SP1, but same result.
Do you have any idea what happens and how can I fix it ?

Best regards,

Siol En

OK, what happens.

I decreased attributes number (join some of them and my cubes become a little bit ugly), processing (for OLAP) a little bit increased (from 5-10 to 8-15 seconds).

Reporting Services proceed new cube for less than 2 minutes (bigger one) - waiting for congratulations

Now a big fight will be with a fact that Reporting Services didn't support "(All)" hierarchy member

Any help will be welcome, because my aggregation functions used exactly that property ... - "Percentage of Parent"; "Average", "Standart deviation"

Best regards,

Siol En