Jay Paolucci-371454 (7/22/2014)
Here is a simplified example of what I'm trying to do. It uses the where filter that I've been trying to get to work:select [Measures].[Is Exited] on 0,
([Facility].[Close Date].children) on 1
FROM [HUMANRESOURCES]
where (FILTER([Facility].[FACILITY].[ALL].children, ([Facility].[Close Date] > cdate('01/01/2014')) or ([Facility].[Close Date].&[1899-12-30T00:00:00])))
Does the following query return rows?
select [Measures].[Is Exited] on 0,
([Facility].[Close Date].children) on 1
FROM [HUMANRESOURCES]
where (FILTER([Facility].[FACILITY].[ALL].children, ([Facility].[Close Date] > cdate('01/01/2014')) ))
Are there rows for this date [Facility].[Close Date].&[1899-12-30T00:00:00] ?
Igor Micev,My blog: www.igormicev.com