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 much memory space occupied real time project (roughly)?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Fact table is in normalized or de-normalized form?
What are the different methods of loading dimension tables?
What should I have in mind when building olap solution from scratch?
What are Non-additive facts?
What is data analytics in simple terms?
Explain normalization?
What are the various tools? Explain name a few?
What is metadata in context of a datawarehouse?
What are the steps involved in creating dimensional modeling process?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the difference between view materialized view and view?
Which are the olap tools available that are supported by oracle?
What are components of report studio?