Hi,

I can't change the column used at the last level of my dimension if this
columnis a date/time type.
After I've optimized my cube I've done some changes and my time dimension
required to be mapped to another column of my Fact table.
So I simply select the column but I receive a data type error.
The DBDate type is not recognized!

so I change the column definition from : dbo.MyFactTable.MySecondDate to
cast(dbo.MyFactTable.MySecondDate as DateTime)

and now all works fine!!!!!

so, why AS don't recognized MySecondDate column (which is a datetime) as a
datetime?
Why casting this column solve the problem?

Very strange.

Thanks.

Jerome.