How to create OLAP Analytically view in TIBCO JasperReports® Server Community Edition

Introduction

Below it the sample of Analytical View in TIBCO JasperReports^® Server Community Edition

Download the JaspersoftOLAP-Workbench from the below link.

• http://kaz.dl.sourceforge.net/project/jasperserver/JasperServer/JasperServer%204.0.0/JaspersoftOLAP-Workbench-cp-4.0.0.zip

Open: C:JaspersoftOLAP-Workbench-cp-4.0.0JaspersoftOLAP-Workbench-cp-4.0.0JaspersoftOLAP-Workbench-cp-4.0.0workbench.bat

Create a Database Connection and OLAP Schema:

Generate MDX Query

Auto generate the MDX Query and separately save as it requied to use at the time of create OLAP view on server.

Follow the below All step one by one to upload the OLAP Schema on TIBCO JasperReports^® Server.

1. Create the connection to the sample Foodmart database

   

2. Next, Create each level of the OLAP Schema

   

   

   

   

   

   

   

   

   

3. After follow the above all steps, SAVE the OLAP Schema with .xml extenstion.

   • Download / Install JasperReports^® Server Community Edition follow the steps below:

     

1. Create an Analysis Schema

   

2. Create an Analysis Data source.

   Create JDBC Connection.

   

3. Create OLAP Client Connection and configure Schema and Datasource.

   

   Configure Schema and Datasource.

   

4. Create OLAP Analysis View

   

   Configure Connection Name which you have specified and provided MDX query whcih auto generated with Jasper Workbench. More detail recheck above section of (Generate MDX Query)

   

Now It is very easy to work with OLAP Analysis view.  ^_^