Topic: MDX

Page 2 of 231 results
  • You cannot create functions in DAX, and this is a limitation to certain abstractions you might want to implement for complex models. I used a pattern that allows you to "pass an parameter" to a DAX measure, simulating the behavior of a function at least  Read more

  • Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown:  Read more

  • SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this reason, it’s also more difficult to analyze  Read more

  • MDX Studio refresh

    If you work with MDX, using MDX Studio is a must, but it has not been updated for years. But community is great and Ihor Bobak has been able to apply two fixes: performance counters work with named instance and there is a single version regardless of  Read more

  • I wrote an article about how to get the Last Process Date in SSAS Tabular . This is a common request and there are many ways to obtain this information. You can use the metadata provided by XMLA or DMV, just as you can do in SSAS Multidimensional. Or  Read more

Show more