ONLINE ANALYTICAL PROCESSING (OLAP)

ABSTRACT

OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability
for complex calculations, trend analysis, and sophisticated data modeling. It is quickly becoming the fundamental foundation for Intelligent Solutions
including Business Performance Management, Planning, Budgeting, Forecasting,Financial Reporting, Analysis, Simulation Models, Knowledge Discovery, and Data Warehouse Reporting. OLAP enables end-users to perform ad hoc analysis of data in multiple dimensions, thereby providing the insight and understanding they need for better decision making. Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad hoc queries with a rapid execution time.