The most important goal of OLAP application is analysis on data. The most important thing in any analysis are “NUMBERS”. So with OLAP application we would like to get those numbers, forecast them, analyze them for better business growth. These numbers can be total sales, number of customers etc.
These numbers are termed as “Measures” and measures are mostly stored in “Fact” tables.
“Dimension” describes what these measures actually mean. For example in the below table you can see we have two measures 3000 units and 1500 $. One dimension is “ProductWiseSales” and the other dimension is “AgewiseSalary’.
Dimensions are stored in dimension table.
| Dimension | Measures |
| ProductWiseSales | 3000 units |
| AgeWiseSalary | 1500 $ |
No comments:
Post a Comment