Re: Best way to process an AS2005 cube from Excel
- From: Darren Gosbell <jam@xxxxxxxxxxxxxxxxx>
- Date: Sat, 18 Feb 2006 17:32:23 +1100
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@xxxxxxxxxxxxx>,
RobertChapman@xxxxxxxxxxxxxxxxxxxxxxxxx says...
.
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
- Prev by Date: Re: problem with a DTS "Analysis Services Processing Task"
- Next by Date: Re: SSAS 2k5: Fact and Bridge Fact table
- Previous by thread: Re: problem with a DTS "Analysis Services Processing Task"
- Next by thread: Re: How do you control field names using ADO with MDX?
- Index(es):
Relevant Pages
|
