Hi all,

I'm new to OLAP and especially drillthrough and just have a question about
the way it works.
I can see clearly why the process exists and the complete benefits of it,
but correct me if i'm wrong but:

1. It appears to issue an SQL query against the data source to return the
information and not from the cube?
2. I assume I am able to send parameters to the query , for example the
current dimension selection as parameters? If so, how?

Currently, everytime i try a drillthrough, i get a timeout message from
AS2000 and my server CPU hits 100%.

I am correct in saying, for example, that If i have a value rolled up to a
week, I should be able to use the drillthrough feature to access the
underlying data that makes up that value, AND ONLY THAT DATA and not the
whole fact table which curerntly appears to be happening to me?

Many thanks
Immy