|
Home > Archive > MS SQL Data Warehousing > September 2005 > Drillthrough in Excel 2003
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Drillthrough in Excel 2003
|
|
| Marcin Pêksa 2005-09-27, 7:23 am |
| 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
| |
| Richard Kemp 2005-09-28, 3:23 am |
| Marcin Pêksa 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 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
>
>
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.
|
|
|
|
|