Now that we have a Mondrian schema created and published, we are ready to build our first analysis report and use the power of Pentaho Analyzer. This recipe will show how to build a simple analysis from scratch using Pentaho Analyzer. Note that Pentaho Analyzer is a tool available only in the EE version of Pentaho.
To create a new Pentaho analysis report, perform the following steps:
To create a new Pentaho Analysis report, we can either click on the Create New button in the Home perspective and then click on Analysis Report, or we can select the Analysis Report option under the New option under the File PUC menu.
The Select Data Source dialog box appears. Choose the analysis data source named Cookbook Sample Schema and click on OK.
Let's build a simple analysis report. From the Product dimension, drag-and-drop the Product Department level to the Rows Fields layout zone. From the Time dimension, get the Quarter level and drag-and-drop...