Difference between revisions of "Using Pentaho with opentaps"

From Opentaps Wiki
Jump to navigationJump to search
(How to design and run a report with the pentaho framework)
(How to design and run a report with the pentaho framework)
Line 1: Line 1:
 
==How to design and run a report with the pentaho framework==
 
==How to design and run a report with the pentaho framework==
  
1. First we need to get the Pentaho Report Designer (stable version 1.5.6) [http://downloads.sourceforge.net/pentaho/PentahoReportDesigner-1.5.6.270-0.zip?use_mirror=mesh Pentaho Report Designer 1.5.6]
+
1. We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :
 +
<!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->
  
2. We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :
+
2. Download the Pentaho Report Designer (stable version 1.5.6) [http://downloads.sourceforge.net/pentaho/PentahoReportDesigner-1.5.6.270-0.zip?use_mirror=mesh Pentaho Report Designer 1.5.6] and the Pentaho Design Studio. Please refer to [http://wiki.pentaho.org/display/COM/Introducing+the+Pentaho+Report+Designer Introducing the Pentaho Report Designer] and [http://wiki.pentaho.org/display/COM/Setting+Up+Parameters+With+the+Design+Studio Setting Up Parameters With the Design Studio] for insight into downloading and using this tools.
<!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->
 
  
3. Configuration of the database connection for the Pentaho Report Designer tool :
+
3. After having designed the report publish it to the opentaps BI solutions repository :
*3.1 Unzip the Report Designer you have downloaded to a directory we will call <REPORT-DESIGNER-HOME>
 
*3.2 Drop your JDBC database driver in <REPORT-DESIGNER-HOME>/lib/jdbc
 
  
4. Run the Pentaho Report Designer application
 
  
 
5. You should be able to see this screen on your computer :
 
5. You should be able to see this screen on your computer :

Revision as of 20:31, 23 September 2007

How to design and run a report with the pentaho framework

1. We need to activate the opentaps pentaho component by uncommenting the following line in hot-deploy/component-load.xml :

<!-- <load-component component-location="${ofbiz.home}/hot-deploy/pentaho"/> -->

2. Download the Pentaho Report Designer (stable version 1.5.6) Pentaho Report Designer 1.5.6 and the Pentaho Design Studio. Please refer to Introducing the Pentaho Report Designer and Setting Up Parameters With the Design Studio for insight into downloading and using this tools.

3. After having designed the report publish it to the opentaps BI solutions repository :


5. You should be able to see this screen on your computer : Fig1 - Screenshot-Pentaho Report Designer 1.5.6.png

6. Create a Dataset to source the data you want on your report : Fig2-Pentaho Report Designer 1.5.6.png Fig3-Report Designer 1.5.6.png

References

1. Introducing the Pentaho Report Designer

2. Setting Up Parameters With the Design Studio

To be continued ..