Try to join with cast function something like
cast(fact.date as date)=date.dt
or else create a view for that fact and go for casting using sql.
if helps mark
I tried this ealier but it throws me an Invaild expression error. In the Physical Foreign key join
"ABC"."test"."dbo"."W_DAY_D_Alias"."CALENDAR_DT" = CAST("CT"."EAST"."dbo"."Fact-TEST"."Input date " as DATE)
Just in case try with complex join if not go for a db view for fact table where you can convert the datetime to date, this would be the only option.
I am not suree how this is done. Please can you help me...