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



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 is drilling across?

0 Answers  


three ways sql*loader could load data, what are those three types?

1 Answers  


Explain Association algorithm in Data mining?

0 Answers  


What are modeling tools available in the market?

0 Answers  


Can we have multiple application.cfm file in an application?

0 Answers  






I need a good brd and uc template?

0 Answers  


What are the different types of datawarehosuing?

0 Answers  


What is the difference between view filter and report filter?

0 Answers  


Why we use repository connectivity?

0 Answers  


"A dimension table is wide but the fact table is deep," explain the statement in your own words.

0 Answers  


What is the difference between a primary and secondary actor in use case modeling?

0 Answers  


Explain what is the advantages data mining over traditional approaches?

0 Answers  


Categories