This article was originally published to a blog which has been decommissioned.
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.
Continue reading this post at the following link: https://web.archive.org/web/20140219051005/http://blog.gnetgroup.com/bi/2013/03/26/create-regression-line-olap-cube-mdx-linregpoint/
Leave a Reply