Packt+ | Advance your knowledge in tech

You're reading from Pentaho 8 Reporting for Java Developers Create pixel-perfect analytical reports using reporting tools

Product type Paperback

Published in Sep 2017

Publisher Packt

ISBN-13 9781788298995

Length 470 pages

Edition 1st Edition

Languages

Java

Tools

Pentaho

Concepts

Data Processing

Authors (2):

Francesco Corti

Jasmine Kaur

View More author details

Table of Contents (18) Chapters

Preface

1. Introduction to Pentaho Reporting FREE CHAPTER

2. Getting Started with Report Designer

3. Getting Started with Reporting SDK

4. Creating a Report with Report Designer

5. Design and Layout in Report Designer

6. Configuring JDBC and Other Data Sources

7. Including Graphics and Charts in Reports

8. Parameterization, Functions, Variables, and Formulas

9. Internationalization and Localization

10. Subreports and Cross Tabs

11. The PRPT Format and the Java API to Build It

12. Developing Using Data Sources

13. Internationalization, Subreports, and Cross Tabs Using Java

14. Building Interactive Reports

15. Using Reports in Pentaho Business Analytics Platform

16. Using Reports in Pentaho Data Integration

17. Pentaho Reporting Nightly Build and Support

The OLAP data source

The Online Analytical Processing (OLAP) data source is used in case a multidimensional engine is involved.

Note

Quoting from Wikipedia about OLAP (https://en.wikipedia.org/wiki/Online_analytical_processing): a multidimensional structure is defined as a variation of the relational model that uses multidimensional structures to organize data and express the relationships between data. Even when data is manipulated it remains easy to access and continues to constitute a compact database format. A multidimensional structure is quite popular for analytical databases that use OLAP applications. Analytical databases use these databases because of their ability to deliver answers to complex business queries swiftly.

The Pentaho suite provides an open source multidimensional engine called Mondrian (http://community.pentaho.com/projects/mondrian). Mondrian is entirely written in Java and it executes queries written in the Multidimensional Expressions (MDX) language, reading data...