OLAP functionality is characterized by dynamic multi-dimensional analysis of consolidated enterprise data, supporting end user’s analytical and navigational activities. OLAP adds tremendous value to your BI applications by making analysis easier, faster and user-friendly for your business users.

OLAP schemas are used in order to enhance performance and provide drill-down functionality without much effort on the users’ side. The real power of OLAP is in the ability to drill down on a category to see more details. For example, you might drill down on a state to see details by city. An OLAP cube is a technology that stores data in an optimized way to provide quick response to queries by dimension and measure. Most cubes pre-aggregate measures by the different levels of categories in the dimensions to enable quick response time.

Pentaho uses Mondrian cube at the backend. Pentaho Schema workbench is a tool provided by Pentaho that enables the creation of OLAP Schema through a graphical interface. It allows a developer to create a pre-definied structure for faster reporting by aggregating the data and multithreading the process of retrieving the data from the database.

OLAP schemas enable a user to create analysis reports in Pentaho Analyser on the fly. Each OLAP schema is specifically created for a certain type of reporting, i.e., keeping in mind the kind of analysis that is going to be done on that data set.

We can help you in designing the business model on top of your Enterprise Data warehouse or data marts by understanding your business users’ data analysis requirements, expectations, trends and analysis patterns. We can design schema for your OLAP cubes, design virtual cubes and write MDX queries to retrieve data from OLAP cubes.

Get in touch with us to see a live demo of OLAP. Some of our client implementations on OLAP include works for Technip, SWTechnologies, EMNS to name a few.