What is an OLAP CUBE?
OLAP simply translated into Online Analysis Processing , it is the process of viewing data in a multi-dimensional format i.e. slicing and dicing of data from various multiple perspectives.
It involves the deployment of both fact and dimensional tables. Many enterprise business use OLAP to view their performance against diverse variables such as sales by locations by a given quarter.
I have personal experiences with the application of OLAP systems in various data warehousing projects in which i have undertaken in the past. It is feels pretty good to harness the rich capabilities that an OLAP system brings into the business . Some of the features of an OLAP includes hierarchies look ups,drill through of data, slicing and dicing of data etc.
Why you need an Online Analysis Processing System
Many contemporary dashboards reports are built on existing OLAP systems, Your ROI upon the adoption of an OLAP systems for your business would be very huge (i.e if you don’t have one already)
Some OLAP vendors