Re: SQL and MS Analysis Services

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 11:43:46 -0700

When we say that SSAS is both a multidimensional and a tabular data
provider, we mean that it can return data in either multidimensional format
(a cellset) or a tabular format (a rowset). In both cases, you still query
the system with a MDX statement.

If you want to see an example of how you get tabular data from SSAS, look at
Appendix F in the SSAS Operations Guide.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
It shows you how to create a SQL Server linked server which returns a rowset
(tabular format) from a multidimensional data source (SSAS).
You will notice that you still query the system with MDX, but you get a
rowset back (which is the only thing that SQL Server the RDBMS understands). 

-- 
Dave Wickert [MSFT]
dwickert@online.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.
"wooz" <kamilch@o2.plSPAM> wrote in message
news:cl48p3$6es$1@nemesis.news.tpi.pl...
> MS AS is  both a multidimensional data provider and a tabular data
provider,
> so it can interpret and process queries in both SQL and MDX.
>
> How to prepare a query in SQL ?
> I'd like to access to MS AS through Web Service (XML for Analysis
Provider).
> How to prepare a EXECUTE request ? I mean how should  look COMMAND and
> PROPERTIES parametrs.
>
> For some reasons i don't want to use MDX. It would be very helpfull for me
> if someone could show an example SQL query for MS AS.
>

Relevant Pages

  • Re: SQL and MS Analysis Services
    ... SQL BI Product Unit ... > the system with a MDX statement. ... > If you want to see an example of how you get tabular data from SSAS, ... > SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.data.xmlanalysis)
  • Writing tabular data from excel to sql server using VBA
    ... want someting similar to "copyfromrecordset" when we retrieve data from SQL ... server - so that I can write all visible tabular data from one sheet to SQL ...
    (microsoft.public.excel.programming)