SQLBlog Nederland Business Intelligence & Datawarehousing

It’s been a while since my last article. I’ve been busy working on a lot of small projects. One of these was determine the market share of a single office in the country, compared to competitors. The data I needed for this project was postal code data per office and …

I had some subscriptions staying in the “Pending” LastStatus. It took me a lot of time to fix this problem. This blog will give you the solution for the  problem.

Like the title says; my SSAS OLAP cube (SQL 2008R2) was giving me wrong results when selecting a combination of a measure and a fact. I was struggling for days with this issue. I called old colleagues, reading a lot of articles online but no solution yet.