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.

   

3. Click on Browse to specify your OLAP Schema's path. Then do Next.

   

4. Give a Name and Label to your OLAP schema.

   

5. Click on Save. Your OLAP Schema has been uploaded in the Repository.

   

Analysis Connection

1. Select the Analysis Connections folder (Analysis Components > Analysis Connections), click the Add Resource icon and click on Other > Analysis Client Connection.

   

2. Select Mondrian Connection type then do Next.

   

3. Give a Name and Label to your connection then do Next.

   

4. In From the Repository, select mySchema then do Next.

   

5. This page shows the selected schema's informations. Do Next.

   

6. In From the Repository, select FoodMartDataSource then do Next.

   

7. Select None then do Next.

   

8. Click on Save.

   

9. Your Analysis Connection is created.

   

Analysis View

1. Select the Analysis Views folder (Analysis Components > Analysis Views), click the Add Resource icon and click on Other > Analysis View.

   

2. Give a Name and Label to your view then do Next.

   

3. Select Mondrian Connection type then do Next.

   

4. In OLAP Client Connection from Content Repository, select myConnection then do Next.

   

5. Write the following MDX query then do Next.

   SELECT {
         [Measures].[product number],
         [Measures].[class number]
   }  ON COLUMNS,
   {
         [Product].children
   }  ON ROWS
   FROM Products
   

6. Click on Save.

   

7. Your Analysis View is created.

   

   

See also...

• Getting Started with Jaspersoft OLAP.