Tag Archives: MDX

Polynomial Regression MDX

About a year and a half ago I posted a blog on the value of correlations and the CORRELATION MDX function titled, Find and Measure Relationships in Your OLAP Cubes.¬†However, the CORRELATION function calculates only linear relationships, which means that … Continue reading

Posted in BI Development, SQL Server Analysis Services | Tagged , , , , , | Leave a comment

An MDX Outlier Solution

Introduction Anomalies in data can skew analysis leading to incorrect conclusions and subsequent actions that could be useless or even damaging as it will address the wrong problem. Anomalies in data are usually¬†attributed to human data entry error or perhaps … Continue reading

Posted in BI Development, SQL Server Analysis Services | Tagged , | Leave a comment