What is a Dimension!! No, seriously What is a Dimension

Happy Thanksgiving

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!! 



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s