Where can I download the Workbench / Can I use Pentaho Worbench

Posted on May 16, 2013 at 6:43am

Hi there.

I tried to use a mondrian schema which i created in Pentaho Workbench. It contains three cubes with shared dimensions and a virtual cube.

I tried to use it in iReports. I added a JDBC Connection to a MySQL Database which contains the data of the cubes in form of star-schemas. Then I added an Mondrian Olap connection which makes use of the before created JDBC connection and selcted the XML file which contains the Olap Schema.

Connection works but when I use the Report Wizard and it comes to step 4. "Fields" there is nothing to select. The schema file workes for my in the Pentaho BI-Server and Pentaho Schema Workbench.

So my questions are:

Is there a difference between Pentaho Mondrian Schemas and Jasper Mondrian Schemas? Or does iReport maybe not support shared dimensions or virtual cubes?
I can't find a download link for Jasper Olap Workbench anywhere here?! Where is it?

Thanks & Regards

Heisenberg

EDIT: The schema is working for Jasper Reports Server OLAP view. Still can't use it in iReports or Report Designer. Any suggestions?

iReport Designer

Heisenberg

Joined: May 16 2013 - 12:22am

Last seen: 10 years 3 days ago

2 Answers:

Posted on May 20, 2013 at 12:59pm

You can get the OLAP workbench form here: http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.0.0/

Is esentialy the same as the standard mondrian OLAP workbench but matches the mondrian engine that is included in JasperReports Server.

You have the documentation about Jaspersoft OLAP here: http://community.jaspersoft.com/documentation/jaspersoft-olap-users-guide

marianol

16194

Joined: Sep 13 2011 - 8:04am

Last seen: 4 years 7 months ago

Note: If you have a comercial Jasperserver license you can download the OLAP workbench from http://support.jaspersoft.com

marianol - 10 years 1 week ago

Thanks for your answer. I think the document you posted is not very helpfull when it comes to reporting using OLAP.

However, I managed using my Mondrian Schema with iReports via a XML/A Connection. But still in the Reports Wizard there are no Fields to select. I don't know if it is a bug? Doesn't matter if I use the virtual cube of my schema, or a ordinary cube. I can use the fields if I build the report manually.

Heisenberg - 10 years 1 week ago

You can find the JAWorkbench v3.7 at: http://community.jaspersoft.com/wiki/jaworkbench-temporary-location

djohnson53 - 8 years 10 months ago

add comment