Category Archives: SQL Server Analysis Services

Protected: Draft: Update to “Is OLAP Terminally Ill?”

There is no excerpt because this is a protected post.

Posted in BI Development, SQL Server Analysis Services

Is OLAP Terminally Ill?

Someone told me yesterday that “OLAP is dead”. “Everyone is choosing tabular/in-memory.” I know it’s not dead, maybe at least sick. But did I underestimate the time of the tipping point, the curve in the hockey stick, where the vast majority of … Continue reading

Posted in SQL Server Analysis Services | Tagged | 12 Comments

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

Securing a Dimension with Members Having the Same Name

Here’s an SSAS security issue that doesn’t come up very much at all. In fact, when this recently came up, I had forgotten about a solution I provided way back in 2005 (which was the only other time I’ve encountered … Continue reading

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

Thoughts Around “Aggregate Fact Tables”

I’ve encountered many situations where some set of complications in a cube model were eased by using an aggregation table derived from some base fact table as the fact table. The complications leading to that choice usually include expensive on-the-fly … Continue reading

Posted in BI Development, SQL Server Analysis Services | 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

Find and Measure Relationships in Your OLAP Cubes

Huge strides in the value proposition of BI will come by jumping the chasm from simply reporting on data provided by the integrated view of our enterprise to discovering novel and perhaps counter-intuitive relationships hidden in that data. With the discovery of such relationships, we … Continue reading

Posted in BI Development, Cutting-Edge Business Intelligence, Data Mining and Predictive Analytics, SQL Server Analysis Services | Leave a comment