Jaspersoft OLAP - Creating an Analysis View

Creating an Analysis View

(note: In more recent versions of the product (4.2 and later), OLAP data is available via Ad-Hoc. JPivot OLAP views, as described below, will ultimately be deprecated in favor of Ad-Hoc OLAP analysis - Please refer to the JasperReports Server User Guide and OLAP User Guides for more information)

This guide helps you to create your first Analysis View. It requires FoodMart data source, a MySQL database example provided when installing JasperReports Server, and an OLAP schema created with Jaspersoft OLAP Schema Workbench.

OLAP Schema

  1. Log into JasperReports Server. On the Home page, click on View > Repository.
  2. In the Repository manager, select the Analysis Schemas folder (Analysis Components > Analysis Schemas), click the Add Resource icon and click on Other > OLAP Schema.

    Figure 1

  3. Click on Browse to specify your OLAP Schema's path. Then do Next.
    Figure 2
  4. Give a Name and Label to your OLAP schema.
    Figure 3
  5. Click on Save. Your OLAP Schema has been uploaded in the Repository.
    Figure 4

Analysis Connection

  1. Select the Analysis Connections folder (Analysis Components > Analysis Connections), click the Add Resource icon and click on Other > Analysis Client Connection.
    Figure 5
  2. Select Mondrian Connection type then do Next.
    Figure 6
  3. Give a Name and Label to your connection then do Next.
    Figure 7
  4. In From the Repository, select mySchema then do Next.
    Figure 8
  5. This page shows the selected schema's informations. Do Next.
    Figure 9
  6. In From the Repository, select FoodMartDataSource then do Next.
    Figure 10
  7. Select None then do Next.
    Figure 11
  8. Click on Save.
    Figure 12
  9. Your Analysis Connection is created.
    Figure 13

Analysis View

  1. Select the Analysis Views folder (Analysis Components > Analysis Views), click the Add Resource icon and click on Other > Analysis View.
    Figure 14
  2. Give a Name and Label to your view then do Next.
    Figure 15
  3. Select Mondrian Connection type then do Next.
    Figure 16
  4. In OLAP Client Connection from Content Repository, select myConnection then do Next.
    Figure 17

  5. Write the following MDX query then do Next.

    SELECT {
      [Measures].[product number],
      [Measures].[class number]
}  ON COLUMNS,
{
      [Product].children
}  ON ROWS
FROM Products
    Figure 18
  6. Click on Save.
    Figure 19
  7. Your Analysis View is created.
    Figure 20
    Figure 21

See also...

Feedback