Hi,

I have a macro in Excel (2002) which enables me to drillthrough on a cube.
It works fine excepted when heaps of filters and multiple choices are
selected on the Pivot table.

Have you experienced such latencies when using the drillthrough
functionnality? Do you know any way to reduce the delay?

Thx,

Chris

I'm sure you will get better advice from the true OLAP experts, but
from own experience the only way to speed up drillthrough is to heavily
index your relational tables. Even then, it only gets so fast.

I am starting to develop in Reporting Services and I am working on a
way to pass on parameters from a cell in the cube to a report. This
should be much faster and ultimately more useful than drillthrough.

Good Luck


Chris Leroquais wrote:

multiple choices using the pivottable always generate bad queries.
and drill through commands are badly generated too. and the resulting query
will (sometimes) return ALL the data like the user has selected nothing in
the dimension.

you can't deactivate the multiple choice option, but you have to train the
users to try to not use the multiple choice feature.


"Chris Leroquais" <c.le_roq (AT) caramail (DOT) com> wrote