You should have already read that DAX is simpler than MDX. It’s true, and sometime you have to pay a price for simplicity. I am used to say that DAX is somewhere between SQL and MDX. In fact, SQL requires…  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…  Read more

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole…  Read more

In the last two years I worked on advanced modeling with Analysis Services. One result of this was the paper “The many-to-many revolution” I released in September 2006. Since then, I got a lot of feedback and I have been…  Read more

Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release: Tracing (query plans and server timings) available for Power Pivot Basic implementation of Intellisense Connect to Multidimensional SSAS servers Support for multiple Power BI Desginer instances Highlight…  Read more

article

Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services

This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases.  Read more

I just had to profile MDX queries sent to SSAS from some client. Office Web Components (that are used in the cube browser of Management Studio) in many circumstances send a lot of MDX queries, increasing roundtrip between client and…  Read more

Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan. While I look forward to reading next articles, it is interesting the explanation of what is…  Read more

The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE(     ‘Product Subcategory’,     ‘Product Category’[Product Category Name] = @Category ) Depending on the client and on the driver you are using to…  Read more

Analysis Services answers to query in MDX, in DAX (by now just for Tabular models) and has a limited capability to answer SQL queries. It is not useful for any development or client tool, but I wanted to write a…  Read more