O'Reilly logo

Pentaho Analytics for MongoDB Cookbook by Harris Ward, Joel Latino

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. A MongoDB OLAP Schema

In this chapter, we will cover these recipes:

  • Creating a date dimension
  • Creating an Orders cube
  • Creating the customer and product dimensions
  • Saving and publishing a Mondrian schema
  • Creating a Mondrian 4 physical schema
  • Creating a Mondrian 4 cube
  • Publishing a Mondrian 4 schema

Introduction

In this chapter, you'll learn how to create OLAP (short for Online Analytical Processing) schemas for Pentaho with MongoDB as a data source. OLAP is an approach to creating multidimensional analyses. Pentaho uses the ROLAP (short for Relational Online Analytical Processing) engine, called by Mondrian to convert MDX (short for Multidimensional Expressions) queries into SQL queries.

If you aren't a business intelligence consultant, you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required