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 9: Line 9:
 
[[Image:Fig1_-_Screenshot-Transaction_Summary.report_-_Designer_1.5.6_-samples-Transaction_Summary.report_-_Pentaho_Report_Designer_1.6.0.png]]
 
[[Image:Fig1_-_Screenshot-Transaction_Summary.report_-_Designer_1.5.6_-samples-Transaction_Summary.report_-_Pentaho_Report_Designer_1.6.0.png]]
  
3.1 The opentaps BI solutions repository is located in <OPENTAPS-HOME>\hot-deploy\pentaho-solutions.  
+
3.1 The opentaps BI solutions repository is located in <OPENTAPS-HOME>\hot-deploy\pentaho-solutions.  
 
[[Image:Fig2 - Screenshot-Publish.png]]
 
[[Image:Fig2 - Screenshot-Publish.png]]
  
3.2 In the previous picture the TransactionSummary report sample is being published in the pentaho-solutions\financials\acctgtrans folder.
+
3.2 In the previous picture the TransactionSummary report sample is being published in the pentaho-solutions\financials\acctgtrans folder.
  
 
==References==
 
==References==

Revision as of 20:50, 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 : Fig1 - Screenshot-Transaction Summary.report - Designer 1.5.6 -samples-Transaction Summary.report - Pentaho Report Designer 1.6.0.png

3.1 The opentaps BI solutions repository is located in <OPENTAPS-HOME>\hot-deploy\pentaho-solutions. Fig2 - Screenshot-Publish.png

3.2 In the previous picture the TransactionSummary report sample is being published in the pentaho-solutions\financials\acctgtrans folder.

References

1. Introducing the Pentaho Report Designer

2. Setting Up Parameters With the Design Studio

To be continued ..