OLAP (On-Line Analytical Processing) is a technology that provides solution to three fundamental reporting problems:
1. Slowly running reports. For example, calculating totalsales for all products might take very long time. Moreover, each report might keep calculating the same value all over again. To resolve this problem, OLAP can store all possible totals in summary(aggregation) tables. The aggregations are usually re-calculated daily or hourly.
2. Report Explosion. The number of possible static reports that can be created from a database may be too large. Forexample, we have a sales table with three columns: product, date and dollars. Suppose that we sell just 10 products and we have just 10 days worth of data. We can have 29 possible reports:1. Total sales
2. Total sales by product
3. Total sales by product for each day - 10 reports
4. Total sales by date
5. Total sales by date for each product - 10reports
6. Total sales by date (rows) and product (columns)
7. Total sales by date (columns) and product (rows)
8. Total sales by date (rows) and product (rows)
9.Total sales by product (rows) and date (rows)
10. Total sales by date (columns) and product (columns)
11. Total sales by product (columns) and date (columns)
If we are to add anadditional column: "customer name" to our table, the number of possible reports would increase exponentially. Because an average organization can have much more than three columns associated with its sales,the number of possible reports can approach or exceed trillions!
OLAP technology allows users to design and modify reports themselves via a simple drag and drop interface, eliminating the need ofhaving an "army" of report writers on staff.
3. Statistical calculations are usually not supported by a relational database. For example, SQL (Structured Query Language) requires users to run...