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 6, Configuring JDBC and Other Data Sources. The Pentaho Analysis data source is supposed ...