Page 2 of 190 results for mdx
  • Creating a hierarchy in a Power Pivot or Tabular data model is very easy, but you might experience performance issues if the hierarchy is not “natural”. This article explains how to create hierarchies avoiding these problems.  Read more

  • Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very…  Read more

  • Some weeks after my blog post about Bonavista Dimensions I’ve been able to look at a comprehensive demo of XLCubed, but since then I’ve been too busy to write about that (and in general to blog – I have several…  Read more

  • Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I’m doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I’m discovering that MDX calculation engine…  Read more

  • I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen…  Read more

Show more