Monday, July 12, 2010

Explain relation between dimension and fact?


Facts are the metrics that business users would use for making business decisions. Generally, facts are mere numbers. The facts cannot be used without their dimensions. Dimensions are those attributes that qualify facts. They give structure to the facts. Dimensions give different views of the facts. In example of employee expenses, the employee expense forms a fact. The Dimensions like department, employee, and location qualify it. Facts are like skeletons of a body. Skin forms the dimensions. The dimensions give structure to the facts.

No comments:

Post a Comment


All Rights Reserved @ Raju Das