OLAP


Also found in: Dictionary, Thesaurus, Medical, Financial, Acronyms.
Related to OLAP: data mining, OLAP cube

OLAP

OLAP

(OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. They enable users to drill down into masses of sales statistics in order to isolate products that are the most volatile.

OLAP and MOLAP
Traditional OLAP products are also called "multidimensional OLAP" (MOLAP) because they summarize transactions into multidimensional views ahead of time. Data are organized into a cube structure that can be rotated by the user, which is particularly suited for financial summaries. Queries are fast because the consolidation has already been done.

Relational OLAP (ROLAP)
Relational OLAP tools extract data from relational databases. Using complex SQL statements against relational tables, ROLAP is able to create multidimensional views on the fly. ROLAP tends to be used on data that has a large number of attributes, where it cannot be easily placed into a cube structure. For example, customer data with numerous descriptive fields are typically ROLAP candidates, rather than financial data.

Database OLAP and Web OLAP (DOLAP and WOLAP)
A database OLAP refers to a relational DBMS that is designed to host OLAP structures and perform OLAP calculations. Web OLAP refers to OLAP data that is accessible from a Web browser. See MDX.
References in periodicals archive ?
Today's release of the IBM DB2 OLAP Server marks a significant milestone for IBM, ShowCase and the thousands of AS/400 customer organizations who will benefit from the power of this fully integrated server platform to meet their rapidly growing Business Intelligence and analytic needs," saID Ken Holec, president and chief executive officer, ShowCase Corporation.
Pentaho Spreadsheet Services allows business users to access OLAP data in Pentaho Analysis Services using Microsoft Excel's PivotTable capabilities.
Together, the companies have combined Simba's expertise in ODBO, XMLA, and MDX with Pentaho's expertise in open source technology and OLAP.
By joining with Pentaho we have the opportunity to take the Mondrian OLAP Server to a much higher level - backed by Pentaho's vision, experience, and professional support, services and development resources.
The OLAP Survey 3, the largest and most detailed survey of OLAP products to date, is a quantifiable survey of the $3.
With this upgrade, SPSS has made a significant investment in advancing the scalability and security of OLAP Hub," said Rod Reicks, product manager for SPSS Inc.
The OLAP Report, which has delivered in-depth guidance for buyers of Online Analytical Processing (OLAP) solutions since 1995, provides detailed information about OutlookSoft's product architecture, platform and application-specific functionalities.
Hyperion certified Applied OLAP as a Platinum Technology Partner for its flagship product ActiveOLAP for Essbase.
With this functionality enabled, Advisor Series users will be able to create OLAP cubes from their Advisor Series data and view them via the Advisor Series reporting module or any third-party cube viewer that supports Microsoft Analysis Services.
OLAP ASAP takes advantage of the new Microsoft SQL Server Accelerator for Business Intelligence to jumpstart the development of new business intelligence applications.
As the database markets move toward convergence, with relational database vendors increasingly integrating OLAP into their products, our customers need to include OLAP as a portion of their overall enterprise data warehouse and BI projects," said Crispin Read, vice president of product marketing at Business Objects.