Time series: more than one predictable variable

Question

Hi,

I am wondering if it is possible something like this in MS SQL server 2008 (data mininng, analysis services). I have time series model with two predictable variables. Is it possible to predict first variable with given future values of the second variable (maybe something like what if scenario). 

Answer 1

Hi Koles,
When you have 2 predictable variables and both of them are also inputs,
Then while predicting one other acts as input and definitely part of prediction.

Cheers
Bikash Dash
MCDBA/MCITP

Answer 2

Yes it is possible - download the sample from here:http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=97&Id=382

It automatically creates models based on stock tickers or other data series, shows the interrelations between series (where they exist) and allows you to drag points to see the impact on future predictions.  Also - it shows the queries that are sent to the server and the source code is included!

---

-- Jamie MacLennan -- SQL Server Data Mining -- http://blogs.msdn.com/jamiemac

Answer 3

Hi,

I have download the DMTimeSeriesSample, I have connection to the server, but I have problem with addin data. If I choose option with thicker symbols I get an erreor 'Stock symbol 'MSFT' is not a valid ticker symbol', if I choose option with other data (sample data sets Sales Data, BikeSales,...), I get an error 'No columns found with data type double or int'. Why does the sample not work? I am just clicking following the help instruction.

Answer 4

Hi,

I have problem with the sample which you have recomended. I can't get through the second step of How To section in the help file (I can't load any data form internet or from file). Could you paste me here example query for time series model for two predictable variables in which you want to predict one first variable with given values of the second variable (the forecast horizont could be one for simplicity)?

Thanks in advance,
koles