Cross tab examples

As a couple of examples, let's show two basic reports using cross tabs: the first using an MDX query showing sales per year and market, and the second using a SQL query showing actual, budget, and variance per region and department. To show a different type of cross tab report, the second example will show multiple measures.

To begin with the first example, using the MDX query, let's start with an empty report (click on the blank report icon () in the Report Designer) and a Pentaho Analysis data source created as described in Chapter 6Configuring JDBC and Other Data Sources. The Pentaho Analysis data source is supposed ...

Get Pentaho 8 Reporting for Java Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.