24 March 2017
Usually we consider dynamic members as calculated measures. [Measures] is a special dimension to get the values result.
14 March 2017
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.
27 December 2016
As I have mentioned before I was trying to prototype a web-based viewer:
30 November 2016
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.
11 November 2016
Let’s suppose we need a report with the following structure:
17 October 2016
The DistinctCount aggregation is a semi-addictive aggregation. What does it mean?
10 August 2016
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.
30 July 2016
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).