Date Dimensions

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
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
>
|||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
[vbcol=seagreen]
> 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...
> year.
> want