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
Can you state some of the innovations throughout history?
What is Sequence clustering algorithm?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what are the steps to build the data warehouse?
Explain what is full load & incremental or refresh load?
What is application.cfm?
Explain how to generate iqd file from framework manager?
How many types of facts and what are they?
What are snapshots? What are materialized views & where do we use them?
What are the different types of join operations?
What are the types of partitioning?
What is the use of tabular model, tabular sql, tabular reference in real time application?
what are the other factors of the database on which the loading performance depend?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What is a data profile?