OLAP

(redirected from Online analytical processing)
Also found in: Acronyms, Wikipedia.

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 ?
The work revolved around building a financial reporting online analytical processing cube (a multidimensional dataset; this term will be explained in greater detail in the following section) and then using the technology to design the CAFR schedules.
The IT architecture and server configuration includes six main components: a structured query language database; the online analytical processing software; process execution; analysis services; reporting services; and integration services.
The project team designed and built one financial reporting online analytical processing cube that interfaces with Harris County's ERP system for data extraction.
Many spreadsheet users have heard about online analytical processing technology, but its meaning likely isn't clear to all readers.
Using a financial example, Harris County primarily uses two general ledgers in the online analytical processing software, 540 funds in the 2 ledgers, 90 departments, more than 2,700 balance sheet and income statement accounts, seven government functions, more than 5,600 organization cost centers (known as "keys"), and various versions of reporting, including adopted budget, adjusted budget, actual cash basis, actual modified accrual basis, and actual government-wide basis.
Putting it all together, Exhibit 5 illustrates the dimensions of the Harris County Auditor's Office online analytical processing cube, using sample members for illustration purposes.
As the foundation of GERS' Enterprise1, the Retail Data Warehouse leverages industry standard Online Analytical Processing (OLAP) tools to facilitate efficient, accurate, and timely analysis of transaction data and multi-year historical performance.
The Retail Data Warehouse leverages industry standard Online Analytical Processing (OLAP) tools to facilitate efficient and timely analysis of transaction data and multi-year historical performance.
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.
Embedded with technology components such as data warehousing, online analytical processing (OALP) and data mining, AsiaInfo's CRM solution can analyze data generated by any Business Operation Support System, providing telecom carriers with a highly flexible and powerful tool for decision making.

Full browser ?