Archive for June, 2010

Granularity in Dimensional Modelling

It’s been a while since I worked on an interesting Business Intelligence problem, so a recent distraction has proved most stimulating. The reason for this post is a question I’ve had to consider many times in the past: should I design my schema by looking at the reports I’ve been asked for, or is there some other driving force to help me identify “the grain” of a dimensional model? Read the rest of this entry »


Leave a comment