The JasperAnalysis Workbench, available as a separate download, is a graphical desktop tool for building and
testing OLAP schemas. The generated schema files can then be uploaded to your JasperAnalysis server.
Download it at https://sourceforge.net/projects/jasperserver/files/JasperServer/JasperAnalysis-Workbench-3.5.4.zip
It comes with documentation on Mondrian and a user guide for the Workbench itself.
- Editor is aware of the schema structure, providing popup menus to add relevant schema elements and drop down combo boxes of correct values from the database schemas, tables and columns or other schema elements like Levels
- Validates and tests the schema against the underlying database
- JDBC Explorer allows inspection of database structure
- Multiple database connection management
- Runs MDX queries against the schema with grid display of results
- Automated generation of default MDX queries to aid testing
- Includes MySQL, Postgres and Ingres JDBC drivers: others can be added as needed
- User Guide includes a tutorial on using the Workbench to get to your first schema
Enjoy!
Sherman
Jaspersoft
Post Edited by swood at 07/01/2009 03:48
Post Edited by swood at 07/03/2009 03:07
14 Answers:
Posted on May 14, 2007 at 12:23pm
Man am I excited to finally get this! Huge step forward in terms of getting Jasper Analysis to be viable on our end.
I'm running into a problem at this point, however. It looks like at first glance I can't base a dimension on the fact table itself. We already aggregate all the data into one table and so I don't need to foreign key into another table in order to form my dimensions. (We're not likely to migrate to a star or snowflake schema database any time soon) Hence my need to be able to form my dimensions based on the fact table.
Any suggestions? I've looked at the docs and they neither mention this as a limitation or provide a resolution.
--Edit--
Looks like it does support degenerate dimensions... only it won't populate the drop-down after you've altered the table value within the dimension.
--Edit2--
Looks like this is an issue specific to MSSQL JDBC. MySQL behaves just fine.
Post edited by: Tharkad, at: 2007/05/15 12:04
I'm running into a problem at this point, however. It looks like at first glance I can't base a dimension on the fact table itself. We already aggregate all the data into one table and so I don't need to foreign key into another table in order to form my dimensions. (We're not likely to migrate to a star or snowflake schema database any time soon) Hence my need to be able to form my dimensions based on the fact table.
Any suggestions? I've looked at the docs and they neither mention this as a limitation or provide a resolution.
--Edit--
Looks like it does support degenerate dimensions... only it won't populate the drop-down after you've altered the table value within the dimension.
--Edit2--
Looks like this is an issue specific to MSSQL JDBC. MySQL behaves just fine.
Post edited by: Tharkad, at: 2007/05/15 12:04
Posted on July 27, 2007 at 8:29am
Hi:
I am used to Jasper Reports and have done fairly complex reports using the same. We want to try the Jasper Intelligence and build DWH solutions for our applications. How do I get access to the Work Bench - it does not appear to be a free download.
Can some one enlighten me on this?
With warm regards
Rams
:ohmy:
I am used to Jasper Reports and have done fairly complex reports using the same. We want to try the Jasper Intelligence and build DWH solutions for our applications. How do I get access to the Work Bench - it does not appear to be a free download.
Can some one enlighten me on this?
With warm regards
Rams
:ohmy:
Posted on July 27, 2007 at 7:02pm
Hi Rams-
You can find the existing JA Workbench under the JasperServer 1.2.1 release on JasperForge; it's a free download for the community and works fine on top of JasperAnalysis 2.0.
We are in the process of building a 2.0 version of the workbench with some new features and bug fixes; this should be released in the next few weeks.
Cheers,
Beth
You can find the existing JA Workbench under the JasperServer 1.2.1 release on JasperForge; it's a free download for the community and works fine on top of JasperAnalysis 2.0.
We are in the process of building a 2.0 version of the workbench with some new features and bug fixes; this should be released in the next few weeks.
Cheers,
Beth
Posted on August 13, 2007 at 3:19am
I. looking forward to trying it but cannot start ...
| Code: |
root@jbaird-laptop:/opt/schemaWorkbench# ./workbench.sh<br /> <br /> bash: ./workbench.sh: /bin/sh^M: bad interpreter: No such file or directory<br /> <br /> root@jbaird-laptop:/opt/schemaWorkbench# </td></tr></tbody></table></i><br /> <br /> Am I missing something?<br /> <br /> Thanks |
Posted on August 15, 2007 at 9:45pm
Hi!
You have a windows-line-ending file on a linux machine .. therefore, the ^M (which is CR, carriage return) is treated as part of the first line, and the shell cannot be found.
Normally, this should not happen, when you are using the system's unpacker to unpack the installation files ...
tar xzf ... for tar.gz on linux, even unzip should work on linux.
As first try, you can run dos2unix on the shell scripts (*.sh), this might help, if there are no more shell scripts around ... otherwise, try the .tar.gz (if available).
Also, it is not a good idea to work as root unless administrating the system ... use a user account with reduced rights. Avoids destroying the system ...
Hope this helps,
Sebastian
You have a windows-line-ending file on a linux machine .. therefore, the ^M (which is CR, carriage return) is treated as part of the first line, and the shell cannot be found.
Normally, this should not happen, when you are using the system's unpacker to unpack the installation files ...
tar xzf ... for tar.gz on linux, even unzip should work on linux.
As first try, you can run dos2unix on the shell scripts (*.sh), this might help, if there are no more shell scripts around ... otherwise, try the .tar.gz (if available).
Also, it is not a good idea to work as root unless administrating the system ... use a user account with reduced rights. Avoids destroying the system ...
Hope this helps,
Sebastian
Posted on July 1, 2008 at 11:13am
Hi Sherman
Could pls let me know how to implement drill-down on jasper report as we have developed few ireports and published into the jasper sever 2.1. i have a few queirs on jasper analysis.
Because we haven’t implemented/worked on jasper analysis
1) What is the workbench tool?
2) Can we do the drill-down in jasper server 2.1?
3) Can jasper server 2.1 supports Jasper analysis? It will be integrated with the jasper server or we need to download it separately?
4) How to migrate jasper server 2.1 reports to jasper server pro 3.0. (Any separate tool for migration)
Thanks in advance
regds
Mahi
Could pls let me know how to implement drill-down on jasper report as we have developed few ireports and published into the jasper sever 2.1. i have a few queirs on jasper analysis.
Because we haven’t implemented/worked on jasper analysis
1) What is the workbench tool?
2) Can we do the drill-down in jasper server 2.1?
3) Can jasper server 2.1 supports Jasper analysis? It will be integrated with the jasper server or we need to download it separately?
4) How to migrate jasper server 2.1 reports to jasper server pro 3.0. (Any separate tool for migration)
Thanks in advance
regds
Mahi
Posted on July 13, 2008 at 3:19am
The download link doesn't work for me. I've tried
http://www.jasperforge.org/index.php?option=com_docman&task=doc_download...
It opens a blank (white background) page in Firefox from China. It opens a blank (black background) page in lynx from Germany (which I login through ssh).
http://www.jasperforge.org/index.php?option=com_docman&task=doc_download...
It opens a blank (white background) page in Firefox from China. It opens a blank (black background) page in lynx from Germany (which I login through ssh).
Posted on July 14, 2008 at 7:50pm
There was a temporary problem; it was also noted in [url=http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&f... thread.
The original link is good again, but note that it redirects. So you should be able to use this link to directly get to the same place as the original link:
[url=http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=...
Regards,
Matt
The original link is good again, but note that it redirects. So you should be able to use this link to directly get to the same place as the original link:
[url=http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=...
Regards,
Matt
Posted on September 10, 2008 at 11:35pm
Hello Mahi,
Let me try answering your questions
Could pls let me know how to implement drill-down on jasper report as we have developed few ireports and published into the jasper sever 2.1.
-- User Hyperlink functionality to drill-down feature. it woks in JS Studio and JServer.
i have a few queirs on jasper analysis.
Because we haven’t implemented/worked on jasper analysis
1) What is the workbench tool? -- GUI Tool which allows you to easily design your OLAP schema/Cube.
2) Can we do the drill-down in jasper server 2.1? - Yes use Hyperlinks
4) How to migrate jasper server 2.1 reports to jasper server pro 3.0. (Any separate tool for migration)- May you can try import/export command for this.
Hope this helps,
Sure
Posted on April 1, 2009 at 6:27am
This is the correct workbench.sh file.......try this one to run workbench on linux!!
| Code: |
#!/bin/sh # mondrian jars CP="lib/commons-dbcp.jar:lib/commons-collections.jar:lib/commons-pool.jar" CP=$CP:"lib/eigenbase-properties.jar:lib/eigenbase-resgen.jar:lib/eigenbase-xom.jar" CP=$CP:"lib/javacup.jar:lib/log4j-1.2.12.jar:lib/mondrian.jar" CP=$CP:"lib/jlfgr-1_0.jar:lib/jmi.jar:lib/mof.jar:lib/commons-math-1.0.jar" CP=$CP:"lib/commons-vfs.jar:lib/commons-logging.jar" # Workbench GUI code and resources CP=$CP:"lib/workbench.jar" # local directory is ~/.schemaWorkbench if test ! -d ~/.schemaWorkbench; then mkdir ~/.schemaWorkbench fi # copy mondrian.properties and log4j.xml if necessary if test ! -e ~/.schemaWorkbench/mondrian.properties; then cp mondrian.properties ~/.schemaWorkbench/mondrian.properties fi if test ! -e ~/.schemaWorkbench/log4j.xml; then cp log4j.xml ~/.schemaWorkbench/log4j.xml fi CP=$CP:~/.schemaWorkbench # or # set the log4j.properties system property # "-Dlog4j.properties=path to <.properties or .xml file>" # in the java command below to adjust workbench logging # add all needed JDBC drivers to the classpath for i in `ls drivers/*.jar`; do CP=$CP:$i done echo $CP java -Xms100m -Xmx500m -cp "$CP" -Dlog4j.configuration=file:$HOME/.schemaWorkbench/log4j.xml mondrian.gui.Workbench Reply With Quote </td></tr></tbody></table> |
