PDA

View Full Version : Report Calculations



jwkidd3
01-19-2006, 07:30 AM
Where can I find more information on:

1. Getting Data into Pentaho
2. How complex the calculations are that Pentaho can handle. We have reports that have aggregate values within and across multiple reports.

Thanks for any direction

John

mbatchelor
01-19-2006, 08:55 AM
1. Getting Data into Pentaho
Consult the Creating_Pentaho_Solutions_1.0.0.RC2.pdf that's in the documentation section of our downloads.


2. How complex the calculations are that Pentaho can handle. We have reports that have aggregate values within and across multiple reports.

The answer to this largely depends upon your choice of reporting engine, and your reporting requirements. Within the Pentaho platform, we support multiple reporting engines - Eclipse BIRT, Jaspersoft JasperReports, and JFreeReport (soon to be renamed to Pentaho Reporting).

JFreeReport supports very complex expressions that can be written in Java, or BSH script, and comes with a library of expressions and functions for doing many different thing within your report.

This, coupled with the platform's action-sequence definitions would allow you to perform complex queries and aggregations of data before executing your report. Then, within your report, have additional expressions and function references as required.

We're currently working on comprehensive documentation for Pentaho Reporting - stay tuned!

Hope this helps,

Marc