SQL on OLAP cube

  • 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

  • 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'm on LinkedIn

  • Thank's for your answer PB_BI.

    Best regards.

    Carl

  • 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]

  • Thank's for your input Alvin.

    Querying the star schema will be one of our tests but we expect it to be way much slower than querying the cube with MDX.

    Best regards.

    Carl

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply