3 Replies Latest reply on Feb 25, 2015 1:54 AM by Rishabh Dhingra

    Is there a way to modify the MDX that Tableau sends to a Microsoft Analysis Services cube?

    Andy Piper

      Our MSAS admin is noticing that Tableau (8.0.4) is creating some rather inefficient MDX code to perform queries. In his words, it's as if Tableau wants to bring back everything only to then filter out what the user has requested. Not sure if this is a recent issue as it was first noticed in 8.0.4.


      When the MSAS admin took the MDX code generated by Tableau and ran it against the cube it took him about 10 minutes to receive a result. When he reran the code minus what he considered non-needed MDX code, the query took less than 20 seconds.

       

      Is there some way to modify the MDX code Tableau sends or perhaps force a specific MDX code within specific workbooks?