Yes, you can do this by using the OPENROWSET function in t-sql and send a
passthrough MDX query to AS. This is well described in SQL Server Books
Online. You can also do a DTS import using the OLE DB provider to AS.

Jon Jahren

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote

Thanks. I need to look those up!
"Jon Jahren" <nospam_jon (AT) softscenario (DOT) no> wrote

There are 2 other alternatives:

1. You can request flattened rowset as a result of MDX query as opposed to
IMDDataSet (CellSet). In order to do it in ADO, simply use command.Execute
instead of cellset.Execute
2. You can send SQL queries to the OLAP cube directly. First you will need
to issue DBSCHEMA_COLUMNS to discover the names of the columns for levels
and measures, and after that you can build SQL queries.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Jon Jahren" <nospam_jon (AT) softscenario (DOT) no> wrote