Are facts same as metrics and dimensions same as measures?
If not , please tell the difference?
Answer Posted / 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 View All Answers
How can you set the client management?
What is data stream and data adaopter. Is it same are different? Explain?
What is the definition of cube in datawarehousing?
What we will do with the universe for faster process?
Can we take backup when the database is opened?
What are the different models used in cluster analysis?
Explain what is power center repository?
What is the difference between connected and unconnected stored procedures?
What is analytical or analytic mean?
Explain what are data marts?
Explain me what are data marts?
Explain what are the advantages of query studio compared to report studio?
What is the difference between ods and oltp?
What is the advantages data mining over traditional approaches?
What is data cleaning? How can we do that?