Is it possible to link a slice of data from AS into MS Access or SQL Server?
Basically, pulling a 2 dimensional set of data from AS and presenting it as
a table? If so, any samples would be helpful

Thanks
John

If you set up your AS server as a linked server in SQL Server you would
be able to create a view using the OPENQUERY() function to pass an MDX
query to AS and get back a 2 dimensional rowset.

There is a sample of how to set up a linked AS server here:
http://msdn.microsoft.com/library/de...l=/library/en-
us/olapdmpr/prsql_6gqa.asp

And an example of OPENQUERY here:
http://msdn.microsoft.com/library/de...l=/library/en-
us/olapdmpr/prsql_4vxv.asp

Note: the MSOLAP provider in the linked server needs to be setup with
the "Allow InProcess" option set to true in order to function.

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

In article <ONWM0zCTGHA.4340 (AT) tk2msftngp13 (DOT) phx.gbl>,
john.holtonNoSpam (AT) pulte (DOT) com says...