Create OLAP Cubes with Jaspersoft

[deamo]

Hi,

I have been searching for some days and I still have a doubt: is it possible to create OLAP Cubes with the Community version of Jaspersoft? 

All informations and tutorials I found are showing how to ETL data from i.g. SQL and how to create simply reports with information directly extracted from these tables.

My aim is to create an OLAP Cube from a SQL Database (Data Warehouse) and then create some reports (dynamic), in which I can the information in "real-time" filter, where the filters are my predefined OLAP dimensions in the Cube.

Thank you for your help.

 

Albert.

[sadakar]

Yes, it is possible with community version of jasper. You need to download Jasper Schema work bench tool to develop OLAP cubes. Alternatively you can also use pentaho schema work bench tool. This a desk top stand alone tool to develop dimensional modeling on top of RDBMS. There are seris of steps to ulopad the developed OLAP file ( we call it as schema file (an xml file)) to the jasper server. Using Analyzer in the server you can see the output and generate MDX queries. Using those queries you can design your reports and can add filters where ever you need to pass.

[deamo]

Thank you for your answer sadakar!

So with the package Jaspersoft Server + Jaspersoft Studio + ETL is only possible to create a Datawarehouse and some SQL-Reports, isn´t it?

I would like to create a complete BI project: Starting from my SAP or Excel Data through a Datawarehouse, a multidimensional OLAP Database and finally show these cubes in some dynamic reports with all kind of filters.

 How would you join all these aspects with the Jaspersoft community version? Do you know where I can find a tutorial? Without it, I can not make it.

Thank you.