I have created a time dimension (called Work_Date) for a cube and want to be able to specify filters based upon time expressions. ie I want to be able to filter the cube for all members whose Work_Date falls between 2005 and 2006 or for 2005 Quarter 1 and 2007 Quarter 2. I want to write filter expressions of the form Work_Date >= [2005] AND Work_Date <= [2006]

or

Work_Date >= [2005].[Quarter 2].[June] AND Work_Date <= [2006].[Quarter 1]

I can get simple expressions of the form Work_Date = [2005].[Quarter 1] to work but the inequality operator involved in a range expression does not appear to work properly.

Can this sort of thing be done and if so how. Any help would be much appreciated.

Regards

Trevor