Date Dimensions

[Bob]

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

[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.

Post by Bob
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

[Brian Madden]

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

Post by 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.

Post by Bob
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.

Post by Bob
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

Post by Bob
(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