• Jay Paolucci-371454 (7/23/2014)


    That does not return rows, but it appears that it should as there is a 03/31/2014 close date. Could this be a date format issue? The designer of the cube is representing no close date as [Facility].[Close Date].&[1899-12-30T00:00:00], so there are many records with that as the close date value.

    Definitely, you should check it out.

    Igor Micev,My blog: www.igormicev.com