From a cell in a cube I want to drillthrough to a table having a few extra
columns than the fact table. When I do the drillthrough i get the correct
result but it takes up to 3min wher the SQL server runs at 100% CPU.

How can I improve the performance?
Can i limit the amount of CPU % to be used for Drillthrough?

The table I drill through to is only 180K records, thus not a lot.

Regards,
Henrik

Sounds like you need to put some indexes onto your fact and dimension
tables - i used this way:

1) Activate profiler
2) Make drill through
3) After a short while a stored procedure will execute the sql statemetn
that is launched from Analysis Services against your relational SQL
environment and you can take this sentence - replace the variables - put it
into query analyzer and run an index optimizer...

This improved my with 80-90 %



"Henrik" <Henrik (AT) discussions (DOT) microsoft.com> wrote