SQL and MS Analysis Services

From: wooz (kamilch_at_o2.plSPAM)
Date: 10/19/04

  • Next message: Joe Genshlea: "Re: Error intializinig service...'Class not registered'" 
    Date: Wed, 20 Oct 2004 01:38:21 +0200

    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.

  • Next message: Joe Genshlea: "Re: Error intializinig service...'Class not registered'"

    Relevant Pages

    • Re: Bad Performance on Semiadditive Measures
      ... slower than Sum, but faster than equivalent hand-crafted MDX. ... AverageOfChildren perform better than the built-in function. ... Using the SQL Server built-in function: ...
      (microsoft.public.sqlserver.olap)
    • Re: accessing data mining model via web/PDA
      ... this was the sample mdx which i have created in DMSamp ... the ADOMD command to execute this statement as the command ... analysis manager or sql 2000 server? ... if the connection need to be made on the analysis server ...
      (microsoft.public.sqlserver.datamining)
    • Re: Analysis Server and Web.
      ... client-side tool which supports a thin-client option. ... Services component of SQL Server. ... (generate HTML formated reports against Analysis Services). ... it only works with pre-defined MDX -- you must enter raw MDX (like raw ...
      (microsoft.public.sqlserver.olap)
    • Re: return a value using MDX
      ... There are some good books like Fast track MDX which I have ... I created a stored procedure to this query. ... it is looking for @sql as well. ... DECLARE @sql varchar ...
      (microsoft.public.sqlserver.olap)
    • Re: return a value using MDX
      ... There are some good books like Fast track MDX which I have ... it is looking for @sql as well. ... DECLARE @sql varchar ...
      (microsoft.public.sqlserver.olap)