Forecasting with an MDX Linear Regression in an SSAS OLAP Cube
A few days ago I published an article detailing a method to create regression line calculations in an Analysis Services OLAP cube using MDX. The article can be found by clicking here. It is the starting point for this article.
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.
Tags: mdx