• 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])))