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 |
How to performance tune reports?
What is the difference between junk dimension and degenerated dimension?
Is it possible to have more than one row on the same table with the same foreign key?
What are the various transformation available?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
How many types of facts and what are they?
How can we import and export using BCP utility?
what are the other factors of the database on which the loading performance depend?
What are the types of partitioning?
Explain the difference between keylokup and joiner?
What is Time Series algorithm in data mining?
Name at least three brands of Database Management Systems