dbTalk Databases Forums  

PredictTime series function - Help

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss PredictTime series function - Help in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nicol
 
Posts: n/a

Default PredictTime series function - Help - 03-03-2006 , 03:00 AM






Hi,
I am having a time series forecasting model.
I set the Historic_ModelCount as 5 and Historic_ModelGap as 5.

But when i try to execute the query(Plz see the PredictTimeSeries
function parameters)


SELECT flattened [Car Name],( SELECT $TIME, [Tot Service Bulletins],
PredictVariance([Tot Service Bulletins]) FROM PredictTimeSeries([Tot
Service Bulletins],-20,-10)) FROM [AHM_ServiceBulletin_Forecase]


I am getting error as follows:

Error (Data mining): A time series prediction was requested with a start
time further in the past than the internal models of the mining model,
AHM_RECALLS_Forecast, specified in the HISTORIC_MODEL_GAP and
HISTORIC_MODEL_COUNT parameters can process.


how i have to specify the parameters for the PredictTimeSeries function.
what r the things i have to consider for that.

plz help me how to specify the range? and what is the erro in the above
query


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.