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 |
how do you use commit frequencies? how does it affect loading performance?
Explain what is fact less fact table? Where you have used it in your project?
What are the approaches used by optimizer during execution plan?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What are the steps of implementing data warehousing?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What Oracle features can be used to optimize my Warehouse system?
What are the data marts?
What is a data warehousing?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is difference between e-r modeling and dimensional modeling?
What is the difference between a primary and secondary actor in use case modeling?