US and Worldwide: +1 (866) 660-7555

View Poll Results: Would you use the new "Pentaho Reporting Output" step for Kettle?

Voters
29. You may not vote on this poll
  • Yes!

    29 100.00%
  • No!

    0 0%
  • Where's my BIRT step?

    2 6.90%
  • Where's my Jaspersoft step?

    1 3.45%
  • Where's my Business Objects step?

    1 3.45%
  • Where's my Cognos Step?

    2 6.90%
  • Stop bothering us, stay on the Kettle forum Matt!

    1 3.45%
Multiple Choice Poll.
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 42

Thread: Announcing: Pentaho Reporting Output step for PDI

  1. #1
    Join Date
    Nov 1999
    Posts
    9,727

    Lightbulb Announcing: Pentaho Reporting Output step for PDI

    A simple but effective PDI (Kettle) step to render a PRPT to an output file in your desired output format.

    Screenshot


    Binary
    http://kettle4.s3.amazonaws.com/PentahoReporting.zip

    Installation
    Download PDI 4.1.0-RC1 from sourceforge (tested that one) or a recent trunk CI build.
    Unzip PentahoReporting.zip to the plugins/ folder (no subdirectory, see http://jira.pentaho.com/browse/PDI-4842)

    Source
    http://source.pentaho.org/svnkettler...gPlugin/trunk/
    The old code for PDI 2.4.0 (3 years old) was branched.
    revision 14271 or later.

    Comments
    If you patch 4.0.0 and later with recent libbase-TRUNK and libformula-TRUNK you probably could get it to run on those too.

    TODO
    - Add produced files to transformation result files list. Since the output file is input for the step I suppose it's not that urgent.
    - Add word (RTF) and XLS2007 output options.


    Video by osbi_fr




    Feedback is welcome!.

    Matt
    Last edited by MattCasters; 04-14-2011 at 03:21 PM.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  2. #2

    Default

    That is a feature I really needed, thanks so much!
    I just tested it, it works well with PDF, but when generating an HTML report I can't see the charts. I assumed they would be generated as image files, but I don't see them generated either. Did I miss something?
    Thanks a lot!
    Nicolas Raoul

  3. #3
    Join Date
    Nov 1999
    Posts
    9,727

    Default

    Thanks for testing Nicolas. There seems to be some problem with the Paged (or Directory) HTML option.
    I created a JIRA case to mention this to my colleagues and I hope that this issue will be fixed shortly.

    http://jira.pentaho.com/browse/PRD-3066

    But in any case the idea is indeed that images get created too.

    Take care,
    Matt
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  4. #4

    Lightbulb

    I just wrote how to use this step to automatically send reports to a data warehouse's shops.
    Not a major piece of literature, but well, feedback is welcome :-)
    Hope this can help someone,
    Nicolas Raoul

  5. #5
    Join Date
    Nov 1999
    Posts
    9,727

    Default

    Thanks Nicolas!
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  6. #6
    Join Date
    Aug 2007
    Posts
    12

    Default

    reporting.jpg

    Hi All,

    I have tried the reporting plugin inside PDI 4.01GA/4.10RC1 but it does not seem to be working. I have set all the necessary parameters but no PDF file is generated. pls see the attached image. Also, I noticed that I cannot save a transformation that contained reporting plugin step more than once and will get the following error :

    Unable to save step info to the repository for id_transformation=3
    Unable to save step information to the repository for id_step=9
    Error inserting/updating row
    ORA-00001: unique constraint (TEST1.IDX_STEP_ATTRIBUTE_LOOKUP) violated

    pls advise me.

  7. #7

    Default

    Hi chenkeongyap!

    Stupid question but your report works fine in PRD, right?
    Could you please post your .ktr file so that I can have a look?
    I have no idea about the saving problem though.

    Cheers!
    Nicolas Raoul

  8. #8
    Join Date
    Nov 1999
    Posts
    9,727

    Default

    I figured out what the repository saving problem was, I'll fix it in a few hours.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  9. #9
    Join Date
    Nov 1999
    Posts
    9,727

    Default

    Fixed it (revision 14376), updated the download.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  10. #10
    Join Date
    Aug 2007
    Posts
    12

    Default

    Hi Matt,

    Thanks for the quick response. I've tested revision 14376 using mysql as etl repository and it works perfectly fine. However, if I run the similar transformation inside Oracle 11G and the following errors came out, pls advise me.

    java.lang.reflect.InvocationTargetException: Error saving transformation: org.pentaho.di.core.exception.KettleException:
    Unable to save step info to the repository for id_transformation=73
    Unable to save step information to the repository for id_step=36342
    Error inserting/updating row
    ORA-00001: unique constraint (KETTLE1.IDX_STEP_ATTRIBUTE_LOOKUP) violated


    at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:77)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
    Caused by: org.pentaho.di.core.exception.KettleException:
    Unable to save step info to the repository for id_transformation=73
    Unable to save step information to the repository for id_step=36342
    Error inserting/updating row
    ORA-00001: unique constraint (KETTLE1.IDX_STEP_ATTRIBUTE_LOOKUP) violated


    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:187)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.saveTransformation(KettleDatabaseRepositoryTransDelegate.java:207)
    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:327)
    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.save(KettleDatabaseRepository.java:308)
    at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run(SaveProgressDialog.java:73)
    ... 1 more
    Caused by: org.pentaho.di.core.exception.KettleException:
    Unable to save step information to the repository for id_step=36342
    Error inserting/updating row
    ORA-00001: unique constraint (KETTLE1.IDX_STEP_ATTRIBUTE_LOOKUP) violated

    at org.pentaho.reporting.plugin.PentahoReportingOutputMeta.saveRep(Unknown Source)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.saveStepMeta(KettleDatabaseRepositoryStepDelegate.java:179)
    ... 5 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error inserting/updating row
    ORA-00001: unique constraint (KETTLE1.IDX_STEP_ATTRIBUTE_LOOKUP) violated

    at org.pentaho.di.core.database.Database.insertRow(Database.java:1390)
    at org.pentaho.di.core.database.Database.insertRow(Database.java:1304)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.insertStepAttribute(KettleDatabaseRepositoryConnectionDelegate.java:1247)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.saveStepAttribute(KettleDatabaseRepositoryConnectionDelegate.java:679)
    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.saveStepAttribute(KettleDatabaseRepositoryConnectionDelegate.java:667)
    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.saveStepAttribute(KettleDatabaseRepository.java:1523)
    ... 7 more
    Caused by: java.sql.SQLException: ORA-00001: unique constraint (KETTLE1.IDX_STEP_ATTRIBUTE_LOOKUP) violated
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
    at org.pentaho.di.core.database.Database.insertRow(Database.java:1339)
    ... 12 more

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •