Cross tabs allow you to view dimensional data in a report. Using cross tabs, you can easily view two or more fields and how they relate based on a measure. For instance, you may want to see how much sales each sales person is doing during the course of a week, and a cross tab allows you to present that data easily, as shown in the following table:
Sales Person 1 |
Sales Person 2 | |
---|---|---|
Day 1 |
$1,240 |
$1,100 |
Day 2 |
$1,400 |
$1,000 |
Pentaho Reporting offers the ability to create cross tab-based reports. These are a special type of report that render differently than most standard reports. These reports also expect the data to be in a particular format. Traditionally, cross tab reports are driven by multidimensional queries. As highlighted in Chapter 5, Pentaho Reporting offers a Mondrian and olap4j DataFactory
for providing multidimensional data to a report. Use the DenormalizedMDXDataFactory
to populate a cross tab report. This Data Factory flattens out an MDX result set. The following...