Have a modeling problem here... first the back-story... We deal with accident data on our project, 1 vehicle-crash can have multiple people and vehicles involved, and many associated factors across ...
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it. I tried to design a star ...
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas. In my warehouse, I've got two different fact tables that tracking daily changes ...