Interested to Buy Any Domain ? << Click Here >> for more details...
Are facts same as metrics and dimensions same as measures?
If not , please tell the difference?
- 1 Answers
- 8521 Views
- Patni, I also Faced
- E-Mail Answers
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 degenerate dimension table?
What are the design methods of data warehousing?
How can you implement many relations in star schema model?
Ist the schema that a data warehouse system can implements.
Explain the hierarchies level data warehousing.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is the function of etl when used in data warehousing?
Explain what are the mapping paramaters and maping variables?
Explain what is the extension of file to save template?
How to add a number to a macro variable?
What is a view as it relates to system modeling?
What is scd1 , scd2 , scd3?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is the difference between ods and oltp?
