Category Archives: BI Development

The Effect Correlation Score for KPIs

Introduction Everything we do is intended to move us towards achieving some set of goals ranging from just satisfying our immediate hunger to achieving a revolution. These actions are executed within a strategy (or hierarchies of strategies) to varying extents of sensibility and organization. … Continue reading

Posted in BI Development | Tagged , , , , | Leave a comment

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

Problems with MDX’s STDEV Function

I spent quite a bit of time this morning wrestling with the quirkiness of MDX’s STDEV function (SQL Server Analysis Services 2008 R2). For the most part it works well, but there are a few things to know that will … Continue reading

Posted in BI Development | 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