Data Mining Time Series Reporting Stored Procedure
| Time Series Reporting Stored Procedure |
| Written by Jamie Mac |
| Wednesday, 27 August 2008 02:54 |
|
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. Read more Part 1...
|
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
