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 |
Explain the difference between filter and conditin?
How can you communicate with web server (apache or iis) from coldfusion?
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
explain about dirty dimension?
What is is a star schema?
What is bi?
What is data stream and data adaopter. Is it same are different? Explain?
How can you set the client management?
Which are the olap tools available that are supported by oracle?
What is data validation strategies for data mart v?
Explain the data type of the surrogate key?