Groups | Blog | Home
all groups > sql server data warehouse > september 2005 >

sql server data warehouse : Drillthrough in Excel 2003


Marcin Pêksa
9/27/2005 1:06:40 PM
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
9/27/2005 11:34:57 PM
[quoted text, click to view]
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
AddThis Social Bookmark Button