Answer Detail: RE: Attributes and Facts

GeekInterview.com > Interview Questions > Data Warehousing > MicroStrategy

Print |

Question: Attributes and Facts

Answer: Explain what is the difference between a Fact and an Attribute.

October 10, 2008 02:29:23	#1
vijaya_friendly	Member Since: October 2008 Total Comments: 2
RE: Attributes and Facts
Attribute is a Dimension. Attributes provide the business model with a context in which to report on and analyze facts. Ex: Month, Product, Customer, Year.. Fact is numeric and it is aggregatable. Examples of facts include sales dollars, units sold, profit, and cost.