Forecasting Mining Model, Performance And Viewer

In order to setup my forecasting mining model I have created a special view that runs against my fact table and creates time series on the level I need.




Code Snippet
Select DFUKEY, DATE, QTY from Dim_FACT where DFKEY like '020%'

So I get the following input fr my model:


time series key (e.g. DFUKEY)

date (time key)

QTY (to be predicted)

For testing purposes I created a small view (similar to AdventureWorks) that only contained a few time series. The model was created and processed in ~2 minutes or less. The viewer came up almost immediately and I was able to see results.

Now my real view has about 25000 time series I need a forecast for and that I also like to review in the viewer. If I create a mining model against that bigger view the processing takes ~15m or so and the viewer is likely to time out.

The worst part thought is when I try to get the forecast for a time series (see query below) it takes minutes before the answers come back.




Code Snippet
SELECT FLATTENED [DFUKEY], PredictTimeSeries([QTY], 12)

FROM [TimeSeries]
WHERE [DFUKEY] = '02078147AG'




I would understand if without the WHERE clause it would take long but as is?

I am pretty sure I created the model the right way so I wonder if somebody can give me recommendations as to how forecast larger numbers.

Finally I intend to call the foarcast for a particular series using an Action from within a cube.

Thanks in advance.
Dirk