Hi,

I'm attempting to add a time dimension to a ROLAP cube in Analysis Services
(SP3). The time data is held in a single field of the form '2003/01/01
00:00:00' and of type DateTime. Whenever I view aggregations of data using
this dimension (e.g. all data for June 2003), the counts I get are all
incorrect and much larger than what I would expect. Is it actually possible
to specify a correct time dimension this way? All of the examples I've seen
involve using a separate time table for the dimension with columns for year,
month, etc.

Any help much appreciated,


Thanks,

Jon