Drillthrough in Excel 2003

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,
MarcinMarcin Pksa wrote:
> 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 t
o
> 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
>
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.