Post reply

Analysis Services Tabular

  • February 4, 2014 at 10:35 pm

    #282008

    Comments posted to this topic are about the item Analysis Services Tabular

  • February 5, 2014 at 12:39 am

    #1686104

    Easy peasy. 😀

    If I'm not mistaken, Excel uses MDX, Power View uses DAX.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 5, 2014 at 1:58 am

    This was removed by the editor as SPAM

  • February 5, 2014 at 5:02 am

    #1686141

    Please , could you explain me this excerpt ?

    "The exception is tabular models that have been deployed in DirectQuery mode, which do not retrieve data from an Analysis Services data store, but retrieve data directly from a SQL Server data source. You cannot query these models using MDX, but must use a client that supports conversion of DAX expressions to Transact-SQL statements, such as the Power View client."

    source : http://msdn.microsoft.com/en-us/library/hh230973.aspx

    In the same page , I found

    "You cannot use MDX or DMX queries in a database that has been deployed in DirectQuery mode"

    which seems ( to me ) a possibly annoying limit to the use of MDX/DMX , so why not to use only DAX ?

    Have a nice day

  • February 5, 2014 at 12:44 pm

    #1686335

    patricklambin (2/5/2014)

    Please , could you explain me this excerpt ?

    "The exception is tabular models that have been deployed in DirectQuery mode, which do not retrieve data from an Analysis Services data store, but retrieve data directly from a SQL Server data source. You cannot query these models using MDX, but must use a client that supports conversion of DAX expressions to Transact-SQL statements, such as the Power View client."

    source : http://msdn.microsoft.com/en-us/library/hh230973.aspx

    In the same page , I found

    "You cannot use MDX or DMX queries in a database that has been deployed in DirectQuery mode"

    which seems ( to me ) a possibly annoying limit to the use of MDX/DMX , so why not to use only DAX ?

    Have a nice day

    It's a limit, but perhaps only a temporary one; there is a statement that future versions of SQL Server are expected to enable tabular models to use DirectQuery to accept MDX queries in the document you can download here

    Tom

  • February 5, 2014 at 1:51 pm

    #1686355

    Thanks for yet another interesting question, Steven!

  • February 5, 2014 at 11:04 pm

    #1686448

    I like these true, false questions. Thanks for sharing Steve.:-)

  • February 6, 2014 at 4:17 am

    #1686522

    Hello Tom

    Thanks for your explanation. I have searched in the SQL Server 2014 BOL , I have found nothing about it but I have noticed that , very often , the improvements about Analysis Services are appearing not in the RTM version but only with the SP1.

    As Analysis services is not really my favorite topic , maybe , I have not searched in the right way.

    Thanks

  • February 6, 2014 at 7:34 am

    #1686597

    easy one.

    Thanks Steven.

  • February 6, 2014 at 4:22 pm

    #1686848

    Thanks Steven. Enjoying the SSAS content this week.

  • March 6, 2014 at 7:47 am

    #1694728

    Not worked much on SSAS so definitely gaining some points this week. 🙂

Viewing 11 posts - 1 through 10 (of 10 total)

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