Drillthrough

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
Immyyou have to capture the SQL query to verify what's appends exactly.
you have to insure that there is enough joins between your tables, sometimes
AS don't add corectly the right joins which result in a large table scan.
in the drill through option page, you can add static filters which also can
act has join between tables to insure the usage of joins.
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:eI$0whKXGHA.4132@.TK2MSFTNGP04.phx.gbl...
> 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
>