Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Pentaho reporting - where to start

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Pentaho reporting - where to start

    Hello Everyone,

    I am interested in learning more about Pentaho reporting. However, unlike PDI I cannot find nice entry point (even on the forum).

    Could anybody share an opinion?

    Basically, I know how to use PDI, but how do I produce a report?

    Regards,
    Alex

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Alex,

    There are 3 different major areas to Pentaho Reporting.
    1) Creating Canned Reports (This is done in Pentaho Report Designer)
    2) On-Demand Running of Canned Reports (This is done by the user directly in Pentaho User Console, which requires BIServer to be installed)
    3) Scheduled running of canned reports (This can be done from Pentaho User Console / BIServer, or with PDI using the reporting step)

    There are other directions you can still go (Ad-Hoc Reporting, OLAP Reporting, etc) but getting yourself comfortable with the 3 above will help you a lot with the others.

    I found getting into Pentaho Report Designer (PRD) was the easiest place for me to start, but I do data-processing and come from a Cognos background. Depending on your background, something else might be easiest.

    How do you think about the way that data comes together?

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you gutlez,

    I do not think I understand your question correctly, but here is what I can guess: data comes from databases and files (.txt, .csv, .xls). It is human being responsibility to put it together.

    I will probably start from here

    http://wiki.pentaho.com/display/Repo...r+First+Report

    By the way, I downloaded report designer and immediately got an error connecting to MS SQL server with JDBC driver (I did the same in PDI with your help and did not have any problems) Here is the error. I wonder if you could help:


    Error connecting to database [AnalysisDataDB] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Exception while loading class
    net.sourceforge.jtds.jdbc.Driver


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Exception while loading class
    net.sourceforge.jtds.jdbc.Driver


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:374)
    at org.pentaho.di.core.database.Database.connect(Database.java:323)
    at org.pentaho.di.core.database.Database.connect(Database.java:285)
    at org.pentaho.di.core.database.Database.connect(Database.java:275)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2455)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
    at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.Dialog$1.run(Unknown Source)
    at java.awt.Dialog$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Dialog.show(Unknown Source)
    at java.awt.Component.show(Unknown Source)
    at java.awt.Component.setVisible(Unknown Source)
    at java.awt.Window.setVisible(Unknown Source)
    at java.awt.Dialog.setVisible(Unknown Source)
    at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234)
    at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open(XulDatabaseDialog.java:256)
    at org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$AddDataSourceAction.actionPerformed(ConnectionPanel.java:255)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.Dialog$1.run(Unknown Source)
    at java.awt.Dialog$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Dialog.show(Unknown Source)
    at java.awt.Component.show(Unknown Source)
    at java.awt.Component.setVisible(Unknown Source)
    at java.awt.Window.setVisible(Unknown Source)
    at java.awt.Dialog.setVisible(Unknown Source)
    at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcDataSourceDialog.performConfiguration(JdbcDataSourceDialog.java:661)
    at org.pentaho.reporting.ui.datasources.jdbc.JdbcDataSourcePlugin.performEdit(JdbcDataSourcePlugin.java:67)
    at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:79)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.AbstractButton.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.awt.EventQueue$2.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Exception while loading class
    net.sourceforge.jtds.jdbc.Driver

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:429)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:358)
    ... 119 more
    Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:420)
    ... 120 more

    Hostname : 10.1.144.11
    Port : 1433
    Database name : AnalysisDataDB

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by august_month View Post
    Exception while loading class
    net.sourceforge.jtds.jdbc.Driver
    This indicates that PRD can't find your JAR file. you have to put it in the /PRD/lib folder (from what I recall - I don't have access to PRD any more) Unlike PDI, PRD does not ship the jTDS driver, so you have to supply it.

    My question is wondering how you think... I understand basic reports as a document that has data fields to be filled in. Others can't understand it that way. I was trying to figure out which tool to point you towards first.

    If you download and work with BIServer, the sample data will give you a good idea of the big picture - how all the pieces come together.

  5. #5
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you again, gutlez!


    This indicates that PRD can't find your JAR file. you have to put it in the /PRD/lib folder (from what I recall - I don't have access to PRD any more) Unlike PDI, PRD does not ship the jTDS driver, so you have to supply it.
    I unzipped drivers you gave me before to jtds folder and copied whole folder to PRD/lib and also I took .jar file and copied by itself to PRD/lib folder. I do not know what was the right path, but it worked.

    I understand basic reports as a document that has data fields to be filled in
    I like the way you put it. I am going to borrow your way thinking.


    1) Creating Canned Reports (This is done in Pentaho Report Designer)

    3) Scheduled running of canned reports (This can be done from Pentaho User Console / BIServer, or with PDI using the reporting step)
    I am going to concentrate on this two steps. I will BI server for later.


    Regards,
    Alex

  6. #6
    Join Date
    May 2007
    Posts
    11

    Default

    Just got the book Pentaho Reporting 3.5 for Java Developers (and I am new to this) but can't get past Chapter 3? Just get error when attempting to connect to the example DB downloaded from the packt site -
    I have
    Cont. Name - ElectroBarn
    cont. type - Hypersonic
    Host name - file;
    DB name - the path to c:\...\electrobarn
    Port. no. - <blank>
    username - sa
    password - <blank>

    and I get the mysterious error

    Error connecting to database [ElectroBarn] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class org.hsqldb.jdbcDriver)
    SOO10 Invalid argument in JDBC call

    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class org.hsqldb.jdbcDriver)
    SOO10 Invalid argument in JDBC call

    running on windows 7

    thanks - not sure where to post this question

    Walker

  7. #7
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    The database dialog assumes that you communicate with your database via a network. It does not support the file-mode of Hypersonic-SQL.

    As a workaround select the database type "Generic database".

    Custom connection url:
    jdbc:hsqldb:<path to your database file>

    example:
    jdbc:hsqldb:./sampledata/sampledata


    Custom Driver class name: org.hsqldb.jdbcDriver
    Username: sa
    Password: <blank>
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  8. #8
    Join Date
    May 2007
    Posts
    11

    Default

    WOW - you are most helpful -

    The book has no erata page / files yet; however, I will submit the above and hopefully you will have helped 100's ( or 1000's at least for the author's and Packt's sake) of other readers.

    Walker

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.