Monthly Archives: March 2010

Brilliantly stupid MDX debugging technique

Whenever I do something really stupid, rather than keep it to myself, I prefer to blog about it for the entire world to see. Even better – I came up with a debugging technique to save myself from my own, … Continue reading

Posted in Analysis Services, MDX, OLAP, SQL Server | Leave a comment

Devils and Angels of BI Architecture

Devil: You don’t need to set up a separate star schema databaseAngel: Yes you do. We don’t want to  interfere with the operational systemsDevil: It’s sooo much workAngel: We want to create a simplified schema to benefit our end usersDevil: … Continue reading

Posted in Business Intelligence, Modeling/Architecture, SQL Server | Leave a comment