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
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 are the difference between snow flake and star schema?
How did you plan your Data ware house project?
Explain what is the difference between datawarehouse and bi?
What is data cleaning? How can we do that?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Difference between cold fusion 5 and cold fusion mx 6?
What is the 4 + 1 view model as it relates to system modeling?
Which are the olap tools available that are supported by oracle?
What are the different types of data warehousing?
What is recovering sessions?
Explain can a dimension table contains numeric values?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain what is ods (operation data source)?
What is data stream and data adaopter?