Dimensional Modelling Maxima Information Group Work

Modelling Change In Your Dimensions


You use dimension tables to hold the descriptive attributes that you want to use to analyse your measures.

This is fine but what do you do when this information changes? There are three common ways that you can handle changes in your dimensional model.

Ross Technology Work

Ideal Working Environment

My Home Office

I have just fine tuned my working environment and have come up with the ideal setup.

OK the monitor heights are a bit wonky but I very rarely span monitors, I like to have discrete items open in each and focus on one monitor at a time.

In this picture I have outlook split between monitors 1 & 2, thunderbird between 2 and 3 and firefox crossing all 3.

Photography Ross Technology This Site

Scary Mary !

Scary Mary !

I treated myself to an external flash for my camera, specifically a Nikon SB-800.

This allows me to play around with having the flash off camera. Mucking around produced the photo above, which also gives a sneak preview to the “face fungus” which I am currently cultivating.

As you may or may not know, i love the concept of openid which allows you to have a single authorisation location for multiple sites (including this blog). It also allows you to have a single profile page. It has just scared me the number of places where my profile photo may be, I’m going to spend the next hour seeing how many places I have put it!

OK, in 1 hour I have found 16 discrete sites, and I have not even started with the forums that I frequent !