One of my dimensions..
Last week, I had quite an interesting day at my office. Myself and my client got into a war room and sat down with a bunch of papers in one hand and a Teh-O (yes, Teh-O) in the other. We started off to design our dimensional model, and it went quite well for a while, when a question popped up; What is a Dimension. This is really an interesting one, and have not been asked by anybody for quite a while!!! I sat perplexed, and started explaining.
What in the world is a Dimension??
I could not really remember any definition all of a sudden, so I said smartly, a dimension is an information that defines a business event. (Quite well said, huh!!)
So, a series of questions followed soon. They came as
What is a business event?
To me again, a business event is any event we choose to record and associate a
measurable value. For instance, a sale at a store.
What is a Fact?
I started off again, it’s the structure where we store business events.
So guys, I would like to hear what a dimension and a fact means to you!!