Drillthrough to AS2005 cube in excel

Hi,
I am trying to get the 'Drillthrough' feature working in excel 2003 (I
have an action set against my 2005 cube for drillthrough).
I can drillthrough fine in the cube browser but cannot get it to work
in excel.
If I double-click the cell I get an error and have read that I may need
to use the excel addin to do this. However, when I have installed the
addin and the 'required components' I can setup a connection to the
cube but when I try to connect get an error saying I do not have
permissions or my cube does not exist - both of which are false.
Anyone come across this and have a solution?
Thanks,
DarrenHi Darren,
Just write an DRILLTHROUGH MDX Query in Managamnet studio and see your
getting the data.
Let me know if your still having any issue.
Balaji
darrenmr2@.gmail.com wrote:
>Hi,
>I am trying to get the 'Drillthrough' feature working in excel 2003 (I
>have an action set against my 2005 cube for drillthrough).
>I can drillthrough fine in the cube browser but cannot get it to work
>in excel.
>If I double-click the cell I get an error and have read that I may need
>to use the excel addin to do this. However, when I have installed the
>addin and the 'required components' I can setup a connection to the
>cube but when I try to connect get an error saying I do not have
>permissions or my cube does not exist - both of which are false.
>Anyone come across this and have a solution?
>Thanks,
>Darren
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1