I have a date dimension that is built off of a date
database. The dates are stored as smalldatetime and are
simply the date (i.e. 1/1/2004).

I have a fact table that is updated daily. The DTS that
does the append also adds a date stamp ( using the getdate
() function in SQL). This is a smalldatetime field, but
the time is stored by the getdate() function (i.e.
1/1/2004 12:30PM).

When I try and create a cube with this data, I get no
results, as AS/SQL does not match 1/1/2004 with 1/1/2004
12:30pm.

How do I either:

1) write the timestamp without the time (date only).
2) get AS to see the dates as the same and process the
cube correctly?

Thanks

You might store the date without the time using "select
convert(varchar,getdate(),112)" You could create a view off your existing
tables but that is not the optimal choice.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
"CJL" <anonymous (AT) discussions (DOT) microsoft.com> wrote