What is OLAP?

The OLAP Council defines OLAP as:
"... a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user."


Data Based Advisor (article: Dec 1995 v13 n11 p38)
"OLAP spells success for users and developers"
"OLAP lets you give users easy, intuitive access to their data and make them self-sufficient. They can generate almost any analysis without intervention from IS and get out of the report-writing business. Users will be in control of their information--and they'll love you for it."


DBMS Magazine (article: August 1995 v8 n9 p40)
"The Truth About OLAP"
OLAP/multidimensional analysis "involves representing data (typically summary data) as user-defined dimensions, not tables. For example, a sales analysis database organizes data by product, territory, customer, and other dimensions. Dimensions are almost always related in hierarchies, and a multidimensional database can have multiple hierarchies. Product hierarchies can range from general groupings such as hardware, software, and services down to individual products. Geographic hierarchies can range from continents or countries down to sales offices or even individual salespersons. Time is common to almost all analytical applications, so most multidimensional servers have built-in time hierarchies (they know that weeks roll up into months) plus the ability to define custom accounting cycles."


Open Information Systems (article: Feb 1996 v11 n2 p3)
"Approaches to OLAP"
"On-line Analytical Processing (OLAP), has gained industry-wide acceptance as a powerful mechanism for enabling users to identify and understand the key trends and events driving their businesses. Users in every industry and functional department (i.e., finance, sales, marketing) have begun using OLAP tools to rapidly sift through and analyze large amounts of data that companies are making available to them. via data warehouses or staged data sets. OLAP tools are helping business managers at all levels make better decisions quicker. This is translating into larger corporate profits, improved customer service, and increased competitiveness."