Monthly Archives: July 2012

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

Deactivated my Facebook Account

I deactivated my Fascbook account. I promised myself that I would do so if they ever censored one of my posts, as had been experienced by others. It appears that they did so today. In fairness, I don’t think we … Continue reading

Posted in Uncategorized | 1 Comment