hello, i try to tune my database to optimize drillthrough query.
i try to catch the sql generated with the profiler to check the execution
plan but i don't see the query in the profiler, why?
(i see all the query from my application except the drillthought from the
cube)

The OLAP Server submits drill-through queries via the sp_prepexec()
stored procedure (presumably to improve performance). A parametrized SQL
SELECT statement is passed in, which you should be able to inspect...


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

True - I used Deepak's advice earlier - at some point a stored procedure
turns up and this can be used with the index optimzier which gives
a dramtically improvent - it puts an index on the fact table on the fields
specified in drillthrough options...


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Thanks you now i see the query.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote