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 |
Difference between slicing and dicing with example?
What is Cognos script editor?
What is data stream and data adaopter. Is it same are different? Explain?
Explain swot analysis?
Explain normalization?
What is difference macros and prompts?
Ist the schema that a data warehouse system can implements.
How to export mappings to the production environment?
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
After the complete generation of a report who will test the report and who will analyze it?
What is meta data and system catalog?