Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Passing Data to a line or Barchart

  1. #1
    Join Date
    Jun 2007
    Posts
    9

    Default Passing Data to a line or Barchart

    Hi

    I have a JSP page that runs a mysql query and stores the data in a ResultSet. I want to be able to format this data and pass the formatted data in possibly an array to the line or barchart chart. Is this possible?

    thanks again
    regards, Mike

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi Mike,

    the Pentaho BI Plattform offers two ways to display charts on a JSP page, although both handle the MySQL query outside the JSP page:

    1. Have a look at the SampleDashboard.jsp. It uses chartHelper functions to create charts. The charts are defined in widgets and an action sequence retrieves the data from the data base.

    2. Have a look at Pentaho's AJAX API documentation. Here an action sequence is used to retrieve the data and build the chart. The JSP page uses the AJAX API to execute the action sequence and gets the chart as a result.

    In an after thought you migt be able to use approach 2 and pass a ResultSet as an parameter to the action sequence instead of retrieving the data within the action sequence. But as far as I know you can't pass an array!?!

    Well, I hope these hints will help you to solve your problem anyway.

    All the best,
    Ingo

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.