Time Series for Cube

[a***@sqlserverdatamining.com]

Thanks for the post ZhaoHui. I followed the steps in your example, but I get errors when I process the model.
OLE DB error: OLE DB or ODBC error: .
Errors in the high-level relational engine. A connection could not be made to the data source specified in the query.
Errors in the OLAP storage engine: An error occurred while processing the ~CaseDetail ~MG partition of the ~CaseDetail ~MG measure group of the TimeSeries ~MC cube from the FoodMart 2000 database.
OLE DB error: OLE DB or ODBC error: .
Errors in the high-level relational engine. A connection could not be made to the data source specified in the query.
Errors in the OLAP storage engine: An error occurred while processing the Time ~MG partition of the Time ~MG measure group of the TimeSeries ~MC cube from the FoodMart 2000 database.
Any ideas what is causing this? The cube is processed and can be browsed.
Thanks,
Nigel

I wrote the following example about building a forecasting model on OLAP
cube. Hope this anwers your question.
ZhaoHui
_________________________________________________
Sales Forecast Model
Forecasting is yet another important data mining tasks. A cube usually
contains a time dimension. It is natural for cube users (those who consume
cube information through queries and reports) to ask the outlook for cube
measures, for example, how many bottles of red wine that will be sold in
Washington stores over the next three months? How much revenues each store
can make over the next two year?

[Dejan Sarka]

Again, I hope this is not too basic answer. However, from the post I would
say that you simply do not have the FoodMart2000 database on your box.
--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/

Thanks for the post ZhaoHui. I followed the steps in your example, but I
get errors when I process the model.
OLE DB error: OLE DB or ODBC error: .
Errors in the high-level relational engine. A connection could not be
made to the data source specified in the query.
Errors in the OLAP storage engine: An error occurred while processing the
~CaseDetail ~MG partition of the ~CaseDetail ~MG measure group of the
TimeSeries ~MC cube from the FoodMart 2000 database.
OLE DB error: OLE DB or ODBC error: .
Errors in the high-level relational engine. A connection could not be
made to the data source specified in the query.
Errors in the OLAP storage engine: An error occurred while processing the
Time ~MG partition of the Time ~MG measure group of the TimeSeries ~MC
cube from the FoodMart 2000 database.
Any ideas what is causing this? The cube is processed and can be browsed.
Thanks,
Nigel

I wrote the following example about building a forecasting model on OLAP
cube. Hope this anwers your question.
ZhaoHui
_________________________________________________
Sales Forecast Model
Forecasting is yet another important data mining tasks. A cube usually
contains a time dimension. It is natural for cube users (those who consume
cube information through queries and reports) to ask the outlook for cube
measures, for example, how many bottles of red wine that will be sold in
Washington stores over the next three months? How much revenues each store
can make over the next two year?