SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:56 PM
| ||||
| ||||
 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      |
|
02-27-2008, 05:56 PM
| |||
| |||
| Re: Date Dimensions 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 > > |
|
02-27-2008, 06:23 PM
| ||||
| ||||
| Re: Date Dimensions 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 |
Linear Mode
