Create a Regression Line in an SSAS OLAP Cube with the LinRegPoint MDX Function
During a discussion about OLAP cubes for Business Intelligence data visualization and analysis, I was asked if regression lines could be added to cubes as calculations within Analysis Services. I had previously browsed the MSDN pages for the MDX functions LinRegPoint and LinRegSlope, but since I had never used them I replied "You should be able to create a regression line as an SSAS calculation, but I've never actually tried to do so myself." I don't like qualifying a statement with "should be able to," so I did some research which has now evolved into this article.
Tags: mdx