Time Series Reporting Stored Procedure
Many people have been asking for complete coding samples involving data mining. Also, many people have been frustrated trying to generate reports using time series predictions. So I decided to kill two birds with one stone and create a sample stored procedure you can use to see how some things are done, while simultaneously providing the ability to generate meaningful time series reports.
First a little background on the issue. The desired result for a time series report is to produce a chart that shows some historical data in one color, and then shows some forecasted data in another color. The difficulty lies in that Reporting Services requires that you produce all data for a single chart in a single dataset, and you cannot get both the historical data and the forecasted data from a single DMX query.
Tags: data mining, stored procedure