mondrian mdx在日期维度中过滤年份级别的集合(mondrian mdx filter a set on year level in a date dimension)

 mdx新手。 我有一个具有日期维度的查询。 年份是整数，属于CalYear级别。 我正在使用蒙德里安（通过Pentaho） 
 
 我如何在2012年后展示多年？ 数据年份为2012年，2013年，2014年的整数值。它是时间维度; 这个级别是一年。 
 
 如果我从这个查询开始： 
 
SELECT
     [Measures].[SalesMonth] ON COLUMNS,
    {[YearMonth.CalYearMonth].CalYear.members} ON ROWS
    FROM [mt_report] 
 
 我得到了三行的结果。 
 
 我试试这个： 
 
SELECT
    [Measures].[SalesMonth] ON COLUMNS,
    Filter({[YearMonth.CalYearMonth].CalYear.members},
[YearMonth.CalYearMonth].CalYear.CurrentMember.Value > 0) ON ROWS
    FROM [mt_report]
 
 它返回所有数据（与第一个查询相同） 
 
 但 
 
   SELECT
     [Measures].[SalesMonth] ON COLUMNS,
    Filter({[YearMonth.CalYearMonth].CalYear.members},
[YearMonth.CalYearMonth].CalYear.CurrentMember.Value > 9999) ON ROWS
    FROM [mt_report]
 
 但这也返回相同。 
 
 
 这有效...... 
 
Filter({[YearMonth.CalYearMonth].[CalYear].Members},
[YearMonth.CalYearMonth].[CalYear].CurrentMember.name > '2012')

mdx newbie. I have a query which has a date dimension. Years are integers and are in the level CalYear. I'm using Mondrian (via Pentaho)
 
How do I show years after 2012? The data years with integer values 2012, 2013, 2014. It is a Time dimension; this level is a Year. 
 
If I start from this query: 
 
SELECT
     [Measures].[SalesMonth] ON COLUMNS,
    {[YearMonth.CalYearMonth].CalYear.members} ON ROWS
    FROM [mt_report] 
 
I get a result of three rows.
 
I try this:
 
SELECT
    [Measures].[SalesMonth] ON COLUMNS,
    Filter({[YearMonth.CalYearMonth].CalYear.members},
[YearMonth.CalYearMonth].CalYear.CurrentMember.Value > 0) ON ROWS
    FROM [mt_report]
 
and it returns all data (same as the first query)
 
but
 
   SELECT
     [Measures].[SalesMonth] ON COLUMNS,
    Filter({[YearMonth.CalYearMonth].CalYear.members},
[YearMonth.CalYearMonth].CalYear.CurrentMember.Value > 9999) ON ROWS
    FROM [mt_report]
 
but this also returns the same.
 
 
This works ...
 
Filter({[YearMonth.CalYearMonth].[CalYear].Members},
[YearMonth.CalYearMonth].[CalYear].CurrentMember.name > '2012')

原文：