"MicrosoftR SQL Server 2000 Analysis Services is both a
multidimensional data provider and a tabular data provider.
Therefore, executing a query returns either a
multidimensional dataset or a flattened rowset, depending
on the query language used. Analysis Services can interpret
and process queries in both SQL and Multidimensional
Expressions (MDX)."
This text comes from SQL Server 2000 Books On-line.
Since i've discovered that there is no OLAP provider for .Net
Compact Framework (for mobile devices) i was looking to
find a way to connect to local cube.

Question nr. 1 : Is it possible to connect to local cube
throug ADO.NET
Question nr. 2 : Is is possible to connect to MS SQL
Analysis Services Server through ADO.NET, bypassing
connecting via WebSevice.

I hope that the questions is clear, and i'm sorry for my
english.

I don't have the specifics on hand, but the answer is yes.
You can issue MDX queries using ADO.NET.


"wooz" wrote:

See Appendix F in the SSAS Operations Guide.
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jesse Drogin" <JesseDrogin (AT) discussions (DOT) microsoft.com> wrote