Category: 

What is OLAP?

Article Details
  • Written By: David White
  • Edited By: Niki Foster
  • Last Modified Date: 19 November 2016
  • Copyright Protected:
    2003-2016
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Although they mainly functioned as downspouts, gargoyles were also intended to scare people into attending church.  more...

December 3 ,  1989 :  The Cold War officially ended.  more...

One of the effects of business growth is a mountain of data that has to be manufactured, stored, tracked, and interpreted. A growing business needs sophisticated methods of data processing. One of the ways that businesses do this is to use OLAP.

OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting. Using OLAP, businesses can analyze data in all manner of different ways, including budgeting, planning, simulation, data warehouse reporting, and trend analysis. A main component of OLAP is its ability to make multidimensional calculations, allowing a wide and lightning-fast array of possibilities. In addition, the bigger the business, the bigger its business reporting needs. Multidimensional calculations enable a large business to complete in seconds what it otherwise would have waited a handful of minutes to receive.

One main benefit of OLAP is consistency of calculations. No matter how fast data is processed through OLAP software or servers, the reporting that results is presented in a consistent presentation, so executives always know what to look for where. This is especially helpful when comparing information from previous reports to information contained in new ones and projected future ones. "What if" scenarios are some of the most popular uses of OLAP software and are made eminently more possible by multidimensional processing.

Ad

Another benefit of multidimensional data presentation is that it allows a manager to pull down data from an OLAP database in broad or specific terms. In other words, reporting can be as simple as comparing a few lines of data in one column of a spreadsheet or as complex as viewing all aspects of a mountain of data. Also, multidimensional presentation can create an understanding of relationships not previously realized. All of this, of course, can be done in the blink of an eye.

Producers of OLAP software are familiar, including Oracle, IBM, and Hyperion Solutions. Oracle, which has a reputation for being different, refers to OLAP software as Business Intelligence. IBM and Hyperion Solutions, wishing to remain consistent with industry standards, call their software OLAP.

Ad

You might also Like

Recommended

Discuss this Article

everetra
Post 4

@Mammmood – OLTP deals with the back-end (databases) and OLAP deals with the front-end. That’s an over-simplification, I suppose, but that’s what it boils down to. If you’re an analyst you’ll be working with OLAP. If you’re a DBA, you’ll be dealing with OLTP.

Mammmood
Post 3

What is the difference between OLTP vs OLAP? I get the two confused.

nony
Post 2

@ allenJo - Multidimensional OLAP is amazing! I use it too where I work. It took me awhile to get used to using SQL to create the multidimensional views of the data. We use Oracle 10g for the back-end but Microsoft has their own product too I believe.

allenJo
Post 1

This is a good birds-eye view of the subject. I’m not an expert, but I did have to do some reporting for the executives at my old company. We had two days of training in business intelligence OLAP software. It was some pretty impressive stuff. I was able to use cubes, metrics, graphs and other visual graphics that really blew away the big guns at corporate. I wasn’t directly responsible for OLAP reporting, but was one of five users in our department.

I.T. managed the data warehousing end of the OLAP system. I think they were using Oracle at the time. I was just involved in the OLAP analysis and had to deliver the ad hoc reports to the executives.

Post your comments

Post Anonymously

Login

username
password
forgot password?

Register

username
password
confirm
email