Drill down slow

Hello everyone

For starters i'm using Microsoft analysis services, integration services and reporting services.

All goes well when creating some general overview reports.

Once i get to making drill down reports with only 2000 rows of data is already starts to work very slow (sometimes takes hours). It seems a data cube is only fast for calculations like SUM, PARALLELPERIOD, ... but if it comes to amount of data it is extreemly weak! 2000 rows is not even alot, i've seen reporting tools beeing able to handle a million rows with drill down function.

I'm thinking that this microsoft tool is just not able to handle reports bigger than 100 rows in it combined with drill down. Please proof me wrong because we already paid for the microsoft tools and it would be a shame if we were not able to use them because of bad functionality...

The machine we work on is quite strong (dual core 2.4 ghz, 4 gig ram, ...)

And yes i know you can make reports clickable so they take the value with them to a next report as a parameters but thats not what we are looking for, we need this drill down to work properly with larger amounts of data.

Hmm, I don't think it's the tool in this case - I have drill down reports with far more data than that and I've never run into 'hours' of execution time. Do you have more detail?