OLAP Cube

OLAP Cube

olap
olap1

  • Online Analytical Processing is a consolidated multi-dimensional data model which allows users to easily extract and view data from different points of view. Each and every Dimension are linked to Measures using primary keys which creates One-to-Many relation.
  • It has a rapid execution time as it gets built in accordance to all the relations between the Dimensions and Measures (Aggregated Numeric Data) and is even smaller-on-Disk space which makes it agile in response.
  • With its 3 building capabilities, FULL, INCREMENTAL, and CONSOLIDATED it gets easier for users to refresh the data in the cube as per the frequency of data load.