sql server data warehouse: Drillthrough -- sql server data warehouse

Drillthrough

Immy
4/10/2006 3:11:41 PM

sql server data warehouse: 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

Re: Drillthrough

Jéjé
4/13/2006 12:00:00 AM

you 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.

[quoted text, click to view]