-
Filter expressions for time dimension
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|