|
Home > Archive > MS SQL Server OLAP > January 2006 > Trying to use "action" in excel for drillthrough in AS 2005 cube
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 |
Trying to use "action" in excel for drillthrough in AS 2005 cube
|
|
|
|
Hi !
I´m trying to use drillthrough in excel against a cube in AS 2005. I
haven´t found any functions in excel for this, but I have found an add-in
"Cube Analysis"
http://www.microsoft.com/downloads/detail
s.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en
The basic and advanced drillthrough works fine but when I am trying to use
my own drillthrough action, defined in the cube, I recive a error message
from excel.
The message goes: "Unable to launch external application associated with
this action" .
It seems like Report Builder is associated with this action in some way...
Do you know how to make action drillthrough work ?
| |
|
| Well well...
Now I have read the documentation :-)
Under section "Other restrictions " I have found :
"The Microsoft Office Excel Add-in for SQL Server Analysis Services does not
support the Microsoft SQL Server 2005 drillthrough action."
Crap ...
Have you found any workaround ?
Thanks
"Oller" wrote:
>
> Hi !
> I´m trying to use drillthrough in excel against a cube in AS 2005. I
> haven´t found any functions in excel for this, but I have found an add-in
> "Cube Analysis"
>
> http://www.microsoft.com/downloads/detail
> s.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en
>
> The basic and advanced drillthrough works fine but when I am trying to use
> my own drillthrough action, defined in the cube, I recive a error message
> from excel.
>
> The message goes: "Unable to launch external application associated with
> this action" .
>
> It seems like Report Builder is associated with this action in some way...
> Do you know how to make action drillthrough work ?
|
|
|
|
|