What is an Online Analysis Processing System?


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




Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s