Hi,

I need to have users able to reprocess AS2005 cubes from Excel so need to
run a VBA routine. However I understand I can't use AMO as it's not
COM-based and I can't use DSO as it will only work with AS2000 cubes in
AS2005. So then , what is the best way to do this? Can't seem to find an
appropriate library...

Thanks,

Rob

You should be able to send the appropriate XMLA commands to AS2005 to
get it to process a cube. I have not tried this myself, this is all
theory so I would be interested to know if you do use this approach.

When you right click on the cube and choose process, at the top of the
dialog that appears is the option to script the process action. In
theory, sending this xmla script with one of the samples from Chris
Harringtons ThinOlap blog http://www.activeinterface.com/thinolap.html
might get you up and running. He was able to get xmla queries working
from WSH (which is COM based)

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <5C06CE15-5933-4527-B5F3-A00410190269 (AT) microsoft (DOT) com>,
RobertChapman (AT) discussions (DOT) microsoft.com says...