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 |
What is drilling across?
three ways sql*loader could load data, what are those three types?
Explain Association algorithm in Data mining?
What are modeling tools available in the market?
Can we have multiple application.cfm file in an application?
I need a good brd and uc template?
What are the different types of datawarehosuing?
What is the difference between view filter and report filter?
Why we use repository connectivity?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is the difference between a primary and secondary actor in use case modeling?
Explain what is the advantages data mining over traditional approaches?