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
EDIT: The schema is working for Jasper Reports Server OLAP view. Still can't use it in iReports or Report Designer. Any suggestions?
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
I found the 4.0.0 in this forum : https://community.jaspersoft.com/questions/823877/jaspersoft-olap-designer
But in my opinion Pentaho Schema Workbench is better to design Mondrian schemas : https://sourceforge.net/projects/pentaho/files/Pentaho%208.2/client-tools/psw-ce-188.8.131.52-342.zip.sum/download