Post reply

SQL on OLAP cube

  • July 24, 2015 at 1:28 pm

    #299112

    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

  • July 27, 2015 at 5:06 am

    #1815077

    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

  • August 3, 2015 at 1:32 pm

    #1816950

    Thank's for your answer PB_BI.

    Best regards.

    Carl

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

  • August 4, 2015 at 7:16 am

    #1817099

    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