24 March 2017

The dynamic members

Usually we consider dynamic members as calculated measures. [Measures] is a special dimension to get the values result.
   MDX, SSAS

14 March 2017

My name is Rank, Dense Rank!

The Rank is one of the functions that wasn’t initially designed for the MDX. Well, it’s possible for sure, however it’s not a first class function.
   MDX, SSAS

27 December 2016

Web OLAP: Step one

As I have mentioned before I was trying to prototype a web-based viewer:

30 November 2016

The DistinctCount and its rough edges

This is a follow-up on my last distinct count post. I’m going to show you the performance difference and the other aspects that you should bear in mind while projecting the distinct count KPIs.
   MDX, SSAS

17 November 2016

Will the SSAS be ported to linux?

It's promised regarding to Microsoft:
   Linux, SSAS, MSSQL

17 October 2016

The best DistinctCount practice in SSAS

The DistinctCount aggregation is a semi-addictive aggregation. What does it mean?
   MDX, SSAS

13 September 2016

SSAS via Python

After announcing the SQL server on Linux I have realized it would be good to have SSAS on Linux as well. However SSAS 2016 has been released with no new major interesting features, thus I doubt it'll be ported to Linux or at least opensourced to give a chance for being ported by community. Actually MDX could get new functions or improvements also, but I haven't seen any for a decade (or is it just me?).
   SSAS, Python

10 August 2016

Set operation within MDX and months of cooperation case

When it comes to MDX optimization, it is most likely that you have to avoid Set functions, really. Sometimes it's impossible, but avoiding them as often as they show up is the key towards reaching good performance.
   MDX, SSAS

30 July 2016

All Member

All Member is a very handy member to use in some MDX calculations. There is a need to remember, when you drop any measure and no other dimension members, it doesn't mean that they aren't in use. Every cell (tuple) has a coordinate. If you don't select any member from the hierarchy it doesn't mean that your current coordinate is unknown, it is .DefaultMember, most likely it's .All member (you can change default member in the Attribute properties).
   MDX, SSAS

    © Danylo Korostil