Process cube using VB????

[Jeff C]

I have had no luck searching for a solution so I'll pose the question here
for you all.

I am using Access as a front end to push new data into a SQL Table. Is it
possible to process the OLAP cube using code from within Access? I would
really like to automate this but have hit a wall.

SQL Server and Analysis Services 2005

Thanks in advance for any ideas.

 

[Alex Dybenko]

Hi
Have you tried to run OLAP sql in pass-through queries? I think it could
work...

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

Hi
Have you tried to run OLAP sql in pass-through queries? I think it could
work...

Thanks Alex - I'll search on that idea, I don't know how to go about making
that work off the top though.