Home Forums SQL Server 2005 Business Intelligence SQL on OLAP cube RE: SQL on OLAP cube

  • August 3, 2015 at 2:01 pm

    #1816957

    PB_BI (7/27/2015)

    Carl B. (7/24/2015)

    Hi all,

    Is it possible to use the SQL syntax to query an OLAP cube or is it just possible to do that using MDX syntax?

    Best regards.

    Carl

    The simplest answer to this is No. You could use openquery with a linked server to your SSAS instance and then write a broad MDX statement and use T-SQL syntax to select from that but it would be a bit silly in terms of optimal performance and not missing the point of SSAS entirely. There are plenty or resources out there for learning MDX, including a Stairway on this very site.

    I agree with the above.

    Depending on what you're trying to do, and whether or not you have access, maybe querying the SQL dimension and fact tables might be an option for you.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]