I understand lookups using the date column is not currently supported. The reason for my request is to join a Transaction fact table to a Time dimension table using the date column.

The work around I can think of would be to use a Time Key which is an integer made up of the date (e.g. 13 December 2012 would be 20121213) and ensure that the dates in the Transaction fact have the Time Key value rather than the actual date value. However, this is additional work which could be overcome by providing lookups on date data type.

I was just wondering if date lookups would be supported in the future?

Cheers

Sunil