all groups > sql server reporting services > february 2006 >
You're in the

sql server reporting services

group:

Drillthrough to AS2005 cube in excel



Drillthrough to AS2005 cube in excel darrenmr2 NO[at]SPAM gmail.com
2/12/2006 3:57:42 PM
sql server reporting services: 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
Re: Drillthrough to AS2005 cube in excel BALAJI K via SQLMonster.com
2/13/2006 5:05:51 AM
Hi 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

[quoted text, click to view]

--
Message posted via SQLMonster.com
AddThis Social Bookmark Button