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
Explain grouped cross tab?
Can you pass sql queries in filter transformation?
What are the different types of data warehouses?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What does level of granularity of a fact table signify?
How to export mappings to the production environment?
What are the key columns in Fact and dimension tables?
What are diagrams?
What are the data types present in bo?
What is Sequence clustering algorithm?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to design file watch jobs?
if you use oracle sql*loader , how do you transform data with it during loading?
What is dimension modeling?
What are the differences between star and snowflake schema?