Search code examples
mdxmondrian

MDX query to get all dates where dateis greater than

For example i am need to take all dates where year is greater than 2013. This code return all dates.

SELECT 
  {[Measures].[In]} ON COLUMNS
 ,Filter
  (
    [Date].MEMBERS
   ,
    [Date].[Year].CurrentMember > [Date].[2013]
  ) ON ROWS
FROM [Shop];

And i am need to take all dates where date is greater then 2013.05.20

Solution

  • If you want to do greater than within a range then use null on one side:

    SELECT 
  {[Measures].[In]} ON 0,
  {[Date].[Year].[2013] : NULL}  ON 1
FROM [Shop];