Calling SSAS2005 Actions from Excel 2003

[ronb]

I'm interested finding out how to call or excecute a drillthrough action in SSAS 2005 from Excel 2003. I have a large rolap dimension and am unable to perform drillthrough using VB code. It works great if the dimension is MOLAP, but not ROLAP. When I use Excel 2007 I'm able to use the drillthrough action successfully.

I hope someone can point me in the right direction.

Thanks,
Ron

[Island1]

I've only done this sort of thing with Office 2007 components, but would recommend taking a look at AMO (replaces DSO for SSAS 2k5, as I'm sure you are aware). There may be a way to approach it here, as I know the object model exposes cube actions (perhaps just for Admin, like the majority of AMO, but hey - it's a start ...).

Here's a very basic primer - more to point you in a direction than to answer the immediate question perhaps:

http://msdn2.microsoft.com/en-us/library/ms124924.aspx

HTH, and Good Luck. Let us know of your findings!

Bill