Document Type


Lead Author Type

CIS Masters Student


Dr. Jonathan Leidig,

Embargo Period



In information technology, on-line analytical processing (OLAP) is an approach or technique to analyze the raw data in multi-dimensional analytical perspectives to provide summaries. OLAP consists of basic analytical operations such as consolidation (roll-up), drill-down, and slicing and dicing. This involves aggregation of data that can be accumulated and computed in one or more dimensions based on the data hierarchy. Typical applications of OLAP include "key performance indicators" i.e., does the current value satisfy the goal, business reporting for sales, marketing, management reporting, business process management (BPM), budgeting & forecasting, financial reporting. OLAP functionality depicts the multi-dimensional analysis of consolidated enterprise data supporting end user analytical and navigational activities including: calculations and modeling applied across dimensions, hierarchies, trend analysis over sequential time periods, and drill-down to deeper levels of consolidation.

OLAP encompasses:

  • Relational database

  • Report writing

  • Data mining

    Databases configured for OLAP uses a multi-dimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. They borrow aspects of navigational databases, hierarchical databases, and relational databases that allow business users to slice and dice data at will. Property Management Analytics (OLAP)

System is being developed for the in-house use for meeting business needs from time to time. This Property Management Analytics (OLAP) System will extensively be used by managers and service providers, which will help in making certain business decisions. It was developed for this audience to be able to provide better service. A key feature of this Property Management Analytics (OLAP) System is embedding business portability centralized to one system.