Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer . It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank  Read more

I just discovered Reporting Services Scripter , which seems a very useful tool to move Reporting Services objects between different servers. Thanks to Davide Mauri for the link.  Read more

There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve  Read more

It is finally available the SSAS 2008 book I wrote with Chris Webb and Alberto Ferrari : Expert Cube Development with Microsoft SQL Server 2008 Analysis Services . The book is also available on Amazon . You can also read a sample chapter for free. We  Read more

Still some consideration about Gemini. In the last few days, I've seen some interesting posts and comments. Chris is still worried about the lose of control, and I agree with him that metadata are a key part of a complete BI solution, and today we are  Read more

I will be a speaker at PASS Summit 2010 (November 8-11, 2010 - Seattle, WA) and sessions have been published yesterday. I am currently writing the last chapter of the book about PowerPivot that will be available in September, so I’m confident it will  Read more

I recently encountered an issue using DRILLTHROUGH with ROLAP dimension and I wasn’t able to find any good information making searches about it, so I think it’s a good idea writing a few notes. Probably I will write a more complete on the DRILLTHROUGH  Read more

Aug 17, 2020

Converting MDX to DAX – First Steps

A BISM Tabular model can be queried by using both MDX and DAX. These two different languages rely on different modeling concepts, because MDX has a semantic based on dimensions, attributes, hierarchies and measures, whereas DAX only knows table and…  Read more

If you want to execute a DAX query from your code to a Tabular model, you might think that an OLE DB connection should be the right way to get your data. It works, but if you your code is…  Read more

Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have…  Read more