This article was originally published to a blog which has been decommissioned.
A few days ago I published an article detailing a method to create regression line calculations in an Analysis Services OLAP cube using MDX. It is the starting point for this article. My instructional video detailing the entire regression line and forecasting process can also be found at this link.
Regression lines are a great way to visualize trends over time. My previous article details how to view a regression line over time periods that have already happened. Regression lines are also frequently used to forecast values for future time periods. Basically, extending a regression line into the future is one method of forecasting. Below I will walk through one method to extend a linear regression line to future values using MDX in an SSAS OLAP cube.
Continue reading this post at the following link: https://web.archive.org/web/20140219072558/http://blog.gnetgroup.com/bi/2013/03/28/forecasting-mdx-linear-regression-ssas-olap-cube/
Leave a Reply