MDX101
My collection of how to use MDX in a SSAS 2012 / 2014 environment.
Tuesday, March 13, 2018
Past 12 months dynamic
›
{ StrToMember ( "[Kalender].[J4MND].[Jaar 4MND Maand].&[" + Format (DATEADD( "M" ,-1,now()), "yyyyMM" )+ ...
Wednesday, September 2, 2015
multiple first day of week
›
Nice trick: http://richardlees.blogspot.nl/2015/08/supporting-multiple-first-day-of-week.html
Friday, August 29, 2014
ABC Classification
›
I was asked to make a simple ABC classification for a sales measures. I combined exists with TopPercent to identify: Class A = between the...
Friday, August 22, 2014
Calculating an Age
›
One of the questions you often get is how to calculate a customers age on a certain date. Luckily Chris Webb published a great example: http...
1 comment:
Sunday, August 17, 2014
CASE WHEN and NULL / 0 (zero)
›
When you have a CASE WHEN in MDX you basically have two options: The Simple or Searched statement: CASE [<<Set To Be Evaluated>...
Sunday, August 10, 2014
Calculating Median and Percentile
›
MEDIAN or 50th Percentile According to Wikipedia the median or 50th percentile is the numerical value separating the higher half of a data...
Wednesday, August 6, 2014
YearToDate (YTD) Previous Year (also QTD, MTD, WTD)
›
This is simple is you combine ParallelPeriod with the YTD functionality: WITH MEMBER [Measures].[Sales Amount YearToDate] AS SUM( YTD...
1 comment:
›
Home
View web version
