is there anyway to run a MDX select against a cube .....get the result set
......create a sql table and then run a select statement against that table
with a normal select statment........ basically what im try to do is combine
som sql data a result set from a cube

Robin:

Yes, it can be done. Use ADO.NET to:

1) return a dataset (cellset, rowset, or MDDataSet (XML)) with a MDX
query
2) read the dataset and put the values into a table (in-memory data
table and/or write to a physical table
3) query table from step 2 with SQL.

- David

Robin,

You can absolutely do this. You will want to create a linked server
from within SQL server to your OLAP server. You can then use the T-SQL
OPENQUERY command and pass your MDX as a string. There a few resources
on the net... here's one:

http://geekswithblogs.net/darrengosb.../26/76418.aspx

Robin Krupp wrote: