Are facts same as metrics and dimensions same as measures? If not , please tel

Are facts same as metrics and dimensions same as measures?
If not , please tell the difference?

Question Posted / benitaannbabu

1 Answers
8555 Views
Patni, I also Faced
E-Mail Answers

Are facts same as metrics and dimensions same as measures? If not , please tell the difference?..

Answer / rajiv

See, facts are usually metrics i.e facts can used to show
in metrics reports as they are means to measure the
data.For example:Sales revenue, profit,margin,total count
etc..

And dimensions are not measures.They are for example
objects like customer name, employee name, age, phone
number,salesid etc..
Dimensions are the means of analysis and analysis is done
on them.So they are entirely different from measures

Is This Answer Correct ?

6 Yes

0 No

Post New Answer

More Data Warehouse General Interview Questions

What are the various transformation available?

0 Answers

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

0 Answers

Define Data Warehousing?

0 Answers Wipro,

Why is business intelligence (bi) important in data warehousing?

0 Answers

Can decision tree be implemented using SQL?

0 Answers

What are the primary ways to store data in OLAP?

3 Answers

Suggest a good author for hyperion in data warehousing?

0 Answers

Explain what is the difference between power center & power mart?