This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)
This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view.(February 2022) (Learn how and when to remove this message)
This article appears to contain a large number of buzzwords. There might be a discussion about this on the talk page. Please help improve this article if you can.(February 2022)
(Learn how and when to remove this message)
In computing, online analytical processing, or OLAP (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries.[1] OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining.[2] Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM),[3] budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture.[4]
The term OLAP was created as a slight modification of the traditional database term online transaction processing (OLTP).[5]
OLAP tools enable users to analyse multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing.[6]: 402–403 Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. For example, all sales offices are rolled up to the sales department or sales division to anticipate sales trends. By contrast, the drill-down is a technique that allows users to navigate through the details. For instance, users can view the sales by individual products that make up a region's sales. Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints. These viewpoints are sometimes called dimensions (such as looking at the same sales by salesperson, or by date, or by customer, or by product, or by region, etc.).
Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad hoc queries with a rapid execution time.[7] They borrow aspects of navigational databases, hierarchical databases and relational databases.
OLAP is typically contrasted to OLTP (online transaction processing), which is generally characterized by much less complex queries, in a larger volume, to process transactions rather than for the purpose of business intelligence or reporting. Whereas OLAP systems are mostly optimized for read, OLTP has to process all kinds of queries (read, insert, update and delete).
^Codd E.F.; Codd S.B. & Salley C.T. (1993). "Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate" (PDF). Codd & Date, Inc. Retrieved March 5, 2008.[permanent dead link]
^Deepak Pareek (2007). Business Intelligence for Telecommunications. CRC Press. pp. 294 pp. ISBN 978-0-8493-8792-0. Retrieved March 18, 2008.
^Apostolos Benisis (2010). Business Process Management:A Data Cube To Analyze Business Process Simulation Data For Decision Making. VDM Verlag Dr. Müller e.K. pp. 204 pp. ISBN 978-3-639-22216-6.
^Cite error: The named reference ahsan was invoked but never defined (see the help page).
^"OLAP Council White Paper" (PDF). OLAP Council. 1997. Retrieved March 18, 2008.
^O'Brien, J. A., & Marakas, G. M. (2009). Management information systems (9th ed.). Boston, MA: McGraw-Hill/Irwin.
^Hari Mailvaganam (2007). "Introduction to OLAP – Slice, Dice and Drill!". Data Warehousing Review. Retrieved March 18, 2008.
and 28 Related for: Online analytical processing information
In computing, onlineanalyticalprocessing, or OLAP (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. OLAP is part...
real-time (process transactions). The term is contrasted with onlineanalyticalprocessing (OLAP) which instead focuses on data analysis (for example planning...
Excel pivot tables include the feature to directly query an onlineanalyticalprocessing (OLAP) server for retrieving data instead of getting the data...
(columnar database management system) for onlineanalyticalprocessing (OLAP) that allows users to generate analytical reports using SQL queries in real-time...
decisions. Business intelligence is querying, reporting, online analyticalprocessing (OLAP), and "alerts". In other words, querying, reporting, and OLAP...
An OLAP cube is a multi-dimensional array of data. Onlineanalyticalprocessing (OLAP) is a computer-based technique of analyzing data to look for insights...
from 1999 to 2002. Tableau products query relational databases, onlineanalyticalprocessing cubes, cloud databases, and spreadsheets to generate graph-type...
transactional (OLTP) applications and instead is specialized for onlineanalyticalprocessing (OLAP) workloads. DuckDB in its OLAP niche does not compete with...
functional language databases. The functional model is part of the onlineanalyticalprocessing (OLAP) category since it comprises multidimensional hierarchical...
Fact constellation is a measure of onlineanalyticalprocessing, which is a collection of multiple fact tables sharing dimension tables, viewed as a collection...
tables compare general and technical information for a number of onlineanalyticalprocessing (OLAP) servers. Please see the individual products articles for...
include reporting, onlineanalyticalprocessing, analytics, dashboard development, data mining, process mining, complex event processing, business performance...
system Since 2008, Exasol led the Transaction Processing Performance Council's TPC-H benchmark for analytical scenarios, in all data volume-based categories...
called facts) along some dimensions of interest. For example, in onlineanalyticalprocessing (OLAP) such dimensions could be the subsidiaries a company has...
(XMLA) is an industry standard for data access in analytical systems, such as onlineanalyticalprocessing (OLAP) and data mining. XMLA is based on other...
Microsoft SQL Server Analysis Services (SSAS) is an onlineanalyticalprocessing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a...
F. Codd coined the term "on-line analyticalprocessing" (OLAP) in a whitepaper that set out twelve rules for analytic systems (an allusion to his earlier...
two-dimensional panel data sets. Computer software for MDA include Onlineanalyticalprocessing (OLAP) for data in relational databases, pivot tables for data...
v t e Fast Analysis of Shared Multidimensional Information (FASMI) is an alternative term for OLAP. The term was coined by Nigel Pendse of The OLAP Report...
Enterprise Performance Management software which is used for planning, analytics and reporting in finance and other areas such as sales, human resources...
relational online transaction processing (OLTP) databases. On the other hand, graph compute engines are used in onlineanalyticalprocessing (OLAP) for...
Virginia, in the Washington metropolitan area. Its primary business analytics competitors include SAP AG Business Objects, IBM Cognos, and Oracle Corporation's...
Mondrian is an open source OLAP (onlineanalyticalprocessing) server, written in Java. It supports the MDX (multidimensional expressions) query language...
statistical analysis purposes. It is an OLAP (onlineanalyticalprocessing), instead of OLTP (online transaction processing) system. Modern decision, and classical...