How is your date dimension designed? The standard is -

PK Year Month Week Date

Then when you set the dimension up in AS, set it as a star, and set the levels,
year down to date. That way you can drill down to the day.

-- Brian

> Hi,
> Problem is more general than a date dimension. It is a general
> failure. I
> was misinterpreting the error message.
> I shall do some more investigation.
> "Bob" <bob@nowhere.com> wrote in message
> news:%23Ja74vgKFHA.3392@TK2MSFTNGP10.phx.gbl...
>> Hi,
>> I am new to this OLAP stuff.
>> I am trying to create a cube which has a count of sales per month per
> year.
>
>> How do you make a datetime field a dimension of a cube? I seem to
>> specify the dimension OK and get the Year Month heirarchy I
>>
> want
>
>> (simple star dimension and a MOLAP) but when I process the cube it
>> gives a
>> datasource provider error Initialising the dimension.
>> 'Data Source provider error: ; Time:16/03/2005 22:31:32 '
>> I have tried making a view with the date cast to 101 and creating the
>> cube
>> on that view but no difference.
>> thanks
>> Bob