Drillthrough in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcin Pêksa - 27 Sep 2005 12:06 GMT

Hi,
I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
fine when I explore the cube with the cube browser in AS, but when I try to
invoke the drillthrough action in MS Excel 2003 I get an message the there
are no details to be displayed - it failes.
Does anyone know why? Maybe Excel doesn't support drillthroughs?
Thanks,
Marcin

Reply to this Message

Richard Kemp - 28 Sep 2005 07:34 GMT

> Hi,
> I set up drillthrough action in my cube in MS SQL 2000 AS and it's working
[quoted text clipped - 4 lines]
> Thanks,
> Marcin

Right, not supported out-of-the-box. But there's some sample VBA code
you can get from the microsoft web site somewhere that shows how to
implement drill through as a right-click context menu.

Reply to this Message