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
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];